How many Alternate Indexes you can have on a dataset?
Answers were Sorted based on User's Feedback
Answer / sivakumar devaram
253.but not more than 5 recommended because of overheada in
storing and maintaining alternate indexes.
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / guest
255 - but you must be a nut to have so many ALT Indexes on a
dataset!
| Is This Answer Correct ? | 7 Yes | 6 No |
write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
What does a file status of 02 on a VSAM indicate?
Would you specify FREESPACE for an ESDS?
How do you define a KSDS ?
What is the VSAM-code field?
How do you initialize a VSAM file before any operation? a VSAM with alternate index?
On which dataset you can have alt index?
What is the difference between PS file and VSAM file?
7 Answers IBM, Infosys, Verizon,
what do you mean by gdg in vsam?
What are the different commands used in idcams for vsam?
Define base cluster?