1091 お客様のコメント
質問 1：
Under which condition would a -RESET INDOUBT command be necessary?
A. When DB2 is the commit coordinator and is unable to resolve in-doubt threads.
B. When in-doubt threads have been resolved and DB2 cannot synchronize with the commit coordinator.
C. When DB2 cannot determine if the threads should be committed or rolled back.
D. When the commit coordinator is unable to determine if threads should be committed or rolled back.
正解：B
質問 2：
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 REPRO utility to copy the contents of the VSAM
cluster containing 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. No manual interaction is needed as long as the ADMIN_TASKS table is still accessible.
D. 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
質問 3：
A systems programmer gets notified of an application response time issue with a dynamically bound
distributed application. Which two could help diagnose the problem? (Choose two.)
A. formatted DB2 accounting records
B. formatted RMF VSTOR
C. formatted CF activity report
D. formatted IFCID records for the dynamic statement cache
E. formatted DB2 statistics records
正解：A,D
質問 4：
Which three region types MUST be present for a z/OS application to use ODBA? (Choosethree.)
A. DBRC
B. MPR
C. DLISAS
D. IRLM
E. JMP
F. CTL
正解：A,C,F
質問 5：
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 does not generate any write to operator with reply and DB2 abends automatically.
B. 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.
C. 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.
D. 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.
正解：C
質問 6：
It is possible that the DBD in the directory is out of sync with the DBD information in thecatalog for
database DSN8D91
Which action should be performed to determine if this is the case?
A. Run CHECK DATA.
B. Run REPAIR DBD TEST.
C. Run DSN1COPY with the CHECK option.
D. Run DSN1CHKR.
正解：B
Under which condition would a -RESET INDOUBT command be necessary?
A. When DB2 is the commit coordinator and is unable to resolve in-doubt threads.
B. When in-doubt threads have been resolved and DB2 cannot synchronize with the commit coordinator.
C. When DB2 cannot determine if the threads should be committed or rolled back.
D. When the commit coordinator is unable to determine if threads should be committed or rolled back.
正解：B
質問 2：
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 REPRO utility to copy the contents of the VSAM
cluster containing 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. No manual interaction is needed as long as the ADMIN_TASKS table is still accessible.
D. 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
質問 3：
A systems programmer gets notified of an application response time issue with a dynamically bound
distributed application. Which two could help diagnose the problem? (Choose two.)
A. formatted DB2 accounting records
B. formatted RMF VSTOR
C. formatted CF activity report
D. formatted IFCID records for the dynamic statement cache
E. formatted DB2 statistics records
正解：A,D
質問 4：
Which three region types MUST be present for a z/OS application to use ODBA? (Choosethree.)
A. DBRC
B. MPR
C. DLISAS
D. IRLM
E. JMP
F. CTL
正解：A,C,F
質問 5：
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 does not generate any write to operator with reply and DB2 abends automatically.
B. 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.
C. 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.
D. 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.
正解：C
質問 6：
It is possible that the DBD in the directory is out of sync with the DBD information in thecatalog for
database DSN8D91
Which action should be performed to determine if this is the case?
A. Run CHECK DATA.
B. Run REPAIR DBD TEST.
C. Run DSN1COPY with the CHECK option.
D. Run DSN1CHKR.
正解：B
Matsuo -
高い合格率がありますよね。ありがとうございました。
問題の合致率は9割程度でした、感心しました。