Which three statements are correct for automatic management of buffer pool storage in DB2 9?
Which three statements are correct for automatic management of buffer pool storage in DB2 9?
(Choose three.)
which series of tasks could you run to analyze and resolve the problem?
There is a suspected problem with catalog table space DSNDB06.SYSDBASE. Should a problem
be discovered, which series of tasks could you run to analyze and resolve the problem?
Which privilege is required to use the ACCESS command?
Which privilege is required to use the ACCESS command?
Which table space must be recovered next?
You have to recover your complete DB2 system by image copies and the RECOVER utility. You
start the recovery with DSNDB01.SYSUTILX and DSNDB01.DBD01. Which table space must be
recovered next?
which two DB2 address spaces may the execution of a DB2 stored procedure occur?
Within which two DB2 address spaces may the execution of a DB2 stored procedure occur?
(Choose two.)
Which two accounting trace classes must be active when tracing package and DBRM related activity?
Which two accounting trace classes must be active when tracing package and DBRM related
activity? (Choose two.)
Which statement is correct?
You create a system level point-in-time recovery conditional restart control record with SYSPITR
value of FFFFFFFFFFFF. Afterwards, you run the RESTORE SYSTEM utility. Which statement is
correct?
What is a benefit of using the in-memory work file in DB2 9?
What is a benefit of using the in-memory work file in DB2 9?
Hichstatement describes the appropriate action to take?
A user job runs a very long time without commit and then the application bends. The job pdated a
critical table that is used by many applications. The back out is taking a long ime. Hichstatement
describes the appropriate action to take?
Which two statements are true?
You are migrating your DB2 subsystem from version 8 to DB2 9. You have already used the
userdefined RTS tables in version 8 and you are planning to also use RTS in version 9. Which two
statements are true? (Choose two.)