Realistic of C2090-617 exam question materials and Q&A for IBM certification for IT professionals, 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 May C2090-617 Study Guide Questions:
Q1. You have implemented hash access on a production table. In order to optimize hash access performance you need to monitor the storage space utilized by hash access. How would you accomplish this?
A. View real time statistics for the table.
B. Run RUNSTATS with the UPDATE SPACE option.
C. Issue the -DISPLAY DATABASE(*) SPACENAM(*) USE command.
D. Utilize a monitoring profile using the -DISPLAY PROFILE command.
Answer: A
Q2. The TCPALVER subsystem parameter specifies whether DB2 is to accept TCP/IP connection requests that contain only a user ID (no password, RACF PassTicket, or Kerberos ticket). Which of the following values is NOT accepted as a legitimate value?
A. YES
B. SERVER
C. CURRENTSERVER
D. SERVER_ENCRYPT
Answer: C
Q3. When migrating from DB2 9 NFM to DB2 10 CM or installing a new DB2 10 subsystem, which is NOT used to activate a new version of the DB2 early (ERLY) code modules?
A. IPL z/OS.
B. Stop DB2 and issue REFRESH DB2, EARLY command.
C. Recycle DB2 by issuing STOP DB2 and START DB2 commands.
D. Issue SETSSI z/OS command against the target DB2 subsystem.
Answer: C
Most recent C2090-617 free practice questions:
Q4. DB2 10 attempts to execute a package that was bound in DB2 9 with DBPROTOCOL(PRIVATE) and the package has a dependency to access a remote location, what would be the result?
A. The SQL statement executes successfully.
B. Execution of the SQL statement fails with -904.
C. A REBIND is automatic with parameter DBPROTOCOL(DRDA) and the remote access attempt fails.
D. A REBIND is automatic with parameter DBPROTOCOL(DRDA) and the remote access attempt processes successfully.
Answer: B
Q5. In monitoring current data sharing workload, an increase in false contention has been observed over a period of time. The current rate of false contention is now running over 5%. To address this increase in false contention, what option should be considered?
A. Decrease the size of the active log.
B. Increase the size of the group buffer pool for the DB2 catalog.
C. Increase the size of the lock structure for this data sharing group.
D. Increase the size of the modified lock list in the coupling facility (CF).
Answer: C
Q6. Recovering the DB2 catalog and directory involves special considerations. Which order statement is correct?
A. Recover DSNDB06.SYSCOPY before recovering DSNDB01.DBD01.
B. Recover DSNDB06.SYSLGRNX before recovering DSNDB06.SYSCOPY.
C. Rebuild all user defined indexes on DSNDB01.SYSLGRNX before recovering DSNDB06.SYSTSIXS.
D. Rebuild all indexes for DSNDB06.SYSRTSTS before rebuilding user defined catalog indexes on DSNDB06.SYSTSIXS.
Answer: D
Tested C2090-617 bundle:
Q7. DB2 Accounting Class 3 Service Task Switch Wait Time can occur for multiple reasons. Which does NOT contribute to Class 3 Service Task Switch Time?
A. Open / Close delays
B. EXT/DEL/DEF delays
C. Synchronous I/O delays
D. Update / Commit delays
Answer: C
Q8. As a new application is being developed, the site capacity planners want to know how much CPU is used by DB2 at the DB2 Package level of detail. What can you do to minimize the volume of data written to SMF datasets?
A. Allocate very small SMF datasets.
B. -START TRACE(STAT) CLASS (1,3).
C. Specify DB2 DSNZPARM SMFCOMP = YES.
D. Specify DB2 DSNZPARM IMPTSCMP = YES.
Answer: C
Q9. You have implemented hash access on a production table. In order to optimize hash access performance you need to monitor the storage space utilized by hash access. How would you accomplish this?
A. View real time statistics for the table.
B. Run RUNSTATS with the UPDATE SPACE option.
C. Issue the -DISPLAY DATABASE(*) SPACENAM(*) USE command.
D. Utilize a monitoring profile using the -DISPLAY PROFILE command.
Answer: A
Q10. When a data sharing member fails, what is the final state of the connections to the DB2 lock structure in the coupling facility?
A. It is finally marked as FAILING.
B. It is immediately marked as FAILED PERSISTENT for the failing member.
C. It is marked as FAILING and then finally changed to FAILED PERSISTENT upon receiving DiscFailCon from all members.
D. It is marked as FAILED PERSISTENT and then finally changed to FAILING upon receiving DiscFailCon from all members.
Answer: C