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 4375

What are column-name qualifiers used?

1 4314

Explain transactions, commits and rollbacks in DB2.

3 8218

How is a typical DB2 batch program executed ?

1 6645

What information is held in SYSIBM.SYSCOPY?

1 5881

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

1 4734

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

Mind Tree,

2 7547

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

IBM,

2 8987

what's the error code for Unique Index Violation?

2 8333

When do you use the IMAGECOPY?

4 8477

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

3 6554

When would you prefer to use VARCHAR?

3 7710

Explain an outer join?

1 5159

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

IBM,

1 5896

What is REORG? When is it used?

4 9997

Un-Answered Questions { IBM MainFrame }

What are db2 objects?

1053

What is the meaning of the enq command?

1094

Explain the function of the dd dcb keyword?

1261

Explain how can values be passed from the job stream to an executable program?

1237

How do I change the column size in db2?

1164

How to fetch 1000 error records from VSAM file(Eg: 1000000 records present) while getting SOC7 abend ?

2484

Which statement is used to identify the private libraries in job?

1197

How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)

3266

What is multithreading in jcl?

1477

what is the resolution for sb37 error

9145

Can we see the copy book length using file-aid?

915

What is the purpose of relative record data set used in vsam?

1102

What is psbgen process?

1168

explain in brief what are the 3 types of vsam files?

1113

What is schema in db2?

1027

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