100% Guarantee of C2090-617 exam question materials and guidance for IBM certification for IT examinee, Real Success Guaranteed with Updated C2090-617 pdf dumps vce Materials. 100% PASS DB2 10 System Administrator for z/OS (C2090-617) exam Today!
2021 Apr C2090-617 Study Guide Questions:
Q11. A stand-alone DB2 subsystem (not a member of a data sharing group) is suffering from high page latch wait times. Which area(s) do you need to investigate?
A. Page latches are managed by buffer manager so you should analyze the buffer pools.
B. This problem can only occur in a data sharing environment, so it does not apply here as this is a stand-alone DB2 system.
C. Page latches are typically just a symptom of an underlying problem. You must determine what other things are delayed that can also lead to page latch wait problems.
D. You need to identify which latch class is involved, by either looking at DB2 statistics information, or by starting more detailed performance traces (that include IFCID 51/52 (shared latch wait) and/or IFCID 56/57 (exclusive latch waits)) to determine why this is happening.
Answer: C
Q12. To cancel any type of thread using a -CANCEL THREAD command what information is needed?
A. The token of the thread to be canceled.
B. The luwid of the thread to be canceled.
C. The connection name of the thread to be canceled.
D. The correlation name of the thread to be canceled.
Answer: A
Q13. Which of the utilities CANNOT handle a table space containing a hash table?
A. REPAIR LEVELID
B. REORG AUTOESTSPACE
C. DSN1CHKR PARM=HASH
D. DSN1COPY PARM=OBIDXLAT
Answer: C
Rebirth C2090-617 practice question:
Q14. You can start duplexing for a given structure using which of the following commands?
A. SETXCF START,ALTER,STRNAME=strname
B. SETXCF START,DUPLEX,STRNAME=strname
C. SETXCF START,ALTER,DUPLEX,STRNAME=strname
D. SETXCF START,REBUILD,DUPLEX,STRNAME=strname
Answer: D
Q15. When using the -DISPLAY DATABASE command against a base table which has an associated clone table, which of the following is true?
A. The clone table will only be displayed if it has a different status from that of the base table.
B. Only the status of the base table is displayed as the clone is a true duplicate in every aspect.
C. The status of both objects is automatically displayed because they could each have a different status.
D. You must explicitly specify in the -DISPLAY DATABASE command that the status of both objects is to be displayed.
Answer: C
Q16. Upon system restart, DB2 encounters a Critical Log Read (CLR) error during the backout of an inflight UR and the restart fails. Only table space DB1.TS1 is 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. There is no way to restart without a conditional restart if you run into a Critical Log Read error.
D. DEFER the restart for this table space using keyword DEFER ALL in the DSNZPARM module used during the restart.
Answer: A
Validated C2090-617 courses:
Q17. Which statement is true regarding the RESTORE SYSTEM utility?
A. INSTALL SYSADM authority is required to run RESTORE SYSTEM.
B. The usage of RESTORE SYSTEM requires a conditional restart control record.
C. Once RESTORE SYSTEM completes successfully all objects are immediately ready for use.
D. If the backup was created using the FULL option, logs are also restored as part of RESTORE SYSTEM operation.
Answer: B
Q18. When the ADMIN_UTL_MONITOR stored procedure first executes for autonomic statistics monitoring, DB2 searches user specified options for a particular table. Where does DB2 find these options?
A. PLAN_TABLE
B. SYSIBM.SYSCOLDIST
C. SYSIBM.SYSTABLES_PROFILES
D. SYSIBM.SYSTABLESPACESTATS
Answer: C
Q19. Application performance to a hash-organized table has degraded due to more than 5% of the rows being accessed from overflow pages. What should you do to correct this issue?
A. Use ALTER TABLESPACE to increase PCTFREE and REORG table space.
B. Use ALTER TABLESPACE to increase FREEPAGE and REORG table space.
C. Use RUNSTATS utility with UPDATE SPACE option to collect new space statistics.
D. Use REORG TABLESPACE utility on the table space using AUTOESTSPACE YES statement.
Answer: D
Q20. Due to heavy INSERT/UPDATE/DELETE in your DB2 subsystem and problems with the log archive process, DB2 runs out of available active logs and halts its operation. Let us assume that this subsystem currently operates with 25 active log data sets. What can be done to make DB2 operational again without having to stop the subsystem?
A. There is no way to define additional active logs to the BSDS while DB2 is up and running.
B. Define additional active log data sets and issue command -SET LOG NEWLOG(..) COPY(..) for each of the newly defined data sets.
C. Define additional active log data sets and run the change log inventory utility to register them in the BSDS.
D. Issue the -SET LOG NEWLOG(...) COPY(...) command to have DB2 define the new VSAM clusters and register those in the BSDS.
Answer: B