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

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 6562

What is the specific need of Plan and..where are the tables in DB2 are physically saved

Infosys,

3 9295

Whtz the specialty of 77 level number ?

Infosys,

2 9680

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

77 I pic 99 value 5 Perorm para-A I times. Para -A. move 10 to I. How many times the para-A will be executed.?

TCS,

9 12761

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

Infosys,

1 8842

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

IBM,

2 7019

suppose there is one PF having two members PF1 PF2.PF has one unique key Emp ID.could you tell me uniqueness in PF will be effective across members as well ? assume emp iD 3333 is in member PF1 would same Emp id be exist also in member PF2 ?

Tesco HSC, Wipro,

2 7237

how to ftp the natural program to desktop? (from mainframe to pc), is it possible?

2 9635

do we need to mention the location of catalogued procedure for each it's call in a single job?

1 5324

when u r using repro command what happens if both infile and outfile names same

4 10235

can we copy a file from fixed block to variable block and vice versa ....asap

1 6212

Plan has the optimized access path in it. But is that optimized access path is attained or known

IBM,

1 4526

how to run JCL thru COBOL.

Patni,

1 5961

Passing a variable parm from JCL to a cobol/db2 program

IBM,

1 16646

Un-Answered Questions { IBM MainFrame }

How to find primary key of a table in db2?

1062

what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

1217

What does the keyranges parameter in define cluster commends do?

945

Which components manage deadlocks in db2?

1065

What is release/acquire in bind?

1102

What does a deadlock mean in DB2?

1161

Can you name a few software running under the mainframe?

948

how do we describe cataloged procedure and an instream procedure?

1077

What are types of indexes?

1068

What is the full form of adabas?

953

How to check table size in db2 sap?

1034

How to Provide Column Names Using the DRAW Command ?

1526

Explain how and where is the twa size set?

1083

What are the processing modes available in ims db?

1074

What is the difference between the positional and keyword parameters? Give examples.

1255

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