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 is a typical db2 batch pgm executed?

1174

Differentiate between cs and rr isolation levels? Where do you specify them?

1069

Name the various locking levels available?

1091

Explain how can you do the explain of a dynamic sql statement?

1121

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

1104

How do you eliminate duplicate values in db2?

1184

How do you concatenate the firstname and lastname from emp table to give a complete name?

1075

How do you pull up a query which was previously saved in qmf?

1149

When do you specify the isolation level?

1028

Explain in brief how does db2 determine what lock-size to use?

1040

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 2059

How would you find out the total number of rows in a db2 table?

1050

Can you tell me how can you find out the # of rows updated after an update statement?

1099

What are the contents of dclgen?

1112

Why select is not preferred in embedded sql programs?

1299

Un-Answered Questions { IBM MainFrame }

What is dbrm library?

1051

Tell me how many alternate indexes you can have on a dataset?

1097

What is the use of mdt (modified data tag)?

1050

If an array is multi-dimensional dynamic array how do you deal with it & provide me some examples?

2444

Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.

2434

We have an output dataset in job with disp parameter as shr.

946

What is the connection string to connect to the DB2 Database ?

1128

Define buffer pool.

1051

Explain the difference between dfhcommarea and tsq?

1098

Name a few CICS programs which are generally used ?

1044

Is ibm db2 open source?

1073

Mention the downsides of page level lock.

1161

can we describe the results of opening for input empty vsam files in a cobol program?

1013

What is the difference between read work file 1 and read work file once? Why we are using work file once?

965

What is access path in db2?

986

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