define clustering index.
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is Skeleton cursor table (SKCT)?
Explain about cursor stability?
What is db2? Explain.
What is COPY PENDING status?
What is null indicator in db2?
What is db2 bind?
Explain the function of data manager.
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is meant by isolation level?
How do I connect my db2 database to ibm?