Question 1

Is there a application program coding difference between local and central version mode in IDMS?

Accepted Answer

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

Question 2

What is the meaning of Copy IDMS Subschema-Binds?

Accepted Answer

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

Question 3

If you are current on the owner of a set, what is the difference between an obtain next and obtain first in IDMS?

Accepted 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

Question 4

How does IDMS insure data integrity?

Accepted Answer

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

Question 5

What is a junction record in IDMS?

Accepted Answer

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

Question 6

What is currency in IDMS?

Accepted Answer

Currency is the location within the database during run-unit execution There are four levels of currency: - Current of run-unit is the record occurrence of the last successful find or obtain; - Current of record type is for the most recent of each record type; - Current of record set is the most recent within each set - Current of area is within each area

Question 7

What is purpose of VSAM?

Accepted Answer

VSAM acts as an interface between Application program & Operating System

Question 8

How do you convert flat files to VSAM files?

Accepted Answer

Use IDCAMS REPRO to load the flat file into the VSAM file

Question 9

During processing of a VSAM file, some system error occurs and it is subsequently unusable What do you do?

Accepted Answer

Run VERIFY

Question 10

Name some common VSAM error conditions and codes?

Accepted Answer

End of file (10) Duplicate key (22) Record not found (23) VSAM logic error (90) Open problem (92) Space problem (93)

Question 11

Assuming that the DEFINE JCL is not available, how do you get info about a VSAM files organisation?

Accepted Answer

Use the LISTCAT command

Question 12

What is a VSAM slot?

Accepted Answer

A relative record dataset (RRDS) consists of a specified number of areas called slots Each slot is identified by a relative record number (RRN) which indicates its relative position in the file

Question 13

How do you fix the problem associated with VSAM out of space condition?

Accepted Answer

Define new VSAM dataset allocated with more space Use IDCAMS to REPRO the old VSAM file to new VSAM dataset Use IDCAMS to ALTER / RENAME the old VSAM dataset to DELETE the old VSAM datset Use IDCAMS to ALTER / RENAME the new VSAM dataset to the name of the original VSAM dataset

Question 14

What are the three levels of definition for the VSAM DEFINE?

Accepted Answer

They are DEFINE CLUSTER, DATA and INDEX

Question 15

What are the different types of VSAM files available?

Accepted Answer

ESDS: Entry Sequence Data Set KSDS: Key Sequence Data Set RRDS: Relative Data Set

Question 16

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

Accepted Answer

If in application program IO-PCB is there then it is a online program In ENTRY statement IO-PCB must be listed first and then DB-PCB

Question 17

What are the two types of fields available in IMS DB?

Accepted Answer

Key Fields - (PROCOPT=K) - Used to sequence the database and can't be changed - It is the field within a segment, used to identify the occurrence of the segment - Used to maintain the IMS segments in ascending sequence Search Fields - (PROCOPT=G) - Used to search for a segment, without the segment being sequenced on that field - A segment need not have a key or search field Both types of fields can be used to search the database

Question 18

What are the processing modes available in IMS DB?

Accepted Answer

Batch DL/I MPP Mode - (Message Processing Program) BMP Mode - (Batch Message Processing)

Question 19

What are the difference between in-stream procedure and inline procedure in JCL ?

Accepted Answer

An in-stream PROC is defined right in the jcl stream and doesn't reside in the proclib This is an older technique associated with punched cards but it is still in use with setup and installation programs from vendors for the in-line perform instead of: perform add-paragraph until switch = 'y' you can code perform until switch = 'y' body of code end-perform body of code is the code from add-paragraph appearing in-line (ie right in the perform) instead of in a separate paragraph (out of line code)

Question 20

In an AVL tree the balancing is to be done when the pivotal value is in range of

Accepted Answer

Difference between the heights of left and Right subtrees in an AVL tree can never be greater than +1

Technology Questions