What catalog table provides the information about missing or conflicting catalog statistics for SQL statements? A. SYSIBM.SYSGUERYSEL B. SYSIBM.SYSTATFEEDBACK C. SYSIBM.SYSVARIABLES_TEXT D. SYSIBM.SYSOUERYPREDICATE

Which group of DB2 ACCOUNTING trace CLASSES must be started to collect accounting information for PLANS and PACKAGES? A. CLASS(2, 7,8) B. CLASS(1,2,3) C. CLASS(1, 5,10) D. CLASS(1,2, 3,7,8)

You have defined the array type PHONENUMBERS using the following DDL: CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50]; You also defined a variable named RECENT_CALLS based on this new array type as follows: CREATE VARIABLERECENT_CALLS PHONENUMBERS: Which SQL statement would you…

DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000’x is reached and an object’s RBA remains in basic 6-byte format What processing is NEVER allowed? A. Changes to the BSDS. B. RECOVER to CURRENT.…

You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the number of short prepares? A. MAXRBLK B. MAXKEEPD C. MAXTEMPS D. CONTSTOR

Which technique can be utilized for the reporting of real-time statistics? A. Call stored procedure SYSPROC.DSNACCOX. B. Call stored procedure SYSPROC.ADMINJNFOJHOST. C. Query the SYSI BM.SYSTABSTATS system catalog table. D. Query the SYSIBM.SYSTABLES_PROFILES system catalog table.

Which DB2 subsystem parameter is used to control the number of concurrent inbound DDF connections? A. MAXDBAT B. CTHREAD C. CONDBAT D. CONTSTOR

What can you accomplish with the stored procedure ADMIN_UTL_MONITOR? A. This stored procedure helps you monitor currently running threads. B. You can create a detailed report of currently running and stopped utilities. C. This stored procedure materializes SYSIBM.SYSSTATFEEDBACK for the…

What is the minimum buffer pool page size for a compressed index? A. 4K B. 8K C. 1 6K D. 32K

Which DB2 Client command can be used to identify the Client’s version? A. db2fm B. db2look C. db2level D. db2ldcfg