IBM C2090-317 - DB2 11 System Administrator for z/OS Exam
Page: 3 / 12
Total 60 questions
Question #11 (Topic: )
If a DB2 subsystem fails during start up in the log initialization phase, which two steps are
needed in your corrective actions to minimize impact without completing a cold start?
needed in your corrective actions to minimize impact without completing a cold start?
A. Start DB2 using DEFER ALL.
B. Use DSNJU003 with the ENDRBA option.
C. Use DSNJU003 with the STARTRBA option.
D. Start DB2 using DEFER on catalog and directory.
E. Recover the subsystem to the last known system checkpoint in BSDS.
Answer: D,E
Question #12 (Topic: )
Which subsystem parameter setting allows connection queuing?
A. IDTHTOIN>0
B. CONDBAT>0
C. POOLINAC>0
D. MAXCONGN > 0
Answer: D
Question #13 (Topic: )
A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a
few minutes the phone starts ringing and people complain that transactions accessing table
space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by
the member that just abended.
What is the recommended way to resolve this problem?
few minutes the phone starts ringing and people complain that transactions accessing table
space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by
the member that just abended.
What is the recommended way to resolve this problem?
A. -START DB(DBA) SP(TSA) ACCESS(FORCE)
B. Restart the failed DB2 member with the LIGHT(YES) option.
C. Delete all the failed persistent connections to the lock structure with the SETXCFFORCE,CONNECTION,STRNAME=lock_strname.CONNAME=ALL command and force the deallocation of the lock structure by issuing SETXCFFORCE,STRUCTURE.STRNAME=lock_strname
D. Issue the MODIFY irlmproc.PURGE. DB2A command from an IRLM that is used by a DB2 member that is still running.}
Answer: C
Question #14 (Topic: )
Which two features are the motivation behind the conversion to extended RBA/LRSN
format?
format?
A. Greater RECOVER utility concurrency.
B. Reduction of the potential for an RBA rollover.
C. More precise PIT recovery of the DB2 system catalog and directory.
D. Potentially faster UPDATE performance due to greater LRSN granularity.
E. Reduced p-Lock contention in the coupling facility due to greater LRSN granularity.
Answer: C
Question #15 (Topic: )
Your database administrators plan to start using XML and they plan to have the XML
documents being validated using type modifiers.
You must make sure that they are able to make XSR schemas available for this.
Which stored procedure(s), if any, must at least be created and functioning for that?
documents being validated using type modifiers.
You must make sure that they are able to make XSR schemas available for this.
Which stored procedure(s), if any, must at least be created and functioning for that?
A. XSR_REGISTER
B. XSR_REGISTER, XSR_COMPLETE
C. No stored procedures need to be created.
D. XSRREGISTER. XSRCOMPLETE. XSRADDSCHEMADOC
Answer: B
