Given this statement:
RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH
Which statement is FALSE?
Answer : C
In order to use a literal replacement for a dynamic SQL caching statement what must be true about the statement?
Answer : D
When would DB2 NOT use list prefetch?
Answer : B
You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement:
ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5;
What should be your next step?
Answer : D
An application receives an 00C90110 reason code. See the following manual explanation of the code.
Answer : D
" 00C90110Explanation:The data manager detected an inconsistent data condition. This may be caused by an inconsistency in either the DB2P' catalog or the DB2 directory. In this case, the OBD for the requested OBID cannot be located in the database descriptor (DBD).
The DBD in storage may be inconsistent. Specifically, the OBDDMAP(OBID) array element should contain an offset into the DBD where the OBD should be located. However, in this case the OBD expected was not at the indicated offset.To prevent further damage and possible loss of data, the inconsistency must be corrected before any further SQL access is attempted to this database."
Even though the problem cannot be recreated, you still want to find out what caused this and you want to collect additional information for the IBM support team.
Which utilities and service aids CANNOT help to provide useful additional info to diagnose the problem?
A. REPAIR -
B. REPORT -
C. DIAGNOSE -
D. DSN1LOGP -
Answer: C -
Which table characteristic is a good attribute for the exploitation of hash access?
Answer : D
When we use multilevel-security using a security label column, which sentence is true?
Answer : C
The data of a critical table space seems inconsistent. It is suspected that someone has accidentally issued a DB2 command to start the object with MODE(FORCE).
Where can this be verified?
Answer : B
Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains route numbers and the maximum speed limit for each route?
Answer : B
The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?
Answer : B
What subsystem parameter in DDF specifies the maximum number of inactive or new connections queued that can be waiting for a DBAT to process the request?
Answer : D
Which address space should be classified with the highest priority WLM service class?
Answer : B
What is the least disruptive way of externalizing real-time statistics for table space
DB1TS1?
Answer : C
Which global variables statement is true?
Answer : B
Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the results in a data set or as a result set?
Answer : C
Reference:
http://www.redbooks.ibm.com/redbooks/pdfs/sg248151.pdf (page 72, see the table)