How do you decide on optimum values for CI, FREESPACE etc...?
Answer / guest
CI size should be based on record length, type of
processing. Usually CI is 4K. If record length is
larger(>1K), chose 6K or 8K. FREESPACE should be large if
more number of insertions are envisaged. Usual values are
(20 2 when heavy updates are expected. CI size can be
calculated.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the Difference between LDS & ESDS ?
How many Alternate Indexes you can have on a dataset?
How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS pgm?s ?
can i see how many records does a vsam file have without browsing or without using file-aid? and same for ps file?
why do we use vsam file thn seqential files ?
What is the significance of the SHAREOPTIONS parameter?
What are the distinctive features of a ksds, key sequenced dataset?
How is the sorting of vsam files carried?
What is Control Interval, Control Area?
how yo view the vsam file?
what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.
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.