IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is meant by concurrency?

1 5367

What is subquery ?

6 10484

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 5128

How does the processing of a correlated subquery differ from a non correlated subquery?

1 6641

Can you define an Index if the table size less than 10 PAGES?

IBM,

1 5475

What are the various locks available?

CTS,

5 10443

What will the DB2 optimizer do?

2 5089

What are the contents of a DCLGEN?

MetLife,

4 11425

What is deadlock?

2 5706

What is Declaration Generator(DCLGEN)?

1 6255

What is the difference between static and dynamic SQL?

1 24975

How many Buffer pools are there in DB2 and what are they?

IBM,

1 6823

What is RUNSTATS?

3 6426

How many sub queries can you combine together ?

IBM,

4 8514

What is a cursor and what is its function?

2 4485


Un-Answered Questions { IBM MainFrame }

how we sort two input files based on a common column and giving one o/p file please send me the coding logic?

1652


What is meant by idd in idms?

476


Is there any command to check wether the ps file is in sorted order?

2430


Explain the processing modes available in ims db?

3130


Explain how many conditions can you include in a single handle condition command?

611






How to traceback if I am getting SOC7 or SOC4 abend? List down the steps

892


how a data in physical and symbolic map gets treated? Since the physical map is much concerned about the screen alignment and the field positions, how the values entered in the field which has PICIN or PICOUT clause in Physical map gets treated? Does that mean datas recieved or sent to the physical map should be constant? How does the data in Symbolic map gets converted with 5suffix namely F,L,A,I and O. For example EMPNO is treated as EMPNOI, EMPNOO, EMPNOA, EMPNOL and EMPNOF. how does this happen in symbolic map. Please provide your inputs on the above and kindly correct me if I am wrong.

2211


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

659


Explain acbgen process?

641


I have program P1 which calls file F1 which has 100 records and following structure 001 .................. 002 .................. 003 .................. 098 .................... 099 ................... 100 .................... Now I want to read these files and write these records in file F2 in following manner. 001 ...... 051 ..... 002 ...... 052 ..... 003 ...... 053 ..... .......... ....... .......... ....... .......... ....... 048 ........ 098 ...... 049 .......... 099 ....... 050 .... 100 ......

10610


why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.

1950


How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?

700


How does jcl act on code(if you take a cobol program)?

709


can you please let me know if there is any walkins for COBOL/PLI/DB2/IMS/JCL in pune other than IBM and ITC infotech

1959


Explain the significance of the shareoptions parameter?

536