What is db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is RUNSTATS?
What is performance tuning db2?
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 buffrpool? Where we use it ?
Explain the function of data manager.
What does the CHECK Utility do ?
Describe what a storage group(STOGROUP) is?
What is role in db2?
What is the meaning concurrency in the db2 database?
What is a system catalog table in db2?
How is a typical DB2 batch program executed ?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.