Which statement about the value of NUMTCB is correct?
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?
what is indicated?
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?
What IBM provided stored procedure will access DB2 real time statistics tables?
Which information is part of the DSN_STATEMENT_CACHE_TABLE?
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 performan
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?
When is a merge scan join a well performing access path?
What trace class will show deadlock information?
What trace class will show deadlock information?
Which DSNZPARM will define the number of RID Blocks in the RID Pool?
Which DSNZPARM will define the number of RID Blocks in the RID Pool?
which prefetch method is used more often?
When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method
is used more often?
which of the following commands could be used?
In order to retain an access path across a rebind which of the following commands could be used?