IDMS (Integrated Database Management System) Interview Questions & Answers

  1. Question 1. What Does A Store Statement Do?

    Answer :

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

  2. Question 2. What Is Autostatus In Idms?

    Answer :

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

  3. IBM-REXX Interview Questions

  4. Question 3. What Is The Meaning Of Copy Idms Subschema-binds In Idms?

    Answer :

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

  5. Question 4. What Is The Meaning Of Copy Idms Subschema-binds?

    Answer :

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

  6. IBM-REXX Tutorial

  7. Question 5. What Is The Meaning Of The Return Codes 0307 And 0326?

    Answer :

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

  8. RDBMS Interview Questions

  9. Question 6. What Is The Idd In Idms?

    Answer :

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

  10. Question 7. What Does A Finish Do In Idms?

    Answer :

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

  11. IBM Mainframe Tutorial
    DBMS Interview Questions

  12. Question 8. What Does A Rollback Do In Idms?

    Answer :

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

  13. Question 9. What Does A Commit Statement Do?

    Answer :

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

  14. Oracle Interview Questions

  15. Question 10. What Is The Purpose Of A Ready?

    Answer :

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

  16. Database Testing Tutorial

  17. Question 11. What Is A Set In Idms? What Pointers Are Required, What Are Possible? How May Sets Be Ordered?

    Answer :

    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.

  18. IBM Mainframe Interview Questions

  19. Question 12. Name And Explain The Three Location Modes?

    Answer :

    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.

  20. IBM-REXX Interview Questions

  21. Question 13. What Is A Junction Record In Idms?

    Answer :

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

  22. Jenkins Tutorial

  23. Question 14. What Is An Ook-rec In Idms?

    Answer :

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

  24. Question 15. What Is A Run Unit In Idms?

    Answer :

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

  25. SQL Interview Questions

  26. Question 16. What Is The Difference Between Local And Central Version Operating Modes?

    Answer :

    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.

  27. Apache Ant Tutorial

  28. Question 17. Explain The Difference Between Record Occurrence And Record Type In Idms?

    Answer :

    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.

  29. Database Testing Interview Questions

  30. Question 18. What Is A Page In Idms?

    Answer :

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

  31. RDBMS Interview Questions

  32. Question 19. What Is A Region In Idms?

    Answer :

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

  33. Hyper SQL Database Tutorial

  34. Question 20. What Is The Difference Between A Schema And A Subschema In Idms?

    Answer :

    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.

  35. Database Administration Interview Questions

  36. Question 21. If You Are Current On The Owner Of A Set, What Is The Difference Between An Obtain Next And Obtain First In Idms?

    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.

  37. Question 22. Is There A Application Program Coding Difference Between Local And Central Version Mode In Idms?

    Answer :

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

  38. Distributed DBMS Tutorial

  39. Question 23. How Does Idms Communicate With Cics?

    Answer :

    They communicate via service MVS request calls.

  40. Jenkins Interview Questions

  41. Question 24. What Is A Bind In Idms?

    Answer :

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

  42. DBMS Interview Questions

  43. Question 25. When You Are Obtaining Next Within A Set And Get A End Of Set Return Code, On What Record Are You Now Current In Idms?

    Answer :

    You are current on the owner.

  44. Question 26. What Is An Area Sweep And When Is It Used In Idms?

    Answer :

    An area sweep accesses records on the basis of the physical location in a database area. It can be total, meaning a record by record search of the area, or it can be of occurrences of records of a specific type.

  45. Apache Ant Interview Questions

  46. Question 27. How Does Idms Insure Data Integrity?

    Answer :

    IDMS uses record locks to prevent another run-unit from updating the same record.

  47. Oracle Interview Questions

  48. Question 28. What Sets Will The Stored Record Connect To?

    Answer :

    It will connect to all sets where it is defined as an automatic member. The store requires that currency be established for all these set occurrences.

  49. Question 29. What Is Currency In Idms?

    Answer :

    Currency is the location within the database during run-unit execution.

    There are four levels of currency:

    1. current of run-unit is the record occurrence of the last successful find or obtain;
    2. current of record type is for the most recent of each record type;
    3. current of record set is the most recent within each set and current of area is within each area.
  50. Hyper SQL Database Interview Questions

  51. Question 30. So Manual And Automatic Are The Connect Options For A Set. What Are The Disconnect Options?

    Answer :

    Mandatory and optional.

  52. Question 31. Distinguish Among Erase, Erase Permanent, Erase Selective And Erase All?

    Answer :

    1. Erase cancels the membership of a record in specific set occurrences and removes only the named record.
    2. Erase permanent removes the specific record and all mandatory occurrences it owns. It disconnects all optional members.
    3. Erase selective removes the record, all mandatory members and all optional members not connected to other sets. It disconnects those that are connected.
    4. Erase all removes the specified record and all the mandatory and optional records it owns.
  53. Question 32. If The Stored Record Is Not Defined As Automatic Of A Set, How Can It Be Stored As A Member Of The Set?

    Answer :

    Store the record then connect it to each set where it is a manual member.

  54. Mainframe DB2 Interview Questions

  55. Question 33. Why Would You Use Find And Get Rather Than An Obtain?

    Answer :

    Find tells you whether the record is actually in the database. If it is not found you save the overhead of an obtain.

  56. IBM Mainframe Interview Questions