Mainframe Interview Questions

An abnormal situation during execution of a CICS command is called an exceptional condition:

1. Handle Condition Command: It is used to transfer control to the procedure label specified if the exceptional condition specified occurs.

2. Ignore Condition Command: It causes no action to be taken if the condition specified occurs in the program. That is control will be returned to the next instruction following the command which encountered the exceptional condition.

3. No Handle Option: This option can be specified in any CICS command and it will cause no action to be taken for any exceptional condition occurring during execution of this command.

4. RESP Option: This option can be specified in any CICS command. If the RESP option is specified in a command, CICS places a response code at a completion of the command. The application program can check this code, then proceed to the next processing.

Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time. Cursor should be used because the host language  can deal with only one row at a time.

ESDS: Entry Sequence Data Set

KSDS: Key Sequence Data Set

RRDS: Relative Data Set

- DBRM stands for Database Request Module

- The output of pre-compile process is represented as DBRM

- The SQL statements are extracted from the host language by the pre-compiler

When two independent processes contend for the same resource or the resources reserved by one another, it is called a deadlock. -911 and -913 are the SQLcode for a deadlock.

EIBRCODE

There are three types of lock, namely:

Shared – This type of lock permits two or more programs to read from the locked space but does not allow them to change it.

Update – This lock is more lenient. It permits the program to read and change the locked space.

Exclusive – This lock restricts all users from accessing the locked space.

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