IMS Interview Questions
Questions Answers Views Company eMail

What do you know about DBD gen?

4 14990

What is a key field in an IMS database?

5 14775

What is the physical nature of a database called?

2 7430

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

2 8203

How many PCB?s can be coded within a PSB?

TCS,

7 17187

What are common status codes that you come across?

Satyam,

4 20399

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

2 6425

which is the first statement in COBOL-IMS programs?

Ford, IBM,

2 13197

Define DBD?

9 13596

Define the terms Parent & Child.

3 5534

What is secondary indexing?

4 15949

What are Twins?

3 6921

What are the parameters used in CBLTDLI call?

CSC,

2 21334

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

1 6248

what are the control blocks in IMS ?

3 13035


Post New IMS Questions

Un-Answered Questions { IMS }

What is the maximum number of fields allowed per segment and what is the maximum number of fields per database?

682


Which languages does ims support / application program languages?

642


What is meant by batch dl/i mode?

658


Explain the processing modes available in ims db?

3206


Explain the advantage of creating the acbs well ahead of time?

3221






What are the advantages and disadvantages of a hierarchical database?

708


What is batch dl/i mode?

2986


What is dbms in ims?

693


What is an ims database?

683


Define ims (db/dc)?

720


What is ims (db/dc)?

682


Explain acbgen process?

716


how to create a changeman read only audit and update only audit Specifications for the Read only Audit 1) Read HFFD database unqualified. 2) Read FDRT, FDDM, FDAP segments. If FDAP-APP-STS is ‘2’ read the FDAV segment and get the FDAV segment which has FDAV-APV-OPTION as ‘X’ If FDAP-APP-STS is ‘5’ read the HFAC database. Read the ACRT segment qualified based on the key obtained from the FDAP segment from HFFD database. Conditions for writing into output file: a. App Type should be NEWR b. App Status should be 1, 2 & 5. c. Write 50 records per app status. For e.g. first 50 records for App status 1, 2 & 5 each The output file should contain the following fields from the database FDRT-COMP-CTRY-CODE X(03). FDRT-CUST-ID-NUM X(10) FDDM-DEM-SEQ-NUM X(01) FDAP-APP-SEQ X(02) FDAP-JNT-IND X(01) FDAP-APP-STS X(01) FDAV-APV-OPTION X(01) FDAV-APV-DT X(06) FDAV-APV-AMT X(07) ACRT-ACCT-NUM X(06) ACRT-SEG-BUS-TYPE X(02) ACRT-NM1-LAST X(19) ACRT-NM1-SS X(09) ACRT-NM1-1ST X(12) ACRT-NM1-INIT X(01) ACRT-NM1-SFX X(03) ACRT-NM1-TITLE X(02) PSB – DVAN2BMP In case you get a GE for any of the conditions, write to output file along with the details of the database segment which was not found. We need to complete this whole process by tomorrow. Run the audit in DLI mode. 2) Sort the output file created in step 1 on Cust ID, Dem Seq & App Seq. Specifications for the Update Audit 3) Take the output of step 2 as input for an update audit. Details are as follows: Read each record & check the app status. If app status is less than 2 then update the FDAP-NEW- MONEY-ENT to $25000.00 PSB - AUDBMPJ The job would be a BMP job. The test job would be run in IMSE region. Note - The proc (which will be called by the job) and the job should also be present in the change-man package itself. You’ll have a test job in your PDS along with overrides to execute the program in test regions. The job would be a DLI job. The test job would be run in IMSE region. It’ll have the following steps. 1) Delete-define output and error files. 2) Use a copybook for the output layout.

3287


Explain the maximum number of pcbs allowed in a psb?

3247


What is the maximum number of segment types allowed for a single database?

722