Name: DB2 12 System Administrator for z/OS
Brand: ValidExamDumps
SKU: C2090-318
Price: 20 USD
Availability: InStock
Rating: 5.0 (250 reviews)

Free IBM C2090-318 Exam Actual Questions

The questions for C2090-318 were last updated On Nov 7, 2024

Question No. 1

DB2 just abended unexpectedly and needs to be restarted as quickly and consistently as possible. Which of the following restart method do you pick?

APerform a cold start

BIssue the-START DB2 command

CCreate a conditional restart record using option ENDRBA and then restart DB2

DCreate a conditional restart record using option STARTRBA and then restart DB2.

Show Answer

Correct Answer: C

Question No. 2

In which phase of SMP/E processing is the DB2 software installed into the target libraries?

AAPPLY

BACCEPT

CRECEIVE

DAPPLY CHECK

Show Answer

Correct Answer: B

Question No. 3

Which of the following migration steps is optional?

ATailor the DB2 catalog

BDefine DB2 12 to z/OS

CDefine DB2 initialization parameters: DSNTIJUZ

DVerify the integrity of the DB2 catalog and directory

Show Answer

Correct Answer: D

https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_runlinkchkr.html

Question No. 4

Considering the following command:

-CANCEL THREAD {*) FORCE

In which of the following situations can it be used?

AOn local threads that are not in DB2

BOn application threads that update NOT LOGGED table spaces

CIf you are terminating a distributed thread that is part of a global transaction

DIf the CANCEL THREAD command without the FORCE option does not terminate the thread

Show Answer

Correct Answer: D

Question No. 5

What action will enable most new functions in DB2 12?

AApplying a specific PTF

BActivation of function level 500 or higher

CEnablement of a new subsystem parameter

DConversion of the BSDS to support 10-byte RBA/LRSN

Show Answer

Correct Answer: B