IBM 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 3650

What are column-name qualifiers used?

1 3540

Explain transactions, commits and rollbacks in DB2.

3 7006

How is a typical DB2 batch program executed ?

1 5845

What information is held in SYSIBM.SYSCOPY?

1 5042

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

1 4023

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

Mind Tree,

2 6346

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

IBM,

2 6993

what's the error code for Unique Index Violation?

2 7146

When do you use the IMAGECOPY?

4 6876

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

3 5219

When would you prefer to use VARCHAR?

3 6339

Explain an outer join?

1 4458

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

IBM,

1 5133

What is REORG? When is it used?

4 8384


Un-Answered Questions { IBM MainFrame }

Explain the difference between exec cics handle condtion and an exec cics ignore command?

582


How is deadlock resolved?

648


How to use the same COBOL program in Batch and CICS on lines? explain with an example

1912


Can you define attribute byte?

578


What is the maximum of key fields and search fields allowed in a segment?

568






What is maximum displacement?

620


what is the meaning of each of the values in shareopts(2 3)?

579


Can the values of alphanumeric be moved to variable numeric?

596


Explain the jcl exec statement?

645


What is dclgen in db2?

676


What are the sub parameters for undo command?

560


Explain the configuration section of a cobol program with examples of syntax.

655


what is s000 u4087 error? please give the all error codes in cobol,jcl.

17028


Can you explain function of dbctl?

664


Explore the syntax of the evaluate statement?

539