IBM MainFrame Interview Questions
Questions Answers Views Company eMail

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 10497

What does the REORG Utility do?

2 13039

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 16025

What do you know about DBD gen?

4 14502

What is a key field in an IMS database?

5 14378

What is the physical nature of a database called?

2 7242

What is the limitation on the no. of levels in a DL/I database?

2 7924

How many PCB?s can be coded within a PSB?

TCS,

7 16680

What are common status codes that you come across?

Satyam,

4 20084

How man key fields and search fields can a segment have?

2 6184

which is the first statement in COBOL-IMS programs?

Ford, IBM,

2 12936

Define DBD?

9 12763

Define the terms Parent & Child.

3 5344

What is secondary indexing?

4 15596

What are Twins?

3 6597


Un-Answered Questions { IBM MainFrame }

Explain foreign keys?

557


Explain how does idms communicate with cics?

501


Outputs of explain are with matchcols = 0. What does this signify?

622


Kindly specify the pic clause for the hhmmss type of data fields?

653


What is the procedure to solve an ASRA ABEND?

613






Explain how pa key is different from pf key?

654


What is coalesce in db2?

682


Can anyone provide me the source code for LOC(lines of code) counter written in REXX language which can run on IBM mainframe z/OS V1R4. The LOC counter should be able to count the comments,lines of code,blank lines in a COBOL program and JCL's

2105


a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?

623


What is bufferpool in db2?

580


Which isolation level provides highest data integrity?

599


What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?

678


Can a CICS code be a part of a copybook? If so, then what are the outcomes after compilation?

626


What are the different types of condition in cobol and write their forms.

660


How does cobol compile db2 program?

610