Which of the following are the lock types?

Which VSAM file status code indicates that you are tring to open a VSAM file that is not present?

What does a VSAM file status code '10' indicate?

When you try to open a VSAM file, which of the following status codes are acceptable?

File status code 86 indicates 'VSAM - MISSING DD STATEMENT IN JCL'. True or false?

An Index can be defined if the table size is less than 10 PAGES

What is the maximum number of tables that can be stored on a Partitioned Table Space?

The best locksize that you could use when you create a tablespace is ANY.

SQLCABC contains value of SQLCA.

CPU processing is more important for DB2 system performance.

DECLARE CURSOR is executable.

88 level used for

77 level used for

level 66 used for

SEARCH command used for

To restart a PROC from a particular step, we need to specify RESTART=PROCSTEP.STEPNAME in the Job CARD. where PROCSTEP = name of the JCL step that invoked the PROC and STEPNAME = name of the PROC step where you want execution to start.

If we specify COND=ONLY in a step. This means that particular step is executed only of any of the previous steps, terminated abnormally.

TYPERUN=JSCAN in the JOB card is used to check the syntax of the JCL without running it.

The JOB, EXEC,DD and IF () ENDIF are the Job Control statements.

DISP=MOD is used when the dataset can be extended.