Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors
  1. Home
  2. IBM
  3. C2090-318

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

Viewing Page 2 of 13
C2090-318 PDF 60 Questions

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:

asl 9/14/2023 3:59:00 PM

all are relatable questions
CANADA


Siyya 1/19/2024 8:30:00 PM

might help me to prepare for the exam
Anonymous


Ted 6/21/2023 11:11:00 PM

just paid and downlaod the 2 exams using the 50% sale discount. so far i was able to download the pdf and the test engine. all looks good.
GERMANY


Paul K 11/27/2023 2:28:00 AM

i think it should be a,c. option d goes against the principle of building anything custom unless there are no work arounds available
INDIA


ph 6/16/2023 12:41:00 AM

very legible
Anonymous


sephs2001 7/31/2023 10:42:00 PM

is this exam accurate or helpful?
Anonymous


ash 7/11/2023 3:00:00 AM

please upload dump, i have exam in 2 days
INDIA


Sneha 8/17/2023 6:29:00 PM

this is useful
CANADA


sachin 12/27/2023 2:45:00 PM

question 232 answer should be perimeter not netowrk layer. wrong answer selected
Anonymous


tomAws 7/18/2023 5:05:00 AM

nice questions
BRAZIL


Rahul 6/11/2023 2:07:00 AM

hi team, could you please provide this dump ?
INDIA


TeamOraTech 12/5/2023 9:49:00 AM

very helpful to clear the exam and understand the concept.
Anonymous


Curtis 7/12/2023 8:20:00 PM

i think it is great that you are helping people when they need it. thanks.
UNITED STATES


sam 7/17/2023 6:22:00 PM

cannot evaluate yet
Anonymous


nutz 7/20/2023 1:54:00 AM

a laptops wireless antenna is most likely located in the bezel of the lid
UNITED STATES


rajesh soni 1/17/2024 6:53:00 AM

good examplae to learn basic
INDIA


Tanya 10/25/2023 7:07:00 AM

this is useful information
Anonymous


Nasir Mahmood 12/11/2023 7:32:00 AM

looks usefull
Anonymous


Jason 9/30/2023 1:07:00 PM

question 81 should be c.
CANADA


TestPD1 8/10/2023 12:22:00 PM

question 18 : response isnt a ?
EUROPEAN UNION


ally 8/19/2023 5:31:00 PM

plaese add questions
TURKEY


DIA 10/7/2023 5:59:00 AM

is dumps still valid ?
FRANCE


Annie 7/7/2023 8:33:00 AM

thanks for this
EUROPEAN UNION


arnie 9/17/2023 6:38:00 AM

please upload questions
Anonymous


Tanuj Rana 7/22/2023 2:33:00 AM

please upload the question dump for professional machinelearning
Anonymous


Future practitioner 8/10/2023 1:26:00 PM

question 4 answer is c. this site shows the correct answer as b. "adopt a consumption model" is clearly a cost optimization design principle. looks like im done using this site to study!!!
Anonymous


Ace 8/3/2023 10:37:00 AM

number 52 answer is d
UNITED STATES


Nathan 12/17/2023 12:04:00 PM

just started preparing for my exam , and this site is so much help
Anonymous


Corey 12/29/2023 5:06:00 PM

question 35 is incorrect, the correct answer is c, it even states so: explanation: when a vm is infected with ransomware, you should not restore the vm to the infected vm. this is because the ransomware will still be present on the vm, and it will encrypt the files again. you should also not restore the vm to any vm within the companys subscription. this is because the ransomware could spread to other vms in the subscription. the best way to restore a vm that is infected with ransomware is to restore it to a new azure vm. this will ensure that the ransomware is not present on the new vm.
Anonymous


Rajender 10/18/2023 3:54:00 AM

i would like to take psm1 exam.
Anonymous


Blessious Phiri 8/14/2023 9:53:00 AM

cbd and pdb are key to the database
SOUTH AFRICA


Alkaed 10/19/2022 10:41:00 AM

the purchase and download process is very much streamlined. the xengine application is very nice and user-friendly but there is always room for improvement.
NETHERLANDS


Dave Gregen 9/4/2023 3:17:00 PM

please upload p_sapea_2023
SWEDEN


Sarah 6/13/2023 1:42:00 PM

anyone use this? the question dont seem to follow other formats and terminology i have been studying im getting worried
CANADA