×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
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?
2.
If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?
3.
What IBM provided stored procedure will access DB2 real time statistics tables?
4.
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?
5.
When is a merge scan join a well performing access path?
6.
What trace class will show deadlock information?
7.
When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?
8.
In order to retain an access path across a rebind which of the following commands could be used?
9.
The available window to reorganize table spaces is being reduced. What data can provide information to allow for a priority list of candidate table spaces for reorganization based on recent activity with no recent RUNSTATS execution?
10.
Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?