what are the different types of vsam files available? Explain them
1. Entry sequential data set(ESDS) works like sequential file which contains only cluster and data components.
We must mention NONINDEXED while defining ESDS cluster.
It supports only sequential access in batch program.
2. Key sequential data set(KSDS) has three components(CLUSTER, DATA and INDEX).
We must code INDEXED while defining the KSDS cluster.
Data component consists of sorted records which are based on key values.
Index component consists of key values and the pointer to the data records.
3. Relative Record Data Set(RRDS) records are identified using Relative Record Number (RRN). Records are stored in numbered.
4. The linear dataset(LDS) is a byte-stream dataset which is commonly used in DB2 system. This dataset is rarely used in application programs.
Mainframe important concepts and programs are explained in the IIWOWIIS channel in youtube. Please support us and share your comments.
Is This Answer Correct ? | 0 Yes | 0 No |
should a AIX should be a unique value?
how yo view the vsam file?
By seeing the file itself how can we identify whether it is A vsam file or flat file
is it slower if you access a record through alternative index as compared to primary index?
When CISZ is declared as 4096 at cluster level,is this true that data will have 4096 and index will have default?????
how many buffers are allocated to vsam ksds and esds?
what is freespace
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?
explain the differences between vsam and non-vsam files
what do you mean by a shareoptions parameter (shr) in define cluster command?
How do you decide on optimum values for CI, FREESPACE etc...?
what are the additional information you should give in the dd statement while defining the next generation of a gdg?