MainFrame Interview Questions
Questions Answers Views Company eMail

What is the meaning of VSAM RETURN-CODE 28?

3 20809

On which datasets You can have ALT INDEX?

2 5131

How many Alternate Indexes you can have on a dataset?

AB Inc,

2 9135

Is it slower if you access a record through ALT INDEX as compared to Primary INDEX? Why?

1 5290

Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.

1976

What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?

1 13529

Describe SHAREOPTIONS parameter (SHR) in Define Cluster command.?

1 17052

What does the KEYRANGES parameter in Define Cluster commend do?

1 6842

What are the optional parameters to the input dataset While loading the empty cluster with the data records?

IBM,

1 5326

What is IDCAMS? and what is the purpose of it?

4 17755

How to delete a member using JCL.?

5 13959

What is the Difference between LDS & ESDS ?

3 14137

Is a delete operation possible in an ESDS?B. Is rewrite operation possible in ESDS ?

3 8963

What is an alternate index and path ?

Infosys, TCS,

2 25656

How many buffers are allotted to VSAM KSDS and ESDS?

1 7554


Un-Answered Questions { MainFrame }

What are the different types of table spaces?

675


Can you explain enq and deq used in cics?

721


What is the role of data manager in the db2 database?

726


We have an output dataset in job with disp parameter as shr.

634


How can a like table be created?

633






What are fillers?

606


Name the sections present in data division.

793


I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?

1309


In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?

1083


How did PL/I originate?

1172


how can you detect and handle a record lock situation?

1371


WHAT IS THE PROCESS OF "CLAIM PROCESSING SYSTEM"

2025


What is the use of symbol // in jcl?

1016


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

733


how can u check no of records in a file?

767