MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 4370

What are column-name qualifiers used?

1 4308

Explain transactions, commits and rollbacks in DB2.

3 8203

How is a typical DB2 batch program executed ?

1 6636

What information is held in SYSIBM.SYSCOPY?

1 5870

What DB2 Catalog column tell you when an index needs table reorganized ?

1 4727

When can an insert of a new primary key value threaten referential integrity?

Mind Tree,

2 7532

what are the max. & min. no. of partitions allowed in a partition tablespace?

IBM,

2 8982

what's the error code for Unique Index Violation?

2 8317

When do you use the IMAGECOPY?

4 8457

What do you mean by NOT NULL? When will you use it?

3 6541

When would you prefer to use VARCHAR?

3 7686

Explain an outer join?

1 5148

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

IBM,

1 5888

What is REORG? When is it used?

4 9982

Un-Answered Questions { MainFrame }

what are the differences between and exec cics xctl and exec cics start command?

1236

What is cobol db2?

1002

Explain dclgen.

1206

I have many files which i am receiving from client everyday. I have one step for every file to check for empty or not. Here client gives 30 files i need to check for every file for empty or not and i need to perform 30 steps. Can I do it in single step. Dynamically i need to change the File name in my step.

1217

What is page size in db2?

975

Explain how to build up lu 6.2 communication?

1034

Receive consists of buffer option in it. What is the significance of this option?

1047

What is db2 command?

1037

What is db2 instance?

1097

what happens when sflsiz = sflpag? What are the advantages and disadvantages?

1193

what is unit testing ? on which basis you will write test case ?

2015

list the sequence of steps used to achieve modiication in skip sequential mode?

1190

hi provide info about any real time requirement in health care and banking services mainframe applications. pls send immediate reply to me.

1994

How many databases are there?

1054

What is jcl in mainframe, and how many types of jcl statements are there for a job?

1194

For More Un-Answered { MainFrame } Questions Click Here