Free IBM C2090-318 Exam Dumps Questions & Answers

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

• A.  RMF Monitor
• B.  SVC Dump
• C.  DIAGNOSE MEPL utility
• D.  SMF accounting and statistics traces

DB2 has stopped working because it has problems archiving the last active log. Which of the following commands could be used to resolve the situation?

• A.  -SET LOG SUSPEND
• B.  -SET LOG NEWLOG
• C.  -SET LOG RESUME
• D.  -SET LOG LOGLOAD

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

• A.  DSNXSXAC
• B.  DSNXRXAC
• C.  DSN3@SGN
• D.  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?

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

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.  Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION
  COMPATIBILITY V12R1M500 for the listed indexes
• B.  Reorganize the listed indexes
• C.  Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE
• D.  Set subsystem parameter INDEX_CLEANUP_THREADS to 0