What's the maximum number of volumes that can be added to a
STOGROUP?
Could anyone clearly explain the diference between sub query and correlated sub query?
What do you need to do before you do EXPLAIN?
What are column-name qualifiers used?
What is runstats utility in db2?
What is dbrm? What it contains? When it will be created?
How does one remove entries from the SCT02 table?
how do you resolve -805?
Mention the various locks that are available in db2.
Define predicate?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is difference between alias and synonym in db2?
How can record locking be achieved in those DB2 versions which do not support it?