I am just listening to Robin sharma audio program, and focusing on to-do list, I got an idea on IMSDB. I decided to give some tough questions here.


  • IMS DB First Released in 1966

  • DB2 Released After IMS DB

  • IMS DC is the Transaction Manager Like CICS

7 Tough IMS DB Interview Questions

  1. In DL/I Database elements are organized in hierarchical structure. There are max 255 segments and 15 levels are possible in a database
  2. Q2)Top-Down-Left-Right is the approach data can be accessed-This is called sequential processing
  3. Q3)For Random processing, key(sequence) field is required. Through concatenated key (from root segment to the segment that you want), randomly record can be accessed.
  4. Q4)DL/I acts as middle layer between Application program and database. Read all imsdb posts here.
  5. Q5)DBD tells complete structure of the database. PSB is program’s view of the database. That means, for a DBD, multiple PSBs are possible.
    1. Q6)PROCOPT=G,R,I etc (check my part-1 for more on this)states access permissions on the database. Also, we can call as locks.
  6. Q7)ACB-also called access control block.It merges PSBs and DBDs into IMS-internal format when application program starts to execution.

Related Posts

3 responses

  1. […] Interview Questions COBOL Interview Questions IMSDB Interview Questions DB2 Interview Questions VSAM Interview Questions CICS Interview Questions JCL Interview Questions […]

    Like

  2. […] IMSDB Interview Questions – The selected IMS DB interview questions that really help you to get complete knowledge in short time. […]

    Like