How do you enable parallelism in a dynamic SQL statement?
How do you enable parallelism in a dynamic SQL statement? A. BIND with DEGREE(1) B. BIND with DEGREE(ANY) C. Use SET CURRENT DEGREE = ANY D. Use SET CURRENT DEGREE = ‘1’
C2090-612
What command can be used to research the details behind the database I/O time associated with the new billing application?
The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class 3 Synchronous database I/O time. All of the DB2 objects for the new billing application are in BP5. What command can be used to…
What must be in place for the support of index compression?
What must be in place for the support of index compression? A. User defined algorithm. B. Compression dictionary. C. Table space compression. D. Page size larger than 4K.
When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes?
When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes? A. DIAGNOSE B. DSN1COMP C. DSN1PRNT…
When is a merge scan join a well performing access path?
When is a merge scan join a well performing access path? A. When the number of qualifying rows of the inner and outer table are both large. B. When the query references at least two dimensions and the STARJOIN subsystem…
Which action should be performed but will avoid using excessive CPU resources to gather the information?
In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information? A. Turn on a monitor trace. B. Always have a performance trace running. C.…
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)? A. Does not apply to threads that were defined with RELEASE(COMMIT). B. Does not apply to threads that were defined with RELEASE(DEALLOCATE). C. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at…
Which statement is NOT true?
Which statement is NOT true? A. REORG table space to materialize pending definition changes for a table space. B. REORG with SHRLEVEL CHANGE would automatically detect which threads need to be canceled before switch phase. C. DSNACCOX can be used…
Which statistics should NOT be considered?
For monitoring space growth over time, which statistics should NOT be considered? A. SYSIBM.SYSTABLEPART_HISTCARDF, SPACEFSYSIBM.SYSINDEXPART_HISTCARDF, SPACEF B. SYSIBM.SYSTABLEPARTCARDF, SPACEFSYSIBM.SYSINDEXPARTCARDF, SPACEF C. SYSIBM.SYSTABLESPACEDSSIZE, AVGROWLENSYSIBM.SYSINDEXESPIECESIZE, AVGKEYLEN D. SYSIBM.SYSTABLESPACESTATSSPACESYSIBM.SYSINDEXSPACESTATSSPACE
What does this status mean?
A table space is in AREO*. What does this status mean? A. A full image copy of the table space must be taken. B. The table space should be reorganized for optimal performance. C. A START command must be issued…