High value of C2090-617 exam question materials and bundle 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 May C2090-617 Study Guide Questions:
Q21. Which installation panel field entry must be the same for every member of a data sharing group?
A. WORK FILE DB
B. DB2 LOCATION NAME
C. PARAMETER MODULE
D. DB2 NETWORK LUNAME
Answer: B
Q22. The following is the output from the -DISPLAY DDF DETAIL command:
How many database access threads were active at the time the DISPLAY was executed?
A. 0
B. 27
C. 138
D. 1652
Answer: C
Q23. To add a new active log without recycling DB2, which action is NEITHER recommended NOR necessary?
A. Issue the -SET LOG SUSPEND command.
B. Define the new active log data set using IDCAMS.
C. Format the new active log using the DSNJLOGF utility.
D. Issue the -SET LOG NEWLOG(dataset) COPY(1) command.
Answer: A
Renovate C2090-617 free practice questions:
Q24. Why does IBM recommend putting the DB2 ssidMSTR address space into the WLM SYSSTC service class?
A. ssidMSTR does not need to be using such a high priority service class. As long as ssiddMSTR has a higher priority than IRLM , the priority is fine.
B. ssidMSTR runs the DB2 internal monitor. To make sure DB2 can do a good job monitoring itself, this address space should have a very high priority in the system.
C. ssidMSTR is the DB2 'master' address space, and as such controls the other DB2 system address spaces like ssidDBM1, and ssidDIST. Therefore it should have the highest priority in the system.
D. Running ssidMSTR at SYSSTC priority is not recommended. This address space only runs requests on behalf of others at the priority of the requesting address space. Therefore there is no need to assign ssidMSTR such a high priority.
Answer: B
Q25. You need to retrieve statement level performance statistics for dynamic and static SQL statements. How is this accomplished?
A. By executing the EXPLAIN STMTCACHE ALL statement provided IFCID 316 and 318 are active.
B. By writing a program or using a monitor that retrieves information collected after issuing a -START TRACE(MON) CLASS(29) command.
C. By writing a program or using a monitor that retrieves information collected after issuing a -START TRACE(STATS) CLASS(1,3,4,5,6) command.
D. By writing a program or using a monitor that retrieves information collected after issuing a -START TRACE(ACCTG) CLASS(1,2,3,7,8,10) command.
Answer: B
Q26. Which directory table space CANNOT be REORGed in DB2 10?
A. DSNDB01.SPT01
B. DSNDB01.SCT02
C. DSNDB01.SYSUTILX
D. DSNDB01.SYSLGRNX
Answer: C
Free C2090-617 interactive bootcamp:
Q27. If you are running DB2 in dual-BSDS mode and one of the BSDS's fails with an I/O error, which step is NOT necessary to recover the failed BSDS?
A. Issue the -STOP DB2 command.
B. Issue the -RECOVER BSDS command.
C. Define a new BSDS with the same name as the original BSDS.
D. Use access method services to rename or delete the failing BSDS.
Answer: A
Q28. Upon an abnormal termination of a data sharing DB2 member, we may have retained locks in the coupling facility. What happens when another member tries to access that data?
A. Incompatible requests from other members are suspended until we restart the failed member.
B. Incompatible requests from other members are suspended for the time specified in the IRLMRWT DSNZPARM parameter.
C. Incompatible requests from other members are suspended for the time specified in the RETLWAIT DSNZPARM parameter.
D. Incompatible requests from other members are suspended for the time derived from the multiplication of IRLMRWT by RETLWAIT DSNZPARMs.
Answer: D
Q29. Which statement regarding a work file table space is NOT true?
A. A work file table space can be part of the DSNDB07 database.
B. DB2 can use a work file table space defined with an 8K page size.
C. A work file table space can be created with zero secondary quantity.
D. A work file table space can be assigned to a buffer pool other than BP0.
Answer: B
Q30. Assume that you have implemented identity propagation and that the distributed user name is 'MARY'. You have mapped this user name to the RACF user ID 'DB2USER1'. Which statement is true?
A. 'MARY' is authenticated by RACF.
B. 'DB2USER1' must be defined on the remote system.
C. Remote requests execute with the authority of 'MARY'.
D. Audit records for this transaction contains both RACF user ID 'DB2USER1' and the distributed user 'MARY'.
Answer: D