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 the command used by TSO users to invoke DB2?

IBM,

2 9423

What is the FREE command?

1 5190

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2860

What is DB2 (IBM Database 2)?

3 5678

What is QUIESCE?

2 13214

what is the name of the default db2 catalog database?

IBM,

3 8557

What are the three DB2 date and time data types and their associated functions?

1 5404

What is the significance of DB2 free space and what parameters control it?

1 5486

Explain the EXPLAIN statement?

1 4994

What is a DBRM, PLAN ?

3 18625

What's the maximum number of characters that a tablename can have?

3 8897

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

CTS, IBM, TCS,

9 15787

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 4935

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2064

Why use RUNSTAT Utility?

Merrill Lynch,

3 23953

Un-Answered Questions { MainFrame }

What is db2 connect?

1081

Does Disconnect and Connect creates page lock in IDMS ?

1464

Explain about cursor stability?

1058

what happens in conversion stage in job processing?

1230

What is the main purpose of having user catalog in vsam?

1068

What is isolation level in db2?

1015

INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?

868

what is the cics command used to access current date and time?

1170

How to get the last record in vsam file in cluster? And how can you get the ksds file records into cobol program?

1177

What is sysplex?

925

what do you mean by a vsam split?

1094

what is xfoot opcode ?

1836

What is the significance of addrspc parameter in the exec statement?

1087

Explain how to find occurrence of mu and pe fields in a file?

936

What are the objectives of dbms in ims?

1099

For More Un-Answered { MainFrame } Questions Click Here