Simulation of C2090-617 question materials and samples for IBM certification for IT specialist, 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:
Q31. What is a DB2 global trace?
A. A trace that can only be activated by a global DSNZPARM setting.
B. A trace that is mainly used at the request of the IBM service team.
C. A trace to collect global locking information in a data sharing environment.
D. A trace that is issued on one member and activated on all members of the data sharing group at the same time.
Answer: B
Q32. Which statement describes the effect of setting the SEPARATE_SECURITY installation parameter to YES?
A. Prevents DBADM from starting traces.
B. Allows statement explain without table access privileges.
C. Prevents SYSADM from accessing data in unauthorized tables.
D. Prevents SYSADM and SYSCTRL from granting or revoking privileges.
Answer: D
Q33. 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
Renovate C2090-617 free exam:
Q34. In a production DB2 subsystem, the display of database DBFW8401 shows that pages have been added to the LPL. The indexes for the database have the COPY NO attribute.
Which utility is used to remove these pages from the LPL status?
A. REPAIR
B. RECOVER
C. CHECK INDEX
D. REBUILD INDEX
Answer: D
Q35. What is the process to automatically start an audit policy at DB2 startup?
A. Specify DSNZPARM subsystem parameters AUDITST = *
B. Specify DSNZPARM subsystem parameter AUDITST = YES
C. Specify DSNZPARM subsystem parameter TRACSTR = YES
D. UPDATE SYSIBM.SYSAUDITPOLICIES SET DB2START=Y for the row of the audit policy to be auto started.
Answer: D
Q36. What does it mean when the DSNZPARM parameter IMMEDWRI is set to YES?
A. DB2 writes changed log buffers to active log when each log block is full.
B. DB2 writes system changed pages from the local bufferpools to DASD immediately after the change.
C. DB2 writes user data changed pages from the local bufferpools to DASD immediately after the change.
D. DB2 writes changed pages from the local bufferpools to group bufferpools immediately after the change.
Answer: D
Realistic C2090-617 :
Q37. DB2A and DB2B reside on separate LPARs, in the DBG1 data sharing group. DB2A has an unplanned outage due to the failure of its LPAR. The applications running on DB2B cannot access some of the data due to retained locks held by DB2A. Which of the following actions will quickly resolve retained locks?
A. Restart DB2B.
B. Perform a group restart.
C. Issue a -START DATABASE for affected databases.
D. Restart DB2A on the other LPAR using -START DB2 LIGHT(YES).
Answer: D
Q38. DB2 10 enhances the profile table monitoring facility to support the filtering and threshold monitoring for the number of connections using which categories?
A. All local and DRDA connections.
B. Collection IDs and IP addresses.
C. Role and Authorization Identifiers.
D. Product Identifiers and Package Names.
Answer: C
Q39. You want to ensure that all the pages for a highly accessed table object remain in a buffer pool. Which of the following methods ensures this object reside in the buffer pool as an in-memory object?
A. Use the VOLATILE attribute on the CREATE TABLE statement for this object.
B. Use the CLOSE(NO) attribute on the CREATE TABLESPACE statement for this object.
C. Use the PGFIX(YES) attribute on the ALTER BUFFERPOOL statement assigned to this object.
D. Use the PGSTEAL(NONE) attribute on the ALTER BUFFERPOOL statement assigned to this object.
Answer: D
Q40. Remote users are complaining that there are occasional spikes in response. An SMF accounting report is not showing enough detail for the time periods reported. Assuming accounting traces 1,2,3,7,8 are already set, what action can be taken to get a higher level of detail for the remote threads?
A. Increase MONSIZE.
B. Change ACCUMACC to NO.
C. Change CMTSTAT from INACTIVE to ACTIVE.
D. Issue the MODIFY DDF to set PKGREL(BINDOPT).
Answer: B