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?