When does space reclamation for a column-organized table normally occur?
When does space reclamation for a column-organized table normally occur?
which software license must be registered?
When using SQU and JDBC applications to connect to the host DB2 database, which software license
must be registered?
What are three reasons why this is happening?
You are unable to configure a data source using DB2 Discovery What are three reasons why this is
happening? (Choose three.)
What are the correct steps to capture EXPLAIN information for column-organized tables?
What are the correct steps to capture EXPLAIN information for column-organized tables?
What are two valid protocols that can be used with the CATALOG NODE command to establish communication with a
What are two valid protocols that can be used with the CATALOG NODE command to establish
communication with a server named SERVER1? (Choose two.)
which two capabilities are available?
If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale
database, which two capabilities are available?
What will collect information about dynamic and static SQL statements?
What will collect information about dynamic and static SQL statements?
Which monitoring function can be used to determine how many times an SQL statement has referenced a particular
Which monitoring function can be used to determine how many times an SQL statement has
referenced a particular column-organized table within a specific period of time?
What are two purposes of the db2mtrk command?
What are two purposes of the db2mtrk command? (Choose two.)
Which two tasks can DB2 Workload Management do?
Which two tasks can DB2 Workload Management do? (Choose two.)