IBM C2090-318 DB2 12 System Administrator for z/OS Online Training
IBM C2090-318 Online Training
The questions for C2090-318 were last updated at Apr 05,2025.
- Exam Code: C2090-318
- Exam Name: DB2 12 System Administrator for z/OS
- Certification Provider: IBM
- Latest update: Apr 05,2025
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 DB2
- B . On application threads that update NOT LOGGED table spaces
- C . If you are terminating a distributed thread that is part of a global transaction
- D . If the CANCEL THREAD command without the FORCE option does not terminate the thread
Which of the following utilities would produce information needed to identify UNDO information for a transaction?
- A . DSNJU003
- B . DSNJU004
- C . DSNJLOGF
- D . DSN1LOGP
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 indexes
- B . Set subsystem parameter INDEX_CLEANUP_THREADS to 0
- C . Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE
- D . Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION COMPATIBILITY V12R1M500 for the listed indexes
Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?
- A . DSNDB06.SYSDDF
- B . DSNDB01.SYSUTILX
- C . DSNDB01.SYSSPT01
- D . DSNDB01.SYSLGRNX
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 correctly
- B . Start a system-wide performance trace to identify the workload which is causing the high CPU
- C . Execute a -DISPLAY STATS command to identify the workload which is causing the high CPU
- D . Execute a -DISPLAY TRACED command to check if there are additional traces running or if the global trace is on
Which of the following is required to successfully issue the -ACTIVATE command in a data sharing environment?
- A . All active members must be running DB2 12
- B . Only one member may be active when the command is issued
- C . The command must be issued with installation SYSADM authority
- D . The member on which the command is issued must be started in maintenance mode
Which library contains the early code for DB2 12?
- A . SDSNLINK
- B . SDSNLOD2
- C . SDSNLOAD
- D . SDSNMACS
Which DB2 command is used to turn on the recording of CPU usage information for a package?
- A . -START RLIMIT
- B . -START TRACE
- C . -START PROFILE
- D . -START DYNQUERYCAPTURE
Which of the following migration steps is optional?
- A . Tailor the DB2 catalog
- B . Define DB2 12 to z/OS
- C . Define DB2 initialization parameters: DSNTIJUZ
- D . Verify the integrity of the DB2 catalog and directory
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?
- A . DSNJLOGF
- B . DSN1PRNT
- C . DSN1LOGP
- D . DSN1SDMP
Latest C2090-318 Dumps Valid Version with 60 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
