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?

1124

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

1038

Name the various locking levels available?

1053

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

1082

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

1077

How do you eliminate duplicate values in db2?

1124

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

1037

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

1114

When do you specify the isolation level?

986

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

987

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

1 1986

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

1007

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

1062

What are the contents of dclgen?

1071

Why select is not preferred in embedded sql programs?

1255

Un-Answered Questions { IBM MainFrame }

Is automatic restart possible in jcl?

1164

B37 abend during spufi?

1420

is there any way to execute more than one proc in the same exec statement at the same time..?

2597

How to receive data passed through jcl parm parameter in a natural program?

936

How to get the last record in vsam file in cluster? And how can you get the ksds file records into your cobol program?

1103

Immediate Job opening for mainframe professionals in Keane Bangalore. Please find the below details: Organization: Keane India Location: Bangalore Skill: COBOL, JCL,VSAM,DB2,CICS,IMS,REXX,CLIST Exp: 1 to 4 years only Employment Type: Permenant Employee Note: If you have attended keane interview in past 6 months please ignore this job opening. Please respond to email id keanemfjob@gmail.com OR keanemfjob@yahoo.in with your latest resume and following details, We will contact you within 24 hours: Total IT Exp: Exp in Mainframe: Current CTC: Expected CTC: Notice Period:

3954

Can you explain dfhmdf bms macro?

1020

In a test environment, is there a need to run a runstats?

924

Explain the address converter?

967

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

1331

How many bytes does a s9(7) comp-3 field occupy ?

922

How to connect to db2 database from windows command line?

1020

Name the 3 common ways to create maps?

1080

Explain how many exceptional condition can be given in a handle condition?

988

What is use of restart and how to use it?

1277

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