Correct Answer: RUNSTATS
Explanation:
Note: This Question is unanswered, help us to find answer for this one
DB2 Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More DB2 Administration MCQ Questions
What is the primary focus of performance tuning, and how should performance tuning should take place?
What is an example of an instance when the database manager would allocate memory?
REORG is a function that organizes data on physical storage to recluster rows, positioning overflowed rows to reclaim space and to free up space. When is it used?
When is it best to tune your system?
Parameter that would specify the maximum size of a memory segment?
Where is the output of EXPLAIN stored?
A DBA issues the command:-DIS DB(DSNDB06) SPACE(*) LOCKS. In the LOCKINFO field the following data is reported: H-IS,S,C. When Will the lock first be released by DB2?
What does sqlcode -922 denote?
What does the term IMAGECOPY mean?
Which is true when joining a table with DB2 Relational Connect function?