C2090-612 試験問題を無料オンラインアクセス

An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should occur?

• A.Recycle the system with the system parameter LBACKOUT=NO.
• B.Issue a START command with ACCESS(RW).
• C.Issue a RECOVER POSTPONED command.
• D.Issue a STOPcommand and then a START command with ACCESS(RW).

Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?

• A.The client application contains some explainable statements.
• B.The PLAN_TABLE and DSN_STATEMENT_CACHE tables must be created using a EBCDIC encoding scheme.
• C.The dynamic statement cache is enabled.
• D.Both PLAN_TABLE and DSN_STATEMENT_CACHE_TABLE exist on the DB2 server and the table names are qualified with the current SQLID that is used when running the application.

What is the DSNZPARM thatdetermines the maximum amount of temporary storage in the work file data base for a single user at any given time?

• A.MAXDBAT
• B.MAXRBLK
• C.MAXKEEPD
• D.MAXTEMPS

In a data sharing environment, how is the LRSN value created?

• A.It is selected from the DB2 catalog.
• B.It is derived from the sysplex timer (store clock).
• C.It is generated from a sequence object.
• D.It is derived fromcombining RBAs from multiple members.

What START TRACE command provides detailed lock suspend and lock contention trace information?

• A.START TRACE(STATS) CLASS(1)
• B.START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)
• C.START TRACE(AUDIT)
• D.START TRACE(PERFM) CLASS(30) IFCID(44,45)