Which options are valid for an online reorganization operation?

Which statement regarding event monitors is TRUE?

Which command can be used to view the configured global registry settings for all installed DB2 copies found
on a Linux server?

Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2
pureScale cluster?

Which statement about label-based access control (LBAC) is TRUE?

Which security mechanism is responsible for verifying that users are indeed who the claim to be?

Automatic space reclamation for column-organized tables can be accomplished in which of the following
scenarios?

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in
transit?

If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sg1 ON ‘/data1’;
CREATE STOGROUP ibmstogroup ON ‘/data2’;
CREATE STOGROUP sg2 ON ‘/data3’;
Which storage group is the default storage group for the TESTDB database?

The DBA has observed that queries executed against SALES table have poor performance. SALES is a
compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has
detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from
changing data in the SALES table