Which parameter decides the allocation size for the tablespace

________is a collection of direct access volumes all of the same device type.

________means another name for the table, but is private to the user who created it.

Opens all tablespaces and acquires all tablespace locks when the plan is allocated

__________utility gathers information about data in tablespaces, indexes and updates DB2 catalog

If a transaction successfully updates a record, it is imperative that it has an ________ on it

If a table is dropped, the space for that table can be reclaimed with minimum reorg in

In Partitioned Tablespace, individual partitions cannot be independently recovered and reorganized

DB2 Security is provided internal to DB2 using the

DEFINE DATA LOCAL 1 #VAR-1 (A25) END-DEFINE MOVE 'THIS IS MY FIRST PROGRAM' TO #VAR-1 WRITE #VAR-1 END The above statements are correct or not.

Packed numeric, 7 positions before and 2 after decimal point and 1 sign position

Command used to catch the syntax errors

A list of the last names and salaries of all employees earning at least $40,000 a year. READ EMPLOYEES WITH SALARY STARTING FROM 40000 DISPLAY NAME SALARY END

What the EXAMINE command will do

What is name of the debug tool for natural programs

Which parameter will be used to stop the execution of a step(which resides in the proc) in JCL.

Which option will be used for spilitting the file using the records count

What does abend code S806 signify

Which parameter is used to call the jcl from another jcl

What does AVGREC parameter will do