IMS Interview Questions and Answers - DoAnswers.com

Information Management System. Composed of two systems: a Database Manager (IMS DB) and a Transaction Manager (IMS TM). IMS DB: Information Management System Database Manager. IBM�s venerable (introduced in 1968) large system hierarchical DBMS. In casual conversation, either IMS1 DB or IMS TM may be referred to simply as IMS without anyone complaining. Following the introduction of DB2, it was assumed, both inside and outside IBM, that IMS DB would die a slow death as DB2�s performance improved to approach that of IMS DB. But, it never happened, mainly because of the number of major IMS-based applications at large organizations worldwide. Once IBM realized this, a major effort was made to keep both IMS DB and IMS TM up to date with the latest trends, such as Web enablement, though nobody proposed making it into a relational DBMS

IMS Interviews are getting tough these days as the technology grows faster. To get through the IMS interview one needs to update him/herself in a regular manner. Having said that, just before the interview, it is very important to have a quick glance of the reputed IMS questions and answers to make yourself comfortable during the interview process. This is where DoAnswers.com helps you in renewing yourself on IMS and various other technologies interview preparation.

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

A single occurrence of the root along with all its dependents is called the database record.

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 hierarchy and Sequence keys.

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

4. How can we distinguish between an online and batch program in IMS environment?

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

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. Re-build any secondary indexes.

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

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