C2090-312 IBM DB2 11 DBA for z/OS Questions and Answers

Index entries from an index image copy.

Rows from an image copy after the table has been dropped.

Rows from an image copy after columns have been dropped.

Rows from a sequential image copy created by the COPYTOCOPY utility.

This stored procedure helps you monitor currently running threads.

You can create a detailed report of currently running and stopped utilities.

This stored procedure materializes SYSIBM.SYSSTATFEEDBACK for the page sets you specify as input parameter.

You can create RUNSTATS profiles and RUNSTATS recommendations for DB2 tables in your DB2 subsystem.

-DIS THREAD (') TYPE(SYSTEM)

-DIS DB(DSNDB06) SP(SYSTSTAB) USE

-DIS GROUPBUFFERPOOL(GBPO) CONNLIST(YES)

-DIS BUFFERPOOL (BPO) DB(DSNDB06) SP(SYSTSTAB) LIST(ACTIVE)

COPY the table space.

REORG the table space.

REBUILD all of the indexes.

DROP the segmented table space.

Call stored procedure SYSPROC.DSNACCOX.

Call stored procedure SYSPROC.ADMINJNFOJHOST.

Query the SYSI BM.SYSTABSTATS system catalog table.

Query the SYSIBM.SYSTABLES_PROFILES system catalog table.

IDBACK

IDFORE

MAXDBAT

CONDBAT

A trigger can use global variables and change their contents.

A trigger can use global variables but cannot change their contents.

A trigger cannot use global variables but can change their contents.

A trigger cannot use global variables and cannot change their contents.