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

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 4370

What are column-name qualifiers used?

1 4309

Explain transactions, commits and rollbacks in DB2.

3 8205

How is a typical DB2 batch program executed ?

1 6638

What information is held in SYSIBM.SYSCOPY?

1 5871

What DB2 Catalog column tell you when an index needs table reorganized ?

1 4728

When can an insert of a new primary key value threaten referential integrity?

Mind Tree,

2 7535

what are the max. & min. no. of partitions allowed in a partition tablespace?

IBM,

2 8983

what's the error code for Unique Index Violation?

2 8320

When do you use the IMAGECOPY?

4 8458

What do you mean by NOT NULL? When will you use it?

3 6542

When would you prefer to use VARCHAR?

3 7688

Explain an outer join?

1 5151

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

IBM,

1 5890

What is REORG? When is it used?

4 9982

Un-Answered Questions { IBM MainFrame }

what are the reserved words for cics?

1098

Every map is categorized into multiple fields, and there are three common working storage fields present for each of these respective fields. Mention those?

1063

How to use the same COBOL program in Batch and CICS on lines? explain with an example

2395

What is an instance in db2?

1035

how to define a directory and what is the structure and definition for the same?

1063

What is consistency token in db2?

1145

What are db2 tables?

1125

What is control interval?

1071

What are the retrieval sequences in ims db?

1356

Explain the logical message in cics?

1030

how can the same proc be re-used and called by many jobs?

1509

Explain about set currency?

868

what is meant by dirty read in vsam?

1347

What is a mainframe?

983

How do you find the maximum value in a column in db2?

1108

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