PrepAway - Latest Free Exam Questions & Answers

what could be causing this problem?

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.)

PrepAway - Latest Free Exam Questions & Answers

A.
The table space that was selected to store the DGTT in the TEMP database is too small to
store all the rows of the DGTT.

B.
The WORKFILE database is too small.

C.
There is too much concurrent activity against the TEMP database to be able to handle all the
DGTT activity that is going on.

D.
The user is exceeding the maximum amount of temporary space that can be used by an agent
(MAXTEMPS) DSNZPARM setting.

E.
There are too many DB2 utilities running at the same time as the job inserting rows into the
DGTT.


Leave a Reply