If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?

A. DB2_APM_PERFORMANCE

B. DB2_EXTENDED_IO_FEATURES

C. DB2_RESOURCE_POLICY

D. DB2_PARALLEL_IO

Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions?

A. BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS

B. BACKUP DATABASE sample USE TSM OPEN 4 SESSIONS WITH 2 BUFFERS

C. BACKUP DATABASE sample USE TSM OPEN 2 SERVERS WITH 4 BUFFERS

D. BACKUP DATABASE sample USE TSM OPEN 4 SERVERS WITH 2 BUFFERS

What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

A. SECADM authority

B. EXECUTE privilege on audit routines with DATA

C. DBADM authority

D. EXECUTE privilege on audit routines with NO DATA

E. SYSADM authority

What is required to successfully use the check backup utility (db2ckbkp)?

A. system administrator authority

B. read permission on the database

C. system maintenance authority

D. read permission on the backup image

Click the Exhibit button.

Refer to the table definition shown in the exhibit.

Which will improve performance based on the query SELECT c6, c9 FROM tab3 WHERE c9 = 123456?

A. CREATE INDEX idx98 ON tab3 (c6 ASC);CREATE INDEX idx99 ON tab3 (c9 DESC);RUNSTATS ON TABLE myschema.tab3;

B. CREATE INDEX idx98 ON tab3 (c2 ASC, c6 ASC);CREATE INDEX idx99 ON tab3 (c2 ASC, c9 ASC);RUNSTATS ON TABLE myschema.tab3;

C. CREATE INDEX idx99 ON tab3 (c2 ASC, c9 DESC);REORG TABLE myschema.tab3 AND INDEXES ALL;

D. CREATE INDEX idx99 ON tab3 (c6 ASC, c9 DESC);REORG TABLE myschema.tab3 AND INDEXES ALL;

Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?

A. DB2_LIMIT_AS_CONTAINER_BLOCKS

B. DB2_SET_MAX_CONTAINER_SIZE

C. DB2_ALLOCATION_SIZE

D. DB2_TRUNCATE_AS_STORAGE

Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?

A. The ADMINGETTABCOMPRESSINFO table function.

B. The ADMINGETTABCOMPRESSINFO_V97 table function.

C. The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.

D. The ADMIN_GET_TAB_INFO table function.

A database named MYDB is created in instance DB2INST1, which has been configured to use KRB_SERVER_ENCRYPT authentication. If a client attempting to access database MYDB does not support Kerberos authentication, which authentication method will be used to establish a connection?

A. SERVER_ENCRYPT

B. SERVER

C. KRB_SERVER_ENCRYPT

D. CLIENT

Which option of the REORG TABLE statement will release blocks that contain no rows from a multidimensional clustering (MDC) table?

A. RECLAIM EXTENTS ONLY

B. RELEASE FREE EXTENTS ONLY

C. RECLAIM FREE BLOCKS

D. RELEASE FREE BLOCKS ONLY

Click the Exhibit button.

In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node. Explanation: The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?

A. CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS

B. CATALOG DCS DATABASE dsample AS db2t

C. CATALOG DCS DATABASE db2t AS dsample

D. CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS