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 is a result table?

1 5648

What is the SQL Communications Area and what are some of its key fields?

1 5033

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 4290

How would one remove old reorg information from the DB2 catalog?

2 6462

The only place of VSAM KSDS in DB2 is?

IBM,

2 8021

What is DCLGEN?

2 15774

Where is the output of EXPLAIN stored?

2 6856

What is the function of buffer manager?

1 5770

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 6520

What is a lock?

1 4976

What should be specified along with a cursor in order to continue updating process after commit?

IBM,

1 5437

How does DB2 use multiple table indexes?

1 5824

What is meant by repeatable read?

4 10473

Compare a subselect to a join?

1 4994

Describe the elements of the SELECT query syntax?

3 6515

Un-Answered Questions { MainFrame }

Explain the purpose of dd * statement in jcl?

1075

Explain the like inverted list?

961

What is ENQ?

1083

accept ws-date from date will return the current date?

1023

I need exexution process for JCL programs

2283

How to move a field DT 9(8) of input file to DT 9(8) COMP-3 in output file in ezytrieve? in the output file entire dt is not moved.If any answer plz reply as soon as possible.

2210

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1202

Differentiate between control interval (ci) and control area (ca)?

1014

How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?

8589

what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

1236

what is the role of the cursor in db2?

1071

Hello, I have 3 years of exp as a mainframes tester in a leading IT company, now am looking to change my company. Could you please let me know, what are the interview questions/topics i should prepare. Your suggestions are truly valuable for me :) Thanks !!

1949

What is dbrm? What it contains? When it will be created?

1053

In the house keeping section of an MVS assembly language program, like the one below STM R14,R12,12(R13) BASR R12,R0 USING *,R12,R11 LA R11,2048 LA R11,2048(R11,R12) .... .... 1. What if BASR R12,R0 IS NOT PRECEDE USING *,R12,R11? 2. USING (base address), REGISTER does USING directive says assembler to treat particular Register as a base register with the mentioned base address..in the above case * i.e current location counter..well if that is the case why we need BASR R12,R0 ? 3. What if I write like STM R14,R12,12(R13) BASR R12,R0 LA R11,2048 LA R11,2048(R11,R12) USING *,R12,R11 there is no address resolution being calculated in both LA statements so is it a right way to set Base register?..will there be any issues with Domain regarding R11 and R12?

1980

What is the interactive job? What is the batch job?

1045

For More Un-Answered { MainFrame } Questions Click Here