C2090-318 시험 - IBM실제시험문제와 답 - 60문항

Question No : 1

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?

A.DSNJLOGF
B.DSN1PRNT
C.DSN1LOGP
D.DSN1SDMP

정답:

Question No : 2

Which of the following migration steps is optional?

A.Tailor the DB2 catalog
B.Define DB2 12 to z/OS
C.Define DB2 initialization parameters: DSNTIJUZ
D.Verify the integrity of the DB2 catalog and directory

정답:
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_runlinkch kr.html

Question No : 3

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

A.-START RLIMIT
B.-START TRACE
C.-START PROFILE
D.-START DYNQUERYCAPTURE

정답:

Question No : 4

Which library contains the early code for DB2 12?

A.SDSNLINK
B.SDSNLOD2
C.SDSNLOAD
D.SDSNMACS

정답:
Explanation:
The link list look-aside address space (LLA), which contains the Db2 12 early (ERLY) code from the SDSNLINK load module library. https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_refreshdb2zosmigr.html

Question No : 5

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

A.All active members must be running DB2 12
B.Only one member may be active when the command is issued
C.The command must be issued with installation SYSADM authority
D.The member on which the command is issued must be started in maintenance mode

정답:

Question No : 6

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?

A.Check that the WLM settings are set correctly
B.Start a system-wide performance trace to identify the workload which is causing the high CPU
C.Execute a -DISPLAY STATS command to identify the workload which is causing the high CPU
D.Execute a -DISPLAY TRACED command to check if there are additional traces running or if the global trace is on

정답:

Question No : 7

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

A.DSNDB06.SYSDDF
B.DSNDB01.SYSUTILX
C.DSNDB01.SYSSPT01
D.DSNDB01.SYSLGRNX

정답:
Explanation:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_reco vercatalogdirectoryobjects.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:

Question No : 8

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?

A.Reorganize the listed indexes
B.Set subsystem parameter INDEX_CLEANUP_THREADS to 0
C.Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE
D.Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION COMPATIBILITY V12R1M500 for the listed indexes

정답:

Question No : 9

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

A.DSNJU003
B.DSNJU004
C.DSNJLOGF
D.DSN1LOGP

정답:
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/pdf/db2z_12_ugrefbook.p df

Question No : 10

Considering the following command:
-CANCEL THREAD {*) FORCE
In which of the following situations can it be used?

A.On local threads that are not in DB2
B.On application threads that update NOT LOGGED table spaces
C.If you are terminating a distributed thread that is part of a global transaction
D.If the CANCEL THREAD command without the FORCE option does not terminate the thread

정답:

Question No : 11

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

A.XSR_VALI DATE and XSR_COMPLETE
B.XSR_REGISTERandXSR_COMPLETE
C.XSR_VALIDATE and XSR_ADDSCHEMADOC
D.XSR ADDSCHEMADOCandXSR COMPLETE

정답:
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.xml.doc/ doc/c0022711.html
When a database is created, the stored procedures used to register XML schemas are also created. To register XML schemas through the stored procedure method, invoke the XSR_REGISTER, XSR_ADDSCHEMADOC and XSR_COMPLETE stored procedures with the CALL statement.

Question No : 12

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

A.Audit
B.Monitor
C.Statistics
D.Accounting

정답:
Explanation:
Accounting traceThe accounting trace records transaction-level data that is written when the processing for a transaction is completed. It provides data that enables you to conduct DB2 capacity planning and to tune application programs.
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/perf/src/tpc/db2z_tracetyp es.html

Question No : 13

Which of the following is TRUE about the SYSCTRL authority?

A.It is designed to allow access to all data directly in DB2
B.It is designed not to be a part of the administrative authorizations
C.It is designed so group privileges cannot be granted to SYSCTRL
D.It is designed to be an administrator in a system with sensitive data

정답:
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/seca/src/tpc/db2z_sysctrla uthority.html
The SYSCTRL authority is designed for administering a system that contains sensitive data. With the SYSCTRL authority, you have nearly complete control of
the DB2® subsystem. However, you cannot access user data directly unless you are explicitly granted the privileges to do so.

Question No : 14

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

A.Completion of DSNTIJTC job
B.At the completion of CATMAI NT in function level 500
C.After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M100)
D.After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M500)

정답:

Question No : 15

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

A.ONLINE
B.SYSSTC
C.SYSTEM
D.SYSOTHER

정답:

IBM C2090-318 시험