最新な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：
Under which condition would the -RECOVER INDOUBT command be necessary?
A. When the commit coordinator is not available to notify DB2 of the correct commit or abort action.
B. When in-doubt threads have been resolved and DB2 cannot synchronize with the commit coordinator.
C. When the commit coordinator is not able to determine if threads should be committed or aborted.
D. When a thread has failed and has single phase commit scope.
正解：A

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

質問 4：
Using the sample IBM supplied authorization exit, which authorization ID setting will be ensured?
A. The initial primary authorization ID is unchanged as the DB2 primary ID, and the SQL ID is made equal to the DB2 primary ID, and one secondary ID exists and is the name passed by CICS or IMS.
B. The initial primary authorization ID remains the primary ID, the SQL ID is set equal to the primary ID, and the list of DB2 secondary IDs is set to the list of group names to which the RACF user ID is connected.
C. The initial primary authorization ID is set to the same value as the first secondary ID.
D. The initial primary authorization ID remains the primary ID, the SQL ID is set equal to the RACF ID of the DB2 subsystem.
正解：B

質問 5：
Which case would require you to perform a DB2 conditional restart?
A. During restart, the back out phase is taking too long because a long running job that executed many updates and never committed. The only way to bypass the long back out phase is to perform a conditional restart with BACKOUT=NO.
B. The system suffered an outage because of a DASD subsystem failure. The logs are available but not the table spaces and index spaces.
C. The DB2 system fails during normal processing because of an exceptional peak in the workload. Normal restart abends in the log apply phase whenever DB2 is started.
D. The DASD subsystem has experienced a major problem and the primary active log data sets are lost. A peer-to-peer remote copy (PPRC) is not available.
正解：C

質問 6：
What does the IMS control region do when a write I/O error occurs on a HDAM database?
A. A batch image copy of the affected data base is immediately started by IMS.
B. The data base is immediately stopped until a recovery can be completed.
C. IMS copies the error buffer contents into a virtual buffer and continues.
D. The application which issued the call terminates with a U0731 abend.
正解：C