Workload Manager (WLM) manages how many concurrent stored procedures can run in an
address space and the number of concurrent stored procedures in an address space cannot
exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?
If a single row of the PLAN_TABLE has a ‘Y’ value in more than one of the sort composite
columns, what is indicated?
What IBM provided stored procedure will access DB2 real time statistics tables?
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which
information is part of the DSN_STATEMENT_CACHE_TABLE?
Which two of the following DB2 performance features will ignore clustering in favor of faster insert
performance? (Choose two.)
When is a merge scan join a well performing access path?
What trace class will show deadlock information?
Which DSNZPARM will define the number of RID Blocks in the RID Pool?
When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method
is used more often?
In order to retain an access path across a rebind which of the following commands could be used?