We're so confident of our products that we provide no hassle product exchange.
IBM Db2 12 for z/OS Administrator Sample Questions:
1. Which utility must be executed before and after running a REORG utility against a system catalog table space to support recovery?
A) RUNSTATS
B) MODIFY
C) CHECK DATA
D) COPY
2. The remote clients are receiving SQLCODE -30062 RDB ACCESS FAILURE, which means access to the database failed because the session data is expired. How can you increase the number of minutes that applications can remain inactive before the associated session data token becomes invalid because of timeout?
A) Change the POOL THREAD TIMEOUT field (POOLINAC subsystem parameter)
B) Change the UTILITY TIMEOUT field (UTIMOUT subsystem parameter)
C) Issue the -MODIFY DDF SESSIDLE command to increase session timeout
D) Change the RESOURCE TIMEOUT field (IRLMRWT subsystem parameter)
3. Which library contains the early code for DB2 12?
A) SDSNLINK
B) SDSNLOD2
C) SDSNMACS
D) SDSNLOAD
4. Which DB2 command is used to force a physical open of a table space, index space, or partition, or remove the GBP-dependent status for a table space, index space, or partition?
A) -DISPLAY DATABASE
B) -START DATABASE
C) -STOP DATABASE
D) -ACCESS DATABASE
5. For a general application performance problem, which set of documentation would be most useful for diagnosis?
A) RMF Monitor
B) SMF accounting and statistics traces
C) SVC Dump
D) DIAGNOSE MEPL utility
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: C | Question # 3 Answer: C | Question # 4 Answer: D | Question # 5 Answer: A |
By Jay
