Online Access Free C1000-078 Practice Test

During DB2 restart, it is observed that it takes a significant amount of time to complete. Which of the following could be tuned to improve restart time?

• A.Specify LOCKSIZE ANY for DB2 objects
• B.Reduce system checkpoint interval
• C.Specify LBACKOUT=NO
• D.Specify CURRENTDATA(YES)

For best DB2 lock avoidance, which of the following BIND/REBIND options should be included in the REBIND command execution?

• A.CURRENTDATA(NO)ISOLATION(CS)
• B.ACQUIRE(USE)ISOLATION(RR)
• C.ACQUIRE(USE)ISOLATION(CS)
• D.CURRENTDATA(YES) ISOLATION(CS)

Which subsystem parameter specifies whether DB2 is to create new table spaces and indexes to use a basic or extended log record format?

• A.EXTSEC
• B.OBJECT_CREATE_FORMAT
• C.CHKLOGR
• D.UTILITY OBJECT CONVERSION

Az/OS system has some storage constraints. The results of-DIS
STATS(INDEXMEMORYUSAGE) shows that a huge amount of storage is used for the fast index traversal processes. What can be done to avoid this storage usage?

• A.Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION COMPATIBILITY V12R1M500 for the listed indexes
• B.Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE
• C.Set subsystem parameter INDEX_CLEANUP_THREADS to 0
• D.Reorganize the listed indexes

Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0?

• A.DB2 will use the value specified for the PARAMDEG subsystem parameter to control the degree of parallelism when DPSI is used
• B.The DB2 optimizer will not consider DPSI for access path selection
• C.Parallelism for DPSI is disabled
• D.DB2 creates multiple child tasks but works on one task at a time when DPSI is used to drive parallelism