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 3634

What are column-name qualifiers used?

1 3529

Explain transactions, commits and rollbacks in DB2.

3 6996

How is a typical DB2 batch program executed ?

1 5831

What information is held in SYSIBM.SYSCOPY?

1 5029

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

1 4008

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

Mind Tree,

2 6318

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

IBM,

2 6761

what's the error code for Unique Index Violation?

2 7131

When do you use the IMAGECOPY?

4 6854

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

3 5197

When would you prefer to use VARCHAR?

3 6330

Explain an outer join?

1 4450

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

IBM,

1 5115

What is REORG? When is it used?

4 8378


Un-Answered Questions { IBM MainFrame }

What is runstats utility in db2?

558


what is uni-rexx?

586


What is the physical storage length of the data types date, time, and timestamp?

593


What is the mainframe computer?

540


How do I add a column to a table in db2?

612






Is automatic restart possible in jcl?

722


Name the statement which can be used to send data to another mvs jes3 node?

593


How to find schema of a table in db2?

564


Is it possible to code instream data in a PROC?

740


What is program reentrance?

612


How can you use dynamic calls in cics?

599


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

542


Must tape dataset definitions include vol=ser specifications?

962


what is difference bt COND, REGION & TIME parameters at JOB & EXEC. give an exp.

8125


what is meant by s0c-07 system abend codes?

563