IBM C2090-549 問題集

質問 1：
One of your Units of Recovery (URs) needs to be backed out. The back out fails due to a read I/O error on both copies of the archive log which is needed for the b ck out. DB2 issues a critical log read error indicating that a "must complete" operation could not be completed. Which statement is true?
A. The error generates a write to operator with reply on the console asking you if DB2 should shut down. All other URs are put on hold until you answer the write to operator reply.
B. The error generates a write to operator with reply on the console asking you if DB2 should shut down. Other URs are not directly impacted and can continue to run.
C. The error generates a write to operator with reply on the console asking you if you would like to CANCEL this UR with NOBACKOUT option and leave it in REFP restrictive state.
D. The error does not generate any write to operator with reply and DB2 abends automatically.
正解：B

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

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

質問 4：
A customer is performing a traditional image copy disaster recovery test. The systems programmer creates a conditional restart control record (CRCR) but detects an error before starting DB2. Which action should be performed to correct the CRCR record?
A. First use CRESTART,DELETE to delete the error CRCR record then CRESTART,CREATE to add a new one.
B. Use CRESTART,CREATE to create a new CRCR record.
C. Use CRESTART,MODIFY to modify the parameters of the error CRCR record.
D. Start DB2, reply "M" to the WTOR that is displayed from the first CRCR record to modify the CRCR parameters.
正解：B

質問 5：
What is the purpose of the MAXTEMPS DB2 system parameter?
A. Specifies the maximum amount of work file storage an agent can use.
B. Limits the number of times the maximum allowable work file storage is exceeded.
C. Limits the number of temporary tables.
D. Limits the max storage used by the TEMP database.
正解：A

質問 6：
A thread that is no longer active in DB2 is causing -904 unavailable resource conditions for other executing applications. Which command could help alleviate the -904 condition caused by the non executing thread?
A. F irlmproc,DEADLOK='1,1'
B. -RESET INDOUBT
C. -RECOVER INDOUBT
D. -CANCEL THREAD
正解：C

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

質問 8：
Which statement is correct about the PGFIX buffer pool option?
A. PGFIX(NO) results in higher CPU usage in the MSTR address space for I/O intensive buffer pools.
B. PGFIX(NO) causes an increase in real storage usage in the DBM1 address space.
C. PGFIX(YES) causes a reduction in virtual storage usage in the DBM1 address space.
D. PGFIX(YES) results in lower CPU usage in the DBM1 address space for I/O intensive buffer pools.
正解：D

質問 9：
A systems programmer has just installed critical maintenance on a DB2 system that affects early code and they need this code to be activated immediately to fix a problem they are experiencing.
Which action should be performed by the systems programmer to activate the new early code with the least impact to the z/OS system?
A. Perform an IPL of the z/OS LPAR.
B. Issue the z/OS command F xxxxMSTR,REFRESH where "xxxx" is the DB2 subsystem id.
C. Recycle the DB2 system.
D. Issue the DB2 command -REFRESH DB2,EARLY.
正解：D