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

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 5625

max number of columns in a db2 table?

6 25028

Can you access the DB2 Directory table using SQL?

3 7642

What is correlation names?

1 4834

What is an alias?

3 6297

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 6563

What is the difference between Where and Having Clause

IBM, iFlex,

7 30450

Which transaction use a command thread ?

1 3797

What is a LIKE table and how is it created?

2 5491

Name some fields from SQLCA.

2 6537

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

Cap Gemini, Tech Mahindra,

3 18329

What are the isolation levels possible ?

3 7038

What is meant by index cardinality?

2 6572

What does the RUNSTATS Utility do?

4 20654

What is the purpose of the QUIESE Utility?

1 5170

Un-Answered Questions { IBM MainFrame }

What is data trace system 2.0 used for?

5639

How many types of page locks can be held in db2?

1038

Explain ims software environment?

970

What is inspect and what is it used for?

971

What are the disadvantages of a hierarchical database?

3278

What is with ur in db2?

1302

How to rename a table in DB2 ?

1086

which utility is used to run a cobol-db2 program?

1393

What is the difference between binary search and sequential search?

1087

Name what parameter directs the output of the job log dataset?

1048

What is buffer pool and list some of them?

1025

What are the different types of base tables?

1089

What is the pcp in the cics?

928

What is an OOK-Rec?

1698

How to execute 2nd and 4th steps among 5 steps in jcl proc?

1305

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