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 5709

max number of columns in a db2 table?

6 25292

Can you access the DB2 Directory table using SQL?

3 7791

What is correlation names?

1 4956

What is an alias?

3 6445

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 6715

What is the difference between Where and Having Clause

IBM, iFlex,

7 30789

Which transaction use a command thread ?

1 3899

What is a LIKE table and how is it created?

2 5621

Name some fields from SQLCA.

2 6667

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 18500

What are the isolation levels possible ?

3 7201

What is meant by index cardinality?

2 6706

What does the RUNSTATS Utility do?

4 20863

What is the purpose of the QUIESE Utility?

1 5250

Un-Answered Questions { IBM MainFrame }

What is the use of access method services in vsam?

1127

How would you understand error(execution phase)?

1340

How to alter the parameters for the existing gdg?

1259

how to convert the recors form vsam file to db2 table tru file aid

3319

I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.

2680

What is the purpose of dd?

1304

What is distributed relational database architecture? And components?

1067

In sms datasets, what is the function of the dd avgrec keyword?

1168

What is perform what is varying?

1231

Explain the purpose of the dd keylen parameter?

1218

What do you mean by rollback?

1040

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

1034

What type of database is db2?

1025

Explain cedf transaction commands?

1193

How vsam files are read in cics pgms?

1364

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