What is the database descriptor?
Answers were Sorted based on User's Feedback
Answer / abhisek
Database Descriptor is a DB2 component that limits access
to the database whenever objects are created,altered or
dropped.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / deepika
A DBD also contains other information about accessing tables in the database. DB2 creates and updates DBDs whenever their corresponding databases are created or updated.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can a Db2 table data be retrived through JCL?
Why cursor is used in db2?
Define buffer pool.
What is check constraint. Explain with example.
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
Differentiate between cs and rr isolation levels? Where do you specify them?
What is an instance in db2?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
How are write I/Os from the buffer pool executed?
Explain about dbrm.
How to execute stored procedure in db2 command editor?