Which DSNZPARM parameter controls the number of locks that may be acquired on a table space?
Which DSNZPARM parameter controls the number of locks that may be acquired on a table
space?
which statement is correct?
DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is
correct?
which coupling facility structure is used?
In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution
from one DB2 member to another, which coupling facility structure is used?
Which clone table statement is correct?
Which clone table statement is correct?
What is a potential consideration when using triggers?
What is a potential consideration when using triggers?
How many VSAM clusters will DB2 create?
Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3
CLOB(1K)) ; How many VSAM clusters will DB2 create?
which table space type does the ALTER fail?
You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type
does the ALTER fail?
Which of the following activities must be performed first in order to compress the existing index IX1?
Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX
IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the
following activities must be performed first in order to compress the existing index IX1?
Which of the following does NOT make a view a read-only view?
Which of the following does NOT make a view a read-only view?
what action should occur?
A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?