Exam Code: C2090-617 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10 System Administrator for z/OS (C2090-617)
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-617 Exam.
2021 May C2090-617 Study Guide Questions:
Q71. You start your DB2 subsystem and check the messages in the MSTR address space. DB2 issues message DSNJ120I indicating that it detected unequal timestamps in the BSDSs. What is the required action to allow DB2 to start successfully?
A. DB2 restart is halted and an open reply lets you use the -RECOVER BSDS command to fix the problem.
B. Use the VSAM REPRO utility to overwrite the older BSDS with the most recent one and issue -START DB2 again.
C. DB2 shuts down when this problem occurs. You must issue -START DB2 again and DB2 will try to re-synchronize the BSDSs now.
D. No action is needed. DB2 automatically tries to re-synchronize and continues with the restart if the re-synchronization was successful.
Answer: D
Q72. In what situation does the PGFIX(YES) buffer pool option provide a significant CPU performance improvement?
A. High I/O rates.
B. Small buffer pool size.
C. High buffer pool hit ratio.
D. Not enough real memory to back storage.
Answer: A
Q73. Which statement describes a DB2 ROLE?
A. A role is a privilege.
B. A role is a USERID.
C. A role is a RACF entity.
D. A role is a database entity.
Answer: D
Up to date C2090-617 answers:
Q74. You plan to migrate your DB2 subsystem from DB2 9 NFM to DB2 10 CM. Which statement is correct?
A. The fallback PTF must be applied to the DB2 10 libraries.
B. The fallback PTF is only needed if you plan a skip-level migration
C. The fallback PTF must be applied to your DB2 9 subsystem and it must have been started with it at least once.
D. The fallback PTF must be SMP/E applied so that in case of a needed fallback you are well prepared. No need to start DB2 9 with this PTF in place before migration to DB2 10.
Answer: C
Q75. You are installing a new DB2 10 subsystem, and have just run the batch job DSNTIJTM. Which action is NOT accomplished by this job?
A. Grants authority to create indexes on the default database to PUBLIC.
B. Grants use of the SYSDEFLT table space to PUBLIC.
C. Grants use of the default buffer pool and storage group to PUBLIC.
D. Grants authority to create tables and table spaces in the default database to PUBLIC.
Answer: A
Q76. Upon system restart, DB2 encounters a Critical Log Read (CLR) error during the backout of an inflight UR and the restart fails. Table space DB1.TS1 and a few catalog page sets are affected by this UR. What can you do to enable DB2 to restart WITHOUT a conditional restart?
A. Set DSNZPARM BACKODUR to 0 and LBACKOUT to YES.
B. Issue the -START DB2 command with the LIGHT(YES) option.
C. DEFER the restart for this table space using keyword DEFER=ALL in the DSNZPARM module used for this restart.
D. There is no way to restart without a conditional restart if you run into a Critical Log Read error and catalog or directory objects are involved.
Answer: D
Realistic C2090-617 free demo:
Q77. When performing a group restart in a data sharing environment and all members are at the same DB2 version, in which order should this occur?
A. Order is not important and the group restart can be done in parallel.
B. Order is not important but restart should be performed one member at a time.
C. Restart the member with the lowest LRSN and continue restarting other members in ascending LRSN order.
D. Restart the member with the highest LRSN and continue restarting other members in descending LRSN order.
Answer: A
Q78. Which utility is eligible for zIIP offload?
A. COPY
B. UNLOAD
C. RUNSTATS
D. CHECK LOB
Answer: C
Q79. The logical page list(LPL) contains a list of pages that could not be read or written for some reason. If a tablespace object TS1 is found on the LPL, which step could remove the object from the LPL?
A. REBUILD INDEX
B. REORG TABLESPACE DB1.TS1
C. -STOP DATABASE (DB1) SPACENAM (TS1)
D. -START DATABASE (DB1) SPACENAM (TS1) ACCESS (RW)
Answer: D
Q80. Which is the best approach for monitoring lock usage with the intention of identifying the occurrence of system wide lock contention?
A. Start accounting trace classes 1 and 3.
B. Start statistics trace classes 1, 3, and 4.
C. Use EXPLAIN to display the types of locks used.
D. Issue the -DISPLAY DATABASE command with the LOCKS ONLY option.
Answer: B