C2090-318 DB2 12 System Administrator for z/OS exam is withdrawing on Sep 30, 2021,passing this IBM C2090-318 exam will help you  achieve IBM Certified System Administrator - DB2 12 for z/OS certification. PassQuestion provides the latest DB2 12 System Administrator for z/OS C2090-318 Exam Questions which will be asked in the actual C2090-318 exam.We want to ensure your success in the IBM C2090-318 exam so we worked hard to help you enhance your knowledge in the real exam.In Our DB2 12 System Administrator for z/OS C2090-318 Exam Questions, you will get the real and actual IBM C2090-318 exam questions with their verified answers that guarantee 100% success in your IBM C2090-318 exam.

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

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, tune and secure DB2 for z/OS environments. There are 60 questions in the real test, and you need to answer 39 questions correctly in 90 minutes.The available language is only English, passing C2090-318 and C2090-320 exam will help you earn IBM Certified System Administrator - DB2 12 for z/OS certification.

Recommended Prerequisites

Working knowledge of DB2 z/OS in a system administration capacity
Support of DB2 on a z/OS environment
Knowledge of z/OS architecture
Knowledge of Subsystem Parameters (DSNZPARMs)
Knowledge of DB2 data sharing environment

Exam Objectives

Section 1 - Installation and Migration          21%
Section 2 - Security and Auditing            10%
Section 3 - System Operation and Maintenance      20%
Section 4 - Backup and Recovery           17%
Section 5 - Performance and Tuning         20%
Section 6 - Troubleshooting             12%

View Online DB2 12 System Administrator for z/OS C2090-318 Free Questions

Which of the following utilities would produce information needed to identify UNDO information for a transaction?
A.DSNJU003
B.DSNJU004
C.DSNJLOGF
D.DSN1LOGP
Answer : A

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
Answer : D

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?
A.Change the UTILITY TIMEOUT field (UTIMOUT subsystem parameter)
B.Issue the -MODIFY DDF SESSIDLE command to increase session timeout
C.Change the RESOURCE TIMEOUT field (IRLMRWT subsystem parameter)
D.Change the POOL THREAD TIMEOUT field (POOLINAC subsystem parameter)
Answer : B

To simulate a new buffer pool size, what buffer pool parameter is used?
A.PGFIX
B.VPSIZE
C.SPSI2E
D.AUTOSI2E
Answer : C

Before execution of the CHECK DATA utility, which of the following should be performed?
A.Execute the REPAIR utility with SET NOCHECKPEND
B.Execute CHECK INDEX on the primary key and foreign key indexes
C.Alter the object to remove any table or referential constraint definitions
D.Start the object in question with FORCE to remove any CHECK PENDING status
Answer : D

Which of the following allows tracking of database administration tasks performed by system DBADMs?
A.Use the DIAGNOSE utility with option TRACEID
B.Use the REPORT utility with option TABLESPACESET
C.Define and start an appropriate audit policy in SYSIBM.SYSAUDITPOLICIES
D.Start the appropriate accounting trace classes and analyze the SMF records
Answer : A