IBM MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

COBOL (1072)
JCL (1031)
CICS (755)
DB2 (1122)

IMS (143)
IDMS (107)
Natural (81)
ADABAS (26)

REXX (60)
Assembler (68)
CLIST (6)
QMF (32)

MVS (25)
OS390 (10)
OS 2 (7)
VSAM (319)

IBM MainFrame Interview Questions

Questions Answers Views Company eMail

how to fetch the record before the last record in a cobol file( its a huge file and if the key field is not known)

IBM,

5 19043

what is the meaning of pic 9(09)v99-

HSBC,

4 22845

How to open VSAM file from 3.4? i have millions of records and i dont want to use the print ch ids(/) command bcz it takes to much time. so if you have any another command to open this plz tell me.

HSBC,

2 24403

How to change size of Initial number of records to *NOMAX for ALL PF files from perticular library, how can I do that

3234

is there any way to execute more than one proc in the same exec statement at the same time..?

2635

I have a job (4 steps) with time parameter coded in job & exec, say time=10 in job & time =3,2,2,4 in each steps. Will the job executes successfully?

Cognizant,

4 12295

How to find out the number of records in a file using JCL

CTS,

5 46636

Say I have a file with 12 records. Each record has the name of the month. I have to append data in these 12 records into 1 record. How is it possible?

CTS,

2 10112

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

Broadridge,

3581

I have database, in that segment1 having dept code and segment 2 and so on multiple employees num. using dept & employee num we have to compare whether that employee belong to that dept or not, if that employee belongs to that dept then incentive is same same as in the table or else incentive must be zero? using IMS & cobol

IBM,

1 5759

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2099

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2248

What does an outer join do?

CTS,

1 7814

What happens to a cursor after a commit?

3 9939

What do you do to keep the cursor from closing after a commit?

1 6923

Un-Answered Questions { IBM MainFrame }

What is the role of schema in the db2 database?

1276

Explain various types of locks in db2?

1158

what are the idcams commands that can be used for vsam and explain each of them.

991

Can you define aica abend?

1158

What is bmp mode?

3542

What is a plan and package in db2?

1104

i want a program using by if, evaluate , string, unstring, perform, occurs?

4722

Is automatic restart possible in jcl? If yes, how?

1116

what are the differences between and exec cics xctl and exec cics start command?

1237

Explain the difference between pseudo-conversational and conversational?

1091

What is the result of open cursor statement?

1083

What are the difference between jcl and jes?

1612

Why include statement is used in a jcl?

1184

Give a brief description of db2 isolation levels?

1074

what is effect on receive map when

1269

For More Un-Answered { IBM MainFrame } Questions Click Here