Assuming that the DEFINE JCL is not available, how do you get info about a VSAM files organisation?

Correct Answer: End of file (10) Duplicate key (22) Record not found (23) VSAM logic error (90) Open problem (92) Space problem (93)

Correct Answer: Run VERIFY

Correct Answer: Use IDCAMS REPRO to load the flat file into the VSAM file

Correct Answer: VSAM acts as an interface between Application program & Operating System

Correct Answer: Currency is the location within the database during run-unit execution There are four levels of currency: - Current of run-unit is the record occurrence of the last successful find or obtain; - Current of record type is for the most recent of each record type; - Current of record set is the most recent within each set - Current of area is within each area

Correct Answer: A relative record dataset (RRDS) consists of a specified number of areas called slots Each slot is identified by a relative record number (RRN) which indicates its relative position in the file

Correct Answer: Define new VSAM dataset allocated with more space Use IDCAMS to REPRO the old VSAM file to new VSAM dataset Use IDCAMS to ALTER / RENAME the old VSAM dataset to DELETE the old VSAM datset Use IDCAMS to ALTER / RENAME the new VSAM dataset to the name of the original VSAM dataset

Correct Answer: They are DEFINE CLUSTER, DATA and INDEX

Correct Answer: ESDS: Entry Sequence Data Set KSDS: Key Sequence Data Set RRDS: Relative Data Set

Correct Answer: If in application program IO-PCB is there then it is a online program In ENTRY statement IO-PCB must be listed first and then DB-PCB