Mainframe Interview Questions

Q:

What is NOTCAT2?

Answer

It is an MVS message that indicates the presence of a duplicate catalogue in the database. This problem can be fixed by removing one of the entries and then adding a new one.

Report Error

View answer Workspace Report Error Discuss

0 3397
Q:

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

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.

Report Error

View answer Workspace Report Error Discuss

0 3395
Q:

What is a DB2 bind?

Answer

A DB2 bind is a process that builds an access path to DB2 tables. 

Report Error

View answer Workspace Report Error Discuss

0 3310
Q:

What is RUNSTATS?

Answer

A DB2 utility used to collect statistics about the data values  in tables which can be used   by the optimizer to decide the access path. It also collects statistics used for space   management. These statistics are stored in DB2 catalog tables.

Report Error

View answer Workspace Report Error Discuss

0 3245
Q:

What are different file OPEN modes available in COBOL?

Answer

Open for INPUT, OUTPUT, I-O, EXTEND.


1.INPUT : for read only purpose


2.OUTPUT : for write only purpose


3.EXTEND : for appending records


4.I-O : for read and write(using EXTEND) purpose

Report Error

View answer Workspace Report Error Discuss

0 3212
Q:

What is REORG? When it is used?

Answer

REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.

Report Error

View answer Workspace Report Error Discuss

0 3151
Q:

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

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.

Report Error

View answer Workspace Report Error Discuss

0 3030
Q:

Explain how to handle exceptional conditions in CICS?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 2980