IBM C9050-549 問題集

質問 1：
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. DASD contention could be the result of the poor performance problem.
B. The batch program appears to have a logic error; the difference between class 2 elapsed and class 3
elapsed shows only 5 minutes of time actually executing in DB2.
C. The access path for the package is not optimal; high CPU is causing the problem.
D. The scenario as described does not indicate that there is a performance problem; all of the elapsed
time figures appear to be normal.
正解：A

質問 2：
The DB2-supplied SQL Procedure Processor stored procedure DSNTPSMP requires which two for
execution? (Choose two.)
A. Java Virtual Machine
B. Optimization Service Center
C. Workload Manager SPAS with NUMTCB=1
D. DB2 for z/OS REXX Language Support
E. Workload Manager SPAS with NUMTCB > 1
正解：C,D

質問 3：
An accounting trace shows a high get page per SQL ratio for a query which retrieves just one row each
time it is executed. Which two situations could account for the high ratio? (Choose two.)
A. Use of a single column index that is a GENERATED ALWAYS identity column.
B. Use of a matching unique index scan.
C. Use of an index with high cardinality.
D. Use of an index with low cardinality.
E. Use of a nonmatching index scan.
正解：D,E

質問 4：
A customer has just migrated their DB2 system to V9 new function mode. They currently use the
BACKUP SYSTEM utility and have optionally dumped the backup to tape. Which action should be
performed to only use the system level backup that was taken to disk?
A. Use the TAPEDUMP(NORECSYS) keyword on the BACKUP SYSTEM utility when thebackup is taken.
B. Use the BACKUPTYPE(DASD) keyword on the RESTORE SYSTEM utility.
C. Set the RESTORE_RECOVER_FROMDUMPsystem parameter to NO.
D. Run the DSNJU003 utility and modify the system point in time backup record to have
DUMPSTATE=NONE.
正解：C

質問 5：
Click the Exhibit button.
In the exhibit, a customer has a two way data sharing group running with one internal coupling facility (ICF)
and one external coupling facility (CF). The only CF structures allocated are the ones depicted in the
exhibit. ICF1 is a volatile CF. No ARM policy is active. The customer experiences a power failure to CEC1.
Which statement regarding the state of data sharing group DB2G is true?
A. Member DB2A will terminate, DB2B remains active and able to process work. Structure DB2G_SCA
will be automatically rebuilt to the external CF.
B. Member DB2A will terminate but since this is a data sharing system, DB2B remains active and able to
process work. DB2G_SCA will remain in CEC1 since it is in different partition than LPAR1.
C. Member DB2A will automatically be restarted on CEC2 and work will continue to be processed by both
members.
D. Member DB2A and member DB2B both abnormally terminate and are unable to process work until
restarted.
正解：D

質問 6：
The DISPLAY DATABASE command is issued and you see that there are several objects in GRECP
status. What should you do to correct the problem?
A. Run the REPAIR utility against the objects with GRECP status to change the status.
B. Issue a START DATABASE command specifying the objects with GRECP status.
C. Run the MODIFY utility against the objects with GRECP to correct the status.
D. Set the DSNZPARM AUTOREC to YES and DB2 will automatically correct the status.
正解：B

質問 7：
The total number of threads accessing data that can be allocated concurrently is the sum of which
combination of DB2 parameters?
A. IDBACK and IDFORE
B. MAXDBAT and CONDBAT
C. MAXKEEPD and MAXOFILR
D. MAXDBAT and CTHREAD
正解：D