what types of copies can be made with the COPY Utility ?
Explain the EXPLAIN statement?
What does a deadlock mean in DB2?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
Mention some fields that are a part of sqlca.
What is alias in db2?
What is a Resource Control Table(RCT)? Describe its characteristics.
What are delete-connected tables?
When will you chose to run RUNSTATS?
What is the difference between Where and Having Clause
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
How to restart a DB2 program?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?