Operational IDMS Interview Preparation Guide
Download PDF

IDMS Interview Questions and Answers will guide us now that IDMS (Integrated Database Management System) is a (network) CODASYL database management system first developed at B.F. Goodrich and later marketed by Cullinane Database Systems, So start preparation for the job of IDMS by the help of this IDMS Interview Questions with Answers guide

34 IDMS Questions and Answers:

Table of Contents:

Operational  IDMS Job Interview Questions and Answers
Operational IDMS Job Interview Questions and Answers

1 :: Should culprit to run local or cv?

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

2 :: What does a store statement do?

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

3 :: What is autostatus in IDMS?

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

4 :: What is the meaning of Copy IDMS Subschema-Binds in IDMS?

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

5 :: What is the meaning of Copy IDMS Subschema-Binds?

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

6 :: What is the meaning of the return codes 0307 and 0326?

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

7 :: What is the IDD in IDMS?

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

8 :: What does a FINISH do in IDMS?

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

9 :: What does a ROLLBACK do in IDMS?

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

10 :: What does a COMMIT statement do?

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

11 :: What is the purpose of a READY?

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

12 :: What is a set in IDMS? What pointers are required, what are possible? How may sets be ordered?

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.

13 :: Name and explain the three location modes?

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.

14 :: What is a junction record in IDMS?

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

15 :: What is an OOK-Rec in IDMS?

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

16 :: What is a run unit in IDMS?

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

17 :: What is the difference between local and central version operating modes?

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.

18 :: Explain the difference between record occurrence and record type in IDMS?

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.

19 :: What is a page in IDMS?

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

20 :: What is a region in IDMS?

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

21 :: What is the difference between a schema and a subschema in IDMS?

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.

22 :: If you are current on the owner of a set, what is the difference between an obtain next and obtain first in IDMS?

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.

24 :: How does IDMS communicate with CICS?

They communicate via service MVS request calls.

25 :: What is a bind in IDMS?

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