Make Sure To Pass C2090-318 Exam Before September 30, 2021

Regina2021-08-03T07:20:14+00:00

You may have read our post about the retirement: IT Certification Exams Which Are About To Retire Found Recently, so you may know that C2090-318 DB2 12 System Administrator for z/OS exam will be retired on September 30, 2021. So you need to make sure to pass IBM certification C2090-318 exam before that day. IBM C2090-318 exam is the requirement of IBM Certified System Administrator – DB2 12 for z/OS certification. C2090-318 exam questions have been released at ITExamShop to ensure that you can pass IBM certification C2090-318 exam in the first attempt. In other words, we have C2090-318 exam questions to help you pass C2090-318 exam before September 30, 2021 successfully.

We have IBM Certification C2090-318 free exam questions online to help you check the quality.

Page 1 of 4

1. In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?

The ability to perform a RESTORE SYSTEM

Time spent rebuilding indexes at disaster site

The amount of data that could potentially be lost

The total number of incremental image copies made

2. Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0?

Parallelism for DPSI is disabled

The DB2 optimizer will not consider DPSI for access path selection

DB2 creates multiple child tasks but works on one task at a time when DPSI is used to drive parallelism

DB2 will use the value specified for the PARAMDEG subsystem parameter to control the degree of parallelism when DPSI is used

3. Which of the following commands can be used to show the client correlation token in order to find details such as the ip-address. port-address and unique-id to identify the distributed transaction?

-DISPLAY LOCATION O

-DISPLAY DDF DETAIL

-DISPLAY THREADH DETAIL

-DISPLAY FUNCTION SPECIFIC

4. Which of the following is an advantage of role-based security?

If you DROP a role that owns objects, those objects will also be dropped

Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time

Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization

If a role creates an object, a user requires no additional privileges to access the object if the access uses that role as the object owner in the SQL statement

5. To simulate a new buffer pool size, what buffer pool parameter is used?

PGFIX

VPSIZE

SPSIZE

AUTOSI2E

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

ONLINE

SYSSTC

SYSTEM

SYSOTHER

7. At what point in the upgrade process is the catalog migrated to DB2 12?

Completion of DSNTIJTC job

At the completion of CATMAI NT in function level 500

After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M100)

After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M500)

8. Which of the following is TRUE about the SYSCTRL authority?

It is designed to allow access to all data directly in DB2

It is designed not to be a part of the administrative authorizations

It is designed so group privileges cannot be granted to SYSCTRL

It is designed to be an administrator in a system with sensitive data

9. Which type of trace is used to record transaction-level data that is written when the processing for a transaction is completed?

Audit

Monitor

Statistics

Accounting

10. Which stored procedures need to be set up in order to register an XML schema?

XSR_VALI DATE and XSR_COMPLETE

XSR_REGISTERandXSR_COMPLETE

XSR_VALIDATE and XSR_ADDSCHEMADOC

XSR ADDSCHEMADOCandXSR COMPLETE

Page 2 of 4

11. Considering the following command:

-CANCEL THREAD {*) FORCE

In which of the following situations can it be used?

On local threads that are not in DB2

On application threads that update NOT LOGGED table spaces

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

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

12. Which of the following utilities would produce information needed to identify UNDO information for a transaction?

DSNJU003

DSNJU004

DSNJLOGF

DSN1LOGP

13. Az/OS system has some storage constraints. The results of-DIS STATS(INDEXMEMORYUSAGE) shows that a huge amount of storage is used for the fast index traversal processes.

What can be done to avoid this storage usage?

Reorganize the listed indexes

Set subsystem parameter INDEX_CLEANUP_THREADS to 0

Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE

Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION COMPATIBILITY V12R1M500 for the listed indexes

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

DSNDB06.SYSDDF

DSNDB01.SYSUTILX

DSNDB01.SYSSPT01

DSNDB01.SYSLGRNX

15. CPU utilization for a DB2 subsystem suddenly increased by approximately 20% and is still at this high level after 24 hours. No increase in workload was expected.

What would be the most efficient analysis to perform?

Check that the WLM settings are set correctly

Start a system-wide performance trace to identify the workload which is causing the high CPU

Execute a -DISPLAY STATS command to identify the workload which is causing the high CPU

Execute a -DISPLAY TRACED command to check if there are additional traces running or if the global trace is on

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

All active members must be running DB2 12

Only one member may be active when the command is issued

The command must be issued with installation SYSADM authority

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

17. Which library contains the early code for DB2 12?

SDSNLINK

SDSNLOD2

SDSNLOAD

SDSNMACS

18. Which DB2 command is used to turn on the recording of CPU usage information for a package?

-START RLIMIT

-START TRACE

-START PROFILE

-START DYNQUERYCAPTURE

19. Which of the following migration steps is optional?

Tailor the DB2 catalog

Define DB2 12 to z/OS

Define DB2 initialization parameters: DSNTIJUZ

Verify the integrity of the DB2 catalog and directory

20. Given the following scenario:

A table has been dropped accidentally and you need to restore the object. DSN1COPY will be used to restore the object but the PSID and the original OBID of the object is not known.

Which stand alone utility will allow you to retrieve that information?

DSNJLOGF

DSN1PRNT

DSN1LOGP

DSN1SDMP

Page 3 of 4

21. Which authority prevents unintended access to user data but allows installation or migration of a DB2 subsystem?

SYSADM

SYSCTRL

Installation SYSADM

Installation SYSOPR

22. While processing a DB2 must-complete function, DB2 encountered an error during an attempt to access the required log data sets.

Which of the following is TRUE?

DB2 abends

The affected page sets will be put into REFP restrictive state

The affected page sets will be put into RESTP restrictive state

DB2 will wait for a reply to message DSNJ154I before retrying the failed log-read request, or before abending

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

IIPHONORPRIORITY = NO

IFAHONORPRIORITY = NO

IIPHONORPRIORITY = YES

IFAHONORPRIORITY = YES

24. The remote clients are receiving SQLCODE -30062 RDB ACCESS FAILURE, which means access to the database failed because the session data is expired.

How can you increase the number of minutes that applications can remain inactive before the associated session data token becomes invalid because of timeout?

Change the UTILITY TIMEOUT field (UTIMOUT subsystem parameter)

Issue the -MODIFY DDF SESSIDLE command to increase session timeout

Change the RESOURCE TIMEOUT field (IRLMRWT subsystem parameter)

Change the POOL THREAD TIMEOUT field (POOLINAC subsystem parameter)

25. Which of the following subsystem parameters is only applicable in a data sharing environment?

DSMAX

TWOACTV

RETLWAIT

REFSHAGE

26. For a general application performance problem, which set of documentation would be most useful for diagnosis?

SVC Dump

RMF Monitor

DIAGNOSE MEPL utility

SMF accounting and statistics traces

27. DB2 has stopped working because it has problems archiving the last active log.

Which of the following commands could be used to resolve the situation?

-SET LOG RESUME

-SET LOG NEWLOG

-SET LOG SUSPEND

-SET LOG LOGLOAD

28. Beginning with function level V12R1M500. what would be the maximum data set size of an active log?

4 GB

123 GB

255 GB

768 GB

29. Which subsystem parameter sets the maximum number of concurrent inbound DDF connections that are to be allowed?

MAXDBAT

CTHREAD

CONDBAT

MAXKEEPD

30. When using a persistent thread bound with RELEASE(DEALLOCATE), which subsystem parameter setting will permit a REBIND PACKAGE at a COMMIT or ROLLBACK in this thread?

BINDNV=BIND

ABIND=COEXIST

APPLCOMPAT=YES

PKGREL COMMIT=YES

Page 4 of 4

31. With which authority can you create, display, activate, or inactivate DB2 audit policies?

SYSADM

SYSOPR

SYSCTRL

SECADM

32. To initiate a system checkpoint without modifying the current LOGLOAD value, which of the following should be issued?

-SET LOG BOTH

-SET LOG RESUME

-SETLOGLOGLOAD(O)

-SET LOG BOTH CHKTIME (10) LOGLOAD(500000)

33. The -DISPLAY THREAD (') TYPE(PROC) command can be used to display information about which of the following?

The subset of system agent threads

Threads executing under batch jobs

All threads that are actively being processed by DB2

Threads executing stored procedures and user-defined functions

34. For best DB2 lock avoidance, which of the following BIND/REBIND options should be included in the REBIND command execution?

ACQUIRE(USE)ISOLATION(CS)

ACQUIRE(USE)ISOLATION(RR)

CURRENTDATA(NO)ISOLATION(CS)

CURRENTDATA(YES) ISOLATION(CS)

35. Which of the following are TRUE regarding the DSN1PRNT utility? (Choose two)

It does not decrypt any encrypted data

The input can be a list of concatenated DB2 VSAM data sets

lt can be executed when the DB2 subsystem is not operational

lt can be executed on both image copies and concurrent copies

Compressed records cannot be printed in decompressed format

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

Log

BSDS

Welcome To Choose Required IT Certification Exams Online

Make Sure To Pass C2090-318 Exam Before September 30, 2021

We have IBM Certification C2090-318 free exam questions online to help you check the quality.

Author