Free DB2 12 System Administrator for z/OS Exam C2090-318 Exam Practice Test

Which of the following are TRUE regarding the DSN1PRNT utility? (Choose two)

• It does not decrypt any encrypted data
• The input can be a list of concatenated DB2 VSAM data sets
• lt can be executed when the DB2 subsystem is not operational
• lt can be executed on both image copies and concurrent copies
• Compressed records cannot be printed in decompressed format

Which technique is best suited to determine whether a bigger VPSIZE for a buffer pool could be beneficial?

• Analyze accounting trace records
• Analyze performance trace records
• Analyze buffer pool simulation results
• Analyze the contents of table SYSIBM.SYSTABLESPACESTATS

For a general application performance problem, which set of documentation would be most useful for diagnosis?

• SVC Dump
• RMF Monitor
• DIAGNOSE MEPL utility
• SMF accounting and statistics traces

Which one of the following modules, or its equivalent name, is optional for a successful DB2 start?

• The default load module (DSNZPARM)
• The application default load module (DSNHDECP)
• The DB2 connection authorization exit routine (DSN3@ATH)
• The user version of the access control authorization exit routine (DSNX@XAC)

With which authority can you create, display, activate, or inactivate DB2 audit policies?

• SYSADM
• SYSOPR
• SYSCTRL
• SECADM

When using a persistent thread bound with RELEASE(DEALLOCATE), which subsystem parameter setting will permit a REBIND PACKAGE at a COMMIT or ROLLBACK in this thread?

• BINDNV=BIND
• ABIND=COEXIST
• APPLCOMPAT=YES
• PKGREL COMMIT=YES

Which library contains the early code for DB2 12?

• SDSNLINK
• SDSNLOD2
• SDSNLOAD
• SDSNMACS

The remote clients are receiving SQLCODE -30062 RDB ACCESS FAILURE, which means access to the database failed because the session data is expired. How can you increase the number of minutes that applications can remain inactive before the associated session data token becomes invalid because of timeout?

• Change the UTILITY TIMEOUT field (UTIMOUT subsystem parameter)
• Issue the -MODIFY DDF SESSIDLE command to increase session timeout
• Change the RESOURCE TIMEOUT field (IRLMRWT subsystem parameter)
• Change the POOL THREAD TIMEOUT field (POOLINAC subsystem parameter)

What are the appropriate actions that can be taken to reduce false contention in a data sharing environment? (Choose two)

• Increase the size of the lock structure
• Use LOCKSIZE PAGE and MAXROWS 1
• Increase the proportional size of the lock table
• Increase workload with inter-DB2 read/write interest
• Reduce the IRLMRWT subsystem parameter value

Which DB2 command is used to turn on the recording of CPU usage information for a package?

• -START RLIMIT
• -START TRACE
• -START PROFILE
• -START DYNQUERYCAPTURE