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 need of base registers in IBM 360/370?

2695

How to delete generations of gdg without deleting gdg base?

3 17708

how 2 resolve the -311 sqlcode

1 19070

What is the use of base and index registers in the IBM 360/370 processor?

3812

in a indexed file what is procedure for read the records from 12 to 18. please give the code example

L&T,

2 7942

what are the utilities for load and unload the DB2 tables

L&T,

1 10088

IDENTIFICATION DIVISION. PROGRAM-ID. MOVEPGM. DATA DIVISION. WORKING-STORAGE SECTION. 01 WS-I PIC 9(2). PROCEDURE DIVISION. A1000-MAIN-PARA. PERFORM PARA-X WITH TEST BEFORE UNTIL WS-I= 5 STOP RUN. PARA-X. DISPLAY "BEST2". I m getting error s722,while executing the program, seems getting in loop, can anybody tell me why

3 6004

How to increase the logical record length of existing PS file?

7 34917

Can anybody give me example of subscript and index

5 9828

what will happen if pass values more than 100 using PARM parameter?

1 9457

write the logic for PAGEUP and PAGEDOWN by using psuedo conversatation technique?

Cap Gemini,

2 15110

While using SORT FILES =NONE,XSUM I am getting error "ICE172A E XSUM IS NOT SUPPORTED - USE ICETOOL SELECT IF APPROPRIATE"..I want to write duplicate records a a serparte file..how i can do tht?

Steria,

3 16425

how can i pull up a query which was previously stored in qmf

3 11539

How to define a array dynamically.....

Fidelity,

5 10394

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above. 1 What is the maximum number of tables that can be stored on a Partitioned Table Space ? 1 what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture 5 Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code? 6 When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing? 2 how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE IBM 7 max number of columns in a db2 table? 6 What is package versioning? Please give an example. 1 What is the picture clause of the null indicator variable? 6 How do you filter out the rows retrieved from a Db2 table ? 1 What is DB2 (IBM Database 2)? 3 Can any one tell me about Restart logic in DB2.

Cap Gemini,

2 5752

Un-Answered Questions { IBM MainFrame }

In real storage usage. By monitor through rmf iii the usage of real storage keep in increasing everyday. Why this happen?

900

When are scope terminators compulsory?

1093

What is distributed relational database architecture? And components?

1061

Is condition checking possible in jcl?

1260

input= ,,,, mainframe training ,,, hyderabad .... location.... output1=$ mainframe training in hyderabad location$ output2=**** mainframe training in hyderabad location ****. In this pgn when we give input considering the spaces the output is displayed in this format.Like in the place of ,,,, $ should be displayed likewise.So please helpmeout.

2294

What is release/acquire in bind?

1165

What is a ci split?

1028

What is db2 optimizer?

1316

What is multi row fetch in db2?

1108

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

1132

What is the purpose of having vsam data space?

1016

Can we give +2 instead of +1 while creating a new gdg file?

1030

What is the use of db2?

1118

Code the related portions of cics/cobol-i programs to gain addressability to twa area assigned to a particular task. Assme that the size of twa area is 300bytes. What are the advantages if cobol-ii is used in the place of cobol?

1179

Explain how to access vsam file?

1142

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