what types of copies can be made with the COPY Utility ?
Define predicate?
What happens to the PLAN if index used by it is dropped?
What is UNION,UNION ALL?
What is DCLGEN ?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
Explain about mirror activator disk mirroring?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
Define check constraint.
How is deadlock resolved?
Describe what a storage group(STOGROUP) is?
What are some characteristics of columns that benefit from indexes?
What happens in bind step in a db2 program?