- All Exams Instant Download
What can be done to avoid this storage usage?
Az/OS system has some storage constraints. The results of-DIS STATS(INDEXMEMORYUSAGE) shows that a huge amount of storage is used for the fast index traversal processes. What can be done to avoid this storage usage?A . Reorganize the listed indexesB . Set subsystem parameter INDEX_CLEANUP_THREADS to 0C . Set subsystem parameter...
In which of the following situations can it be used?
Considering the following command: -CANCEL THREAD {*) FORCE In which of the following situations can it be used?A . On local threads that are not in DB2B . On application threads that update NOT LOGGED table spacesC . If you are terminating a distributed thread that is part of a...
Which of the following commands can be used to show the client correlation token in order to find details such as the ip-address. port-address and unique-id to identify the distributed transaction?
Which of the following commands can be used to show the client correlation token in order to find details such as the ip-address. port-address and unique-id to identify the distributed transaction?A . -DISPLAY LOCATION OC . -DISPLAY DDF DETAILD . -DISPLAY THREADH DETAILE . -DISPLAY FUNCTION SPECIFICView AnswerAnswer: C
Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?
Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?A . DSNDB06.SYSDDFB . DSNDB01.SYSUTILXC . DSNDB01.SYSSPT01D . DSNDB01.SYSLGRNXView AnswerAnswer: B Explanation: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_reco vercatalogdirectoryobjects.html Use the following general guidelines for all of the steps in this task: ✑ If you copy your catalog or...
What would be the most efficient analysis to perform?
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?A . Check that the WLM settings are set correctlyB . Start a system-wide performance...
Which of the following is TRUE about the SYSCTRL authority?
Which of the following is TRUE about the SYSCTRL authority?A . It is designed to allow access to all data directly in DB2B . It is designed not to be a part of the administrative authorizationsC . It is designed so group privileges cannot be granted to SYSCTRLD . It...
Which type of trace is used to record transaction-level data that is written when the processing for a transaction is completed?
Which type of trace is used to record transaction-level data that is written when the processing for a transaction is completed?A . AuditB . MonitorC . StatisticsD . AccountingView AnswerAnswer: D Explanation: Accounting traceThe accounting trace records transaction-level data that is written when the processing for a transaction is completed....
At what point in the upgrade process is the catalog migrated to DB2 12?
At what point in the upgrade process is the catalog migrated to DB2 12?A . Completion of DSNTIJTC jobB . At the completion of CATMAI NT in function level 500C . After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M100)D . After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M500)View AnswerAnswer: B
Which service class does not have a goal, but runs with a fixed dispatching priority above all of the other work on the system?
Which service class does not have a goal, but runs with a fixed dispatching priority above all of the other work on the system?A . ONLINEB . SYSSTCC . SYSTEMD . SYSOTHERView AnswerAnswer: B
Which of the following utilities would produce information needed to identify UNDO information for a transaction?
Which of the following utilities would produce information needed to identify UNDO information for a transaction?A . DSNJU003B . DSNJU004C . DSNJLOGFD . DSN1LOGPView AnswerAnswer: D Explanation: https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/pdf/db2z_12_ugrefbook.p df
