Your shop has a mixture of REXX, COBOL and native SQL procedures. For performance reasons
the COBOL stored procedures must be configured to allow more than one concurrent stored
procedure execution for each address space started by WLM. What is the minimum number of
different WLM stored procedure address space JCL set(s) that must be defined to accomplish this?

You are planning for the execution of multiple concurrent RECOVER jobs (e.g., during DB2
disaster recovery). Which DSNZPARM parameter allows for the most Fast Log Apply storage to
be allocated to each RECOVER job?

A customer is performing a disaster recovery test using the RESTORE SYSTEM utility. Where
would the BSDS be recovered from in this scenario?

What are three characteristics of DB2 9 native SQL procedures? (Choose three.)

Batch jobs regularly fail when they are in the process of inserting a large number of rows into a
DECLARE GLOBAL TEMPORARY TABLE. (DGTT) Which two statements accurately describe
what could be causing this problem? (Choose two.)

A new application will be implemented that delivers 50 new statically bound plans and 500 new
statically bound packages. Which two DB2 parameters and related storage areas should be
reviewed as directly relating to the new plans and packages? (Choose two.)

A customer is having performance problems with a particular statically bound batch package.
This batch program is processing transactions from a sequential file where each input record ends

up updating one row in a 10 million row table. The sequential file contains 5000 records.
The customer reviews the accounting record information and notices that class 1 elapsed time is 2
hours, class 2 elapsed time is 1 hour 50 minutes and class 3 elapsed time is 1 hour, 45 minutes.
Which statement regarding the problem could be true?

A distributed task fails with a DSNL511I error, a TCP/IP conversation has failed. This problem was
not reported until a few days after the problem actually occurred.. Where would you find the IP
address, TCP/IP port, the DB2 module that issued the message, and the TCP/IP error condition as
you begin resolution of this issue?

The group buffer pool structures, GBP0, GBP1, and GPB2 reside in CF1 for a data sharing group
DG0P. The LOCK and the LIST structures reside in CF2. AUTOREC is set to YES. The group
buffer pools are not duplexed. CF1 fails due to a microcode problem and noneof the GBPs are
available. Which statement is true?

A normally well running application using packages is experiencing longer than normal elapsed
times because of a possible wait. Other DB2 applications are running within acceptable limits.
Which trace output could be analyzed to determine the change in behavior?