IBM C2090-318 Exam Practice Test Instant Access

Question 1

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

ADSNDB06.SYSDDF

BDSNDB01.SYSUTILX

CDSNDB01.SYSSPT01

DDSNDB01.SYSLGRNX

Answer : B

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_recovercatalogdirectoryobjects.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

Question 2

Where is recovery information for table space DSNDB06.SYSTSCPY stored?

ALog

BBSDS

CDirectory

DSYSIBM.SYSCOPY

Answer : B

Question 3

Which of the following is required to successfully issue the -ACTIVATE command in a data sharing environment?

AAll active members must be running DB2 12

BOnly one member may be active when the command is issued

CThe command must be issued with installation SYSADM authority

DThe member on which the command is issued must be started in maintenance mode

Answer : B

Question 4

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

Answer : D

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

Question 5

The amount of memory taken up by the local dynamic statement cache is extremely high. How can this be reduced?

ABind more packages using BIND option KEEPDYNAMIC(YES)

BReduce the value specified for subsystem parameter MAXKEEPD

CReduce the value specified for subsystem parameter EDMSTMTC

DReduce the value specified for subsystem parameter MAX_IN_MEMORY

Answer : A

Question 6

What are the appropriate actions that can be taken to reduce false contention in a data sharing environment? (Choose two)

AIncrease the size of the lock structure

BUse LOCKSIZE PAGE and MAXROWS 1

CIncrease the proportional size of the lock table

DIncrease workload with inter-DB2 read/write interest

EReduce the IRLMRWT subsystem parameter value

Answer : A, E

Question 7

What resource is used to communicate BSDS and log data set names between DB2 members in a data sharing group?

ASCA

BDB2log

CDB2 directory

DLock structure

Answer : A

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