IBM C2090-318 Exam (page: 2)
IBM DB2 12 System Administrator for z/OS
Updated on: 12-Feb-2026

Viewing Page 2 of 13

Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?

  1. DSNDB06.SYSDDF
  2. DSNDB01.SYSUTILX
  3. DSNDB01.SYSSPT01
  4. DSNDB01.SYSLGRNX

Answer(s): B

Explanation:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_recovercat alogdirectoryobjects.html
Use the following general guidelines for all of the steps in this task:
If you copy your catalog or directory indexes, use the RECOVER utility to recover your indexes. Otherwise, use the REBUILD INDEX utility to rebuild those indexes. For all catalog and directory table spaces, you can list the IBM®-defined indexes that have the COPY YES attribute in the same RECOVER utility statement.
Recovery of the items in the list can be done concurrently or included in the same job step. However, the following restrictions apply:
When you recover the following table spaces or indexes, the job step in which the RECOVER statement appears must not contain any other utility statements. No other utilities can run while the RECOVER utility is running.
DSNDB01.SYSUTILX
All indexes on SYSUTILX
DSNDB01.DBD01



During DB2 restart, it is observed that it takes a significant amount of time to complete.
Which of the following could be tuned to improve restart time?

  1. Specify LBACKOUT=NO
  2. Specify CURRENTDATA(YES)
  3. Reduce system checkpoint interval
  4. Specify LOCKSIZE ANY for DB2 objects

Answer(s): C



Which of the following migration steps is optional?

  1. Tailor the DB2 catalog
  2. Define DB2 12 to z/OS
  3. Define DB2 initialization parameters: DSNTIJUZ
  4. Verify the integrity of the DB2 catalog and directory

Answer(s): D

Explanation:

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



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

  1. DSNXRXAC
  2. DSNXSXAC
  3. DSN3@SGN
  4. DSN3@ATH

Answer(s): A

Explanation:

https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/racf/src/tpc/db2z_installingracfste ps.html



A down level page set is identified by the following error message:
DSNB232I UNEXPECTED DATA SET LEVEL ID ENCOUNTERED
Which of the following should be performed to correct the condition?

  1. Execute a REORG on the object in question
  2. Execute a REPAIR DBD REBUILD on the object
  3. Stop the object, set the DLDFREQ subsystem parameter to OFF. and then restart the object in RW status
  4. Replace the object with an appropriate data set at the proper level and confirm with DSN1PRNT of the header page

Answer(s): B

Explanation:

https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/ugref/src/tpc/db2z_repairsamples.html



Viewing Page 2 of 13



Share your comments for IBM C2090-318 exam with other users:

SB 7/21/2023 3:18:00 AM

please provide the dumps
UNITED STATES


David 8/2/2023 8:20:00 AM

it is amazing
Anonymous


User 8/3/2023 3:32:00 AM

quesion 178 about "a banking system that predicts whether a loan will be repaid is an example of the" the answer is classification. not regresion, you should fix it.
EUROPEAN UNION


quen 7/26/2023 10:39:00 AM

please upload apache spark dumps
Anonymous


Erineo 11/2/2023 5:34:00 PM

q14 is b&c to reduce you will switch off mail for every single alert and you will switch on daily digest to get a mail once per day, you might even skip the empty digest mail but i see this as a part of the daily digest adjustment
Anonymous


Paul 10/21/2023 8:25:00 AM

i think it is good question
Anonymous


Unknown 8/15/2023 5:09:00 AM

good for students who wish to give certification.
INDIA


Ch 11/20/2023 10:56:00 PM

is there a google drive link to the images? the links in questions are not working.
AUSTRALIA


Joey 5/16/2023 5:25:00 AM

very promising, looks great, so much wow!
Anonymous


alaska 10/24/2023 5:48:00 AM

i scored 87% on the az-204 exam. thanks! i always trust
GERMANY


nnn 7/9/2023 11:09:00 PM

good need more
Anonymous


User-sfdc 12/29/2023 7:21:00 AM

sample questions seems good
Anonymous


Tamer dam 8/4/2023 10:21:00 AM

huawei is ok
UNITED STATES


YK 12/11/2023 1:10:00 AM

good one nice
JAPAN


de 8/28/2023 2:38:00 AM

please continue
GERMANY


DMZ 6/25/2023 11:56:00 PM

this exam dumps just did the job. i donot want to ruffle your feathers but your exam dumps and mock test engine is amazing.
UNITED KINGDOM


Jose 8/30/2023 6:14:00 AM

nice questions
PORTUGAL


Tar01 7/24/2023 7:07:00 PM

the explanation are really helpful
Anonymous


DaveG 12/15/2023 4:50:00 PM

just passed my exam yesterday on my first attempt. these dumps were extremely helpful in passing first time. the questions were very, very similar to these questions!
Anonymous


A.K. 6/30/2023 6:34:00 AM

cosmos db is paas not saas
Anonymous


S Roychowdhury 6/26/2023 5:27:00 PM

what is the percentage of common questions in gcp exam compared to 197 dump questions? are they 100% matching with real gcp exam?
Anonymous


Bella 7/22/2023 2:05:00 AM

not able to see questions
Anonymous


Scott 9/8/2023 7:19:00 AM

by far one of the best sites for free questions. i have pass 2 exams with the help of this website.
CANADA


donald 8/19/2023 11:05:00 AM

excellent question bank.
Anonymous


Ashwini 8/22/2023 5:13:00 AM

it really helped
Anonymous


sk 5/13/2023 2:07:00 AM

excelent material
INDIA


Christopher 9/5/2022 10:54:00 PM

the new versoin of this exam which i downloaded has all the latest questions from the exam. i only saw 3 new questions in the exam which was not in this dump.
CANADA


Sam 9/7/2023 6:51:00 AM

question 8 - can cloudtrail be used for storing jobs? based on aws - aws cloudtrail is used for governance, compliance and investigating api usage across all of our aws accounts. every action that is taken by a user or script is an api call so this is logged to [aws] cloudtrail. something seems incorrect here.
UNITED STATES


Tanvi Rajput 8/14/2023 10:55:00 AM

question 13 tda - c01 answer : quick table calculation -> percentage of total , compute using table down
UNITED KINGDOM


PMSAGAR 9/19/2023 2:48:00 AM

pls share teh dump
UNITED STATES


zazza 6/16/2023 10:47:00 AM

question 44 answer is user risk
ITALY


Prasana 6/23/2023 1:59:00 AM

please post the questions for preparation
Anonymous


test user 9/24/2023 3:15:00 AM

thanks for the questions
AUSTRALIA


Draco 7/19/2023 5:34:00 AM

please reopen it now ..its really urgent
UNITED STATES