IMS INTERVIEW QUESTIONS


I M S ---- I M S ---- I M S ---- I M S ---- I M S ---- I M S ---- I M S

Question: What is the physical nature of a database called?

Answer: DBD

Question: Is it necessary that all the segments in a Dl/i database have key fields ?

Answer: It is not necessary that all the segments in the database should have key field, expect for the database.

Question: How man key fields and search fields can a segment have?

Answer: One key field and as many search fields in the segment can be declared.

Question: Is it necessary that the key field in a Dl/I database be unique?

Answer: No, it is no necessary.

Question: What is a key field in an IMS database?

Answer: A Field that DL/I uses to maintain the segments in the ascending order is called the key field

Question: What is a database record?

Answer: A single occurence of the root along with all its dependents is called the database record.

Question: What is a Hierarchy path?

Answer: A line that starts at the root and passes thru the inter mediate levels in the hierarchy and ends at the a segment at the bottom of the hierarchy is calle the Hierarchy path.

Question: What is a Root?

Answer: The segment at the top of the Hierarchy,which is not a child to a segment is called the Root.

Question: What are Twins?

Answer: Occurences of all the segment types under a single parent segment occurence is called a Twin.

Question: Define the terms Parent & Child?

Answer: Parent-Any segment that has one or more segments directly below it is a Parent. Child-Any segment that has segment directtly above it is called the Child.

Question: What is the limitation on the no. of levels in a DL/I database?

Answer: You can have 15 levels in a DL/I database

Question: How many sgment types can u have in a DL/I database?

Answer: A Dl/I database can have 255 segment types

Question: What is a Segment type?

Answer: Loosely speaking a segment type is a segment in a Dl/I hierarchy chart.

Question: What is a segment?

Answer: A segment is the smllest unit of information that Dl/I uses when working with information in the database

Question: What is Hirarchy Chart?

Answer: A Hierachy chart is a pictorial representation of the total of a DL/I database starting from the root,giving all the parent child relationships that exist within the database

Question: what are the control blocks in ims ?

Answer: there are two control block.1.dbd(database descriptor)2.psb (program specification block)

Question: which is the first statement in cobol-ims programs?

Answer: entry statement is the first statement after procedure division i.e ENTRY 'DLICBL' USING .....

Question: What is the return code you get after a successful IMS call?

Answer: Spaces.

Question: Define DBD?

Answer: DBD : Database Descriptor. IMS Controls the Structure of DB and access to the DB via DBD. The DBD contains information like, Segment types, their location in hiearachy and Sequence keys.

Question: HOW CAN WE DISTINGUISH BETWEEN AN ONLINE AND BATCH PROGRAM IN IMS ENVIRONMENT?

Answer: BY SEEING THE IO-PCB IN THE APPLICATION PROGRAM.

Question: WHICH IS THE DLI FUNCTION USED IN CICS-IMS PROGRAM?

Answer: PCB(PROGRAM COMMUNICATION BLOCK)

Question: WHAT IS IMS?

Answer: INFORMATION MANAGEMENT SYSTEM

Question: How does one reorg an HDAM IMS database when changing RAPS (Root Anchor Points)?

Answer: 1. Unload data using current DBD. 2. Delete/define the underlying VSAM dataset(s). 3. Re-load data using newly-defined DBD with new RAPs. 4. aRaman Re-build any secondary indexes.