Integrated Database Management System Interview Questions - IDMS interview questions and answers by expert members with experience in IDMS subject. Discuss each question in detail for better understanding and in-depth knowledge of IDMS
What are storage attributes of records?
The following are the storage attributes of records:
Storage attributes of records
Length: Records can either be stored as fixed length or variable length
Fixed length: The whole record instance is persisted in a contiguous block of memory on the line
Variable length: The root part of the record is persisted on the current line. The remaining part of the record is persisted on some other part of the memory.

Distinguish among erase, erase permanent, erase selective and erase all?
Erase cancels the membership of a record in specific set occurrences and removes only the named record.
Erase permanent removes the specific record and all mandatory occurrences it owns. It disconnects all optional members.
Erase selective removes the record, all mandatory members and all optional members not connected to other sets. It disconnects those that are connected.
Erase all removes the specified record and all the mandatory and optional records it owns.

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.

What is the Difference between Fixed length and Variable length records?
Fixed length records access is faster
Variable length records maintain better utilization of space

What is currency in IDMS?
Currency is the location within the database during run-unit execution.
There are four levels of currency:
Record Currency - Most recent record occurrence of each record type is identified by db-key. IDMS/R maintains unique record currency for each record.
Set Currency - This is the most recent record occurrence of every set that is accessed by the program. Separate currency key for each set is maintained by IDMS/R.
Area Currency - Area currency is the most recent record occurrence of every area that is accessed by the program. Separate currency for each area is maintained by IDMS/R.
Run Unit Currency - RUC is the database key of the most recent record occurrence that is accessed by the program.
What is the purpose of a READY?
The READY prepares a database area for access by DML functions.

What are the uses of COMMIT and FINISH?
  • A CHECKPOINT is written to the Journal File.
  • Releases record locks, if any.
  • Releases the database resources that are active.
  • Terminates all the processes of database.
  • Writes statistical information to IDMS.
  • Logs a CHECKPOINT.
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.

Explain about FIND and OBTAIN commands.
  • FIND command is a choice when the contents of the records are not needed.
  • IDMS will not through the overhead of record contents movement occurrence into program storage area.
  • Locating and accessing database records is done by OBTAIN command.
  • When contents of the records are needed, do not use GET / FIND commands.
  • Less verbiage is used by OBTAIN command.
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.

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.

What is a database?
Database is a collection of organized information.
Database models are of four types:
Flat files: The whole data is persisted in a series of files without controls and redundancy.
Hierarchical Database: The database architecture resembles a tree structure.
Network Database: The network database architecture resembles that of hierarchical database with some variations.
The main difference is that a relationship between two nodes at the same level, say F and G (siblings) can be established;
Relational Database: In relational database, the data is represented in the form of tables.

What is the difference between local and central version operating modes?
Local mode:
  • A batch program, which is operates in local mode, has its own copy of IDMS DBMS loaded into its address space.
  • It is suggested for Batch Retrieval programs.
  • The operation of local mode is faster.
  • When the records are updated, offline areas are taken. Other users have no access to the database even in retrieval mode.
  • JCL can run in any of the regions.
Central Version:
  • A single copy of IDMS DBMS will control various operations of a particular IDMS set application programs run unit.
  • All CCOBOL/Online are to be used only Central Version.
  • The operations of local mode is slow
  • There is no need of taking offline area.
  • Concurrent users can access the same area at a time.
  • JCL mandatorily run in a particular region.
Name and explain the location modes?
  • The values of any field of a record is converted into a combination of page no and line no. 
  • This process is implemented by means of a hashing algorithm.
  • A record can be accessed directly.
  • The member is persisted near to the owner.
  • The member can be accessed only by owner.
  • The storage location is specified in the application program.
Explain about logical data model of IDMS
  • The logical data model is the data model offered to CODASYL (Conference On Data System Languages).
  • The prime structure of this model is records and sets.
  • All the records essentially follows COBOL pattern, consisting of fields of different types, which allows internal structure, like repeating items and groups.
  • The most distinctive structure is the 'set'.
  • The ‘set’ represents a one-to-many relationship among records – one owner and many members.
  • A record can be a member in different sets, which is the key factor for distinguishing network model from hierarchical models.
  • Each set belongs to a set identified by a name. Every set is an ordered sequence of records.
  • A record is an owner and member of any number of sets.
  • The database key is directly related to the physical address of the record on a disk.
  • Records could be accessed directly by using database key, followed by set of relationships or by direct access using the key values.
What methods are available for persisting records in an IDMS database?
There are four methods are available for persisting records in an IDMS database.
  • The target is specified by the user and persists as close as possible to that page.
  • The records are simply places each record at the end of the area.
  • A hashing algorithm is utilized for deciding the place of the record.
  • The hash key provides an efficient retrieval of the records.
  • The CALC records are linked to the page of CALC owner record by utilizing a single link-list.
  • VIA attempts to store a record near its owner in a particular set.
  • The records are clustered on the physical page as the owner
  • The records are persisted in a different IDMS area, yet remain clustered together for efficiency.
Request to Download PDF


Vestibulum bibendum felis sit amet dolor auctor molestie. In dignissim eget nibh id dapibus. Fusce et suscipit orci. Aliquam sit amet urna lorem. Duis eu imperdiet nunc, non imperdiet libero.

Post A Comment: