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 is the command used by TSO users to invoke DB2?

IBM,

2 9405

What is the FREE command?

1 5176

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2840

What is DB2 (IBM Database 2)?

3 5658

What is QUIESCE?

2 13188

what is the name of the default db2 catalog database?

IBM,

3 8529

What are the three DB2 date and time data types and their associated functions?

1 5390

What is the significance of DB2 free space and what parameters control it?

1 5465

Explain the EXPLAIN statement?

1 4973

What is a DBRM, PLAN ?

3 18593

What's the maximum number of characters that a tablename can have?

3 8872

What technique is used to retrieve data from more than one table in a single SQL statement?

CTS, IBM, TCS,

9 15740

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 4928

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?

2060

Why use RUNSTAT Utility?

Merrill Lynch,

3 23913

Un-Answered Questions { IBM MainFrame }

How do you define a variable of comp-1 and comp-2?

1199

how do you reference the printer file formats from cobol programs

1216

Explain the different ways of initiating transaction in cics?

946

Why is it necessary that file needs to be opened in I-O mode for REWRITE?

1318

write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...

2733

What is the use of uni-rexx?

932

what is the difference between a return with transid and xctl? For example program. A is issuing return with transid to program b. Program a. Is isssuing xctl to program b?

1182

how long does the install of oorexx take?

1001

How many bytes S(8) comp field occupy and its maximum value?

2138

What is jcl in mainframe?

1196

What is dbrm? What it contains?

1161

What is the cobol picture clause of the db2 data types date, time, timestamp?

1057

What is the meaning of a (new, catalog, keep) disposition mean?

1109

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11673

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

2442

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