IBM C9050-549 問題集

質問 1：
Your administrative scheduler shows message DSNA679I indicating that one or both copies of your task
lists is not accessible or is corrupted. Your analysis shows that only the VSAM file is corrupt, but the
ADMIN_TASKS table is still operational. Which statement describes how to correct this situation?
A. Create an empty version of the VSAM task list and use DB2 command -RECOVER TASKLIST to
recover the content of the ADMIN_TASKS table.
B. Create an empty version of the VSAM task list and let DB2 perform an autonomic recovery using the
content of the ADMIN_TASKS table.
C. Create an empty version of the VSAM task list and use REPRO utility to copy the contents of the VSAM
cluster containing the ADMIN_TASKS table.
D. No manual interaction is needed as long as the ADMIN_TASKS table is still accessible.
正解：B

質問 2：
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

質問 3：
A customer is performing a disaster recovery test using the RESTORE SYSTEM utility. Where would the
BSDS be recovered from in this scenario?
A. The most current active log data set.
B. The second data set created from the last -ARCHIVE LOG command.
C. The SMS log copy pool backup.
D. The image copy data set of the catalog and directory.
正解：C

質問 4：
In a DB2 non-data sharing system you want to activate changes to DB2 early code in DB2 9.
Which command sequence would you issue to activate this code?
A. -STOP DB2; -REFRESH DB2,EARLY; -START DB2
B. -REFRESH DB2,EARLY
C. -START DB2; -REFRESH DB2,EARLY
D. -REFRESH DB2,EARLY; -STOP DB2; -START DB2
正解：A

質問 5：
Which two parameters are used for buffer pool page management? (Choose two.)
A. PGIO
B. PGSAVE
C. PGOPTION
D. PGFIX
E. PGSTEAL
正解：D,E

質問 6：
Which online or stand-alone utility can be used to reset a page set level-id?
A. REPAIR
B. REORG
C. MODIFY RECOVERY
D. DSN1SDMP
正解：A

質問 7：
A system is running low on active logs and you need to add active logs to provide some relief.
What would be the appropriate action to achieve this?
A. Allocate the new active log data sets using IDCAMS, change the ACTLGNUM DSNZPARM to a higher
value, and issue the -SET SYSPARM LOAD (new-zparm-mod) command.
B. Allocate the new active log data sets using IDCAMS, change the ACTLGNUM DSNZPARM to a higher
value, and issue the -SET SYSPARM RELOAD command.
C. Allocate the new active log data sets using IDCAMS, change the ACTLGNUM DSNZPARM to a higher
value, stop DB2, and add the active log names then start DB2.
D. Allocate the new active log data sets using IDCAMS, stop DB2, add the active log names then start
DB2.
正解：D