Labour Day Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

  1. Home
  2. IBM
  3. IBM Data and AI: Data and AI
  4. C2090-318
  5. DB2 12 System Administrator for z/OS Questions and Answers
Note! The C2090-318 Exam is no longer available.

C2090-318 DB2 12 System Administrator for z/OS Questions and Answers

Questions 4

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

Options:

A.

APPLY

B.

ACCEPT

C.

RECEIVE

D.

APPLY CHECK

Buy Now
Questions 5

Which subsystem parameter specifies the action that DB2 takes when a problem occurs with the resource limit specification table during execution of a local, static SQL statement?

Options:

A.

RLFERR

B.

RLFERRD

C.

RLFERRSTC

D.

RLFERRDSTC

Buy Now
Questions 6

Before execution of the CHECK DATA utility, which of the following should be performed?

Options:

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

Buy Now
Questions 7

When must the IRLM address space be active?

Options:

A.

During start of DB2

B.

After startup of DB2

C.

At the first lock request

D.

At the first concurrent lock situation

Buy Now
Questions 8

Which lEAOPTxx parameter and value determines that processes will be routed from zllP to general processors when the zllP engines have no more capacity?

Options:

A.

IIPHONORPRIORITY = NO

B.

IFAHONORPRIORITY = NO

C.

IIPHONORPRIORITY = YES

D.

IFAHONORPRIORITY = YES

Buy Now
Questions 9

Which service class does not have a goal, but runs with a fixed dispatching priority above all of the other work on the system?

Options:

A.

ONLINE

B.

SYSSTC

C.

SYSTEM

D.

SYSOTHER

Buy Now
Exam Code: C2090-318
Exam Name: DB2 12 System Administrator for z/OS
Last Update: Apr 14, 2023
Questions: 60