PrepAway - Latest Free Exam Questions & Answers

Which statement regarding the problem could be true?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
DASD contention could be the result of the poor performance problem.

B.
The access path for the package is not optimal; high CPU is causing the problem.

C.
The batch program appears to have a logic error; the difference betweenclass 2 elapsed and
class 3 elapsed shows only 5 minutes of time actually executing in DB2.

D.
The scenario as described does not indicate that there is a performance problem; all of the
elapsed time figures appear to be normal.


Leave a Reply