What is purpose of VSAM?

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 junction record is a member record type that allows for many-to-many relationship between its two owner records

Correct Answer: IDMS uses record locks to prevent another run-unit from updating the same record

Correct Answer: No difference There is a difference between obtain first and obtain next for an area sweep, but not when current on the owner in a set

Correct Answer: It generates a bind run-unit and binds all the records for the sub-schema the program is referencing

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

Correct Answer: Run VERIFY

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: Use the LISTCAT command

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