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

Given the following scenario:A table has been dropped accidentally and you need to restore the object. DSN1COPY will be used to restore the object but the PSID and the original OBID of the object is not known.Which stand alone utility will allow you to retrieve that information?

• DSNJLOGF
• DSN1PRNT
• DSN1LOGP
• DSN1SDMP

Which of the following allows tracking of database administration tasks performed by system DBADMs?

• Use the DIAGNOSE utility with option TRACEID
• Use the REPORT utility with option TABLESPACESET
• Define and start an appropriate audit policy in SYSIBM.SYSAUDITPOLICIES
• Start the appropriate accounting trace classes and analyze the SMF records

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 of the following is TRUE about the SYSCTRL authority?

• It is designed to allow access to all data directly in DB2
• It is designed not to be a part of the administrative authorizations
• It is designed so group privileges cannot be granted to SYSCTRL
• It is designed to be an administrator in a system with sensitive data

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

Considering the following command:-CANCEL THREAD {*) FORCEIn which of the following situations can it be used?

• On local threads that are not in DB2
• On application threads that update NOT LOGGED table spaces
• If you are terminating a distributed thread that is part of a global transaction
• If the CANCEL THREAD command without the FORCE option does not terminate the thread

In order to install the RACF access control module for a DB2 subsystem, to which of the following modules should DSNTIJEX refer?

• DSNXRXAC
• DSNXSXAC
• DSN3@SGN
• DSN3@ATH

CPU utilization for a DB2 subsystem suddenly increased by approximately 20% and is still at this high level after 24 hours. No increase in workload was expected. What would be the most efficient analysis to perform?

• Check that the WLM settings are set correctly
• Start a system-wide performance trace to identify the workload which is causing the high CPU
• Execute a -DISPLAY STATS command to identify the workload which is causing the high CPU
• Execute a -DISPLAY TRACED command to check if there are additional traces running or if the global trace is on

For best DB2 lock avoidance, which of the following BIND/REBIND options should be included in the REBIND command execution?

• ACQUIRE(USE)ISOLATION(CS)
• ACQUIRE(USE)ISOLATION(RR)
• CURRENTDATA(NO)ISOLATION(CS)
• CURRENTDATA(YES) ISOLATION(CS)