What is the minimum buffer pool page size for a compressed index?
When we use multilevel-security using a security label column, which sentence is true?
You have defined the array type PHONENUMBERS using the following DDL:
CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50];
You also defined a variable named RECENT_CALLS based on this new array type as follows:
CREATE VARIABLERECENT_CALLS PHONENUMBERS:
Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?
Given the following output:
DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS -
DSNV402I _DB2D ACTIVE THREADS -
NAME ST A REQ ID AUTHID PLAN ASID TOKEN
DB2CALL T 17039 BBISS BBISS 00AF 19855
TSO T * 3 KSTTEST KSTTEST 0135 20172
A51OTEST N* 13 CICSTEST 0125 19625
You receive a call that user KSTTEST is holding resources and needs to be canceled.
Which command should be issued?
Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?
DB2 AUDIT policies are defined by inserting rows into what DB2 Catalog table?
Which statement about an array data type is true?
Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?
DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000'x is reached and an object's RBA remains in basic 6-byte format.
What processing is NEVER allowed?
Arrays are based on a built-in data type. On which built-in data type can an array NOT be based?