最新なIBM C2090-549問題集（103題）、真実試験の問題を全部にカバー！

質問 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. 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.
B. The scenario as described does not indicate that there is a performance problem; all of the elapsed time figures appear to be normal.
C. DASD contention could be the result of the poor performance problem.
D. The access path for the package is not optimal; high CPU is causing the problem.
正解：C

質問 2：
What is the recommended relative address space (highest to lowest) dispatching priority for these components?
A. IRLM, DB2 performance monitors, DBM1, MSTR
B. MSTR, IRLM, DB2 performance monitors, DBM1
C. IRLM, MSTR, DB2 performance monitors, DBM1
D. DBM1, IRLM, MSTR, DB2 performance monitors
正解：A

質問 3：
Your accounting report shows that a large component of class 3 wait time for an application is service task switch time. For which type of contention should you be looking?
A. logging
B. open/close data set
C. system catalog
D. asynchronous read
正解：B

質問 4：
You want to audit activity against a table named owner.TABLEX. Which two actions are required?
(Choose two.)
A. Run ALTER owner.TABLEX LOG ALL.
B. Run ALTER owner.TABLEX DATA CAPTURE CHANGES.
C. Run DSN1LOGP against the DB2 log data sets covering the timestamp being audited.
D. Run START TRACE AUDIT CLASS (4,5).
E. Run ALTER owner.TABLEX AUDIT ALL.
正解：D,E

質問 5：
Which two statements are true regarding a traditional image copy disaster recovery in a data sharing environment? (Choose two )
A. When using change log inventory (DSNJU003), the latest log record sequence number that can be used is the oldest last written log record of all members participating in the restart.
B. The catalog and directory must be recovered by first data sharing member brought up at the disaster recovery site and all other members must not be started before this recovery is finished.
C. All members defined to the data sharing group must be restarted at the disaster recovery site.
D. Only one conditional restart control record (CRCR) needs to be created for the data sharing group and all DB2 members will utilize this CRCR during restart.
E. SETXCF FORCE commands should be used to purge DB2 coupling facility structures prior to staring the first DB2 member.
正解：A,E

質問 6：
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. EDMPOOL
B. EDMSTMTC
C. EDM_SKELETON_POOL
D. HOPAUTH
E. DSMAX
正解：A,C

質問 7：
DB2 issues a message indicating that the subsystem is in single BSDS mode. Which steps should be performed after the damaged BSDS has been deleted and defined?
A. REPRO the most recent archived copy of the BSDS to the new data set.
B. Issue the -RECOVER BSDS command.
C. REPRO the single BSDS being used by the DB2 subsystem.
D. Use -STOP DB2, then use -START DB2.
正解：B