IDMS Interview Preparation Guide

Download PDF

CULPRIT is retrieval only, so no need to run cv. Run Local.

It places a record in the database based on the location mode specified.

Autostatus is a protocol mode which causes the expansion of each DML statement to include a 'perform IDMS-Status' statement.

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

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

0307 is end-of-set and 0326 is record not found.

IDD is the Integrated Data Dictionary. It contains information about the elements, record types, sets, maps and dialogues within the database.

It releases all database resources, terminates database processes, writes statistical information to IDMS and logs the checkpoint.

It rolls back (reverses) all database updates to the point of the last rollback or to the beginning of the run-unit.

It writes a checkpoint to the Journal File and releases any record locks.

The READY prepares a database area for access by DML functions.

A set is an owner record and, optionally, its member records. There are three types of pointers: next, prior and owner, but only next is required. There are five possible orders for arrangements of sets; they are: first - insert at beginning, last - insert at end of set, next - insert after current of set, prior - insert prior to current of set and sorted - insert according to sort value.

Calc is based on a symbolic value which is used to determine the target page. Via mode is for members only. Via records are stored near to their owners.
In direct mode the target is specified by the user and is stored as close as possible to that page.

A junction record is a member record type that allows for many-to-many relationship between its two owner records.

An OOK-Rec is a one of a kind record set, used to get to another record set.

A run-unit is a logical unit of work; it is analogous to a CICS task.

In local there is no IDMS System running above the DBMS. It's the more efficient mode but lacks the recovery and integrity facilities of the central version (CV) control program. In CV many application programs access the database through a single copy of the DBMS.

A record occurrence is the instances of a record; it is the smallest addressable unit of data. A type is the description of a record; there needn't be any occurrences.

A page is the smallest unit of storage in an IDMS database

Region is used synonymously with area. It is a group of logically contiguous pages.

The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.

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.

No. The mode is specified via the SYSCTL DD card in the JCL.

They communicate via service MVS request calls.

A bind associates record types with the program work area; for run unit and records it is the first command issued in the program.