IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is the meaning of VSAM RETURN-CODE 28?

3 20581

On which datasets You can have ALT INDEX?

2 4951

How many Alternate Indexes you can have on a dataset?

AB Inc,

2 8926

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

1 5035

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.

1878

What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?

1 13329

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

1 16876

What does the KEYRANGES parameter in Define Cluster commend do?

1 6681

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

IBM,

1 5052

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

4 17417

How to delete a member using JCL.?

5 13521

What is the Difference between LDS & ESDS ?

3 13885

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

3 8697

What is an alternate index and path ?

Infosys, TCS,

2 25402

How many buffers are allotted to VSAM KSDS and ESDS?

1 7413


Un-Answered Questions { IBM MainFrame }

how to compare two datasets without using superce because output is limited to 133 bytes

1480


what are the codes returned by the ams (access method services) command during the execution in vsam?

765


How to override a dsn that is contained in a proc called by another proc? I need to do the override in the calling jcl?

716


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

545


Explain the data storage?

557






I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK

1485


What is idms?

499


Can you define an alias?

576


Explain the difference between a symbolic map and physical map?

565


How many bytes will a s9(8) comp field occupy ?

675


What is dbid used in adabas?

557


How do I add a column to an existing table in db2?

590


How do you create a like table?

530


Is their any set of rules for dd? Explain.

660


Which commend used for terminating a browser operation?

497