C2090-600 IBM DB2 11.1 DBA for LUW Questions and Answers

LBAC protection can be applied to a nickname

LBAC cannot be used to restrict access to a staging table

LBAC cannot be used to restrict access to data of columns and rows in the same table

LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

DB2_HADR_ROS

HADR_SPOOL_LIMIT

DB2_HADR_SOSNDBUF

DB2_HADR_PEER_WAIT_LIMIT

UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

CONNECT TO sample;

UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;

CONNECT RESET;

ATTACH TO db2inst1;

UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;

DETACH;

Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.

Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASECONFIGURATION command or the db2CfgSet API.

Set the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.

Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that at least one entry is present in SYSCAT.BUFFERPOOLDBPARTITIONS.

DBADM

SYSADM

SQLADM

SYSCTRL

SYSMAINT

All data, both new and existing, will becompressed.

Only new or updated data for XML columns will be compressed.

New and existing XML columns will be compressed but other columns remain unchanged.

Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.