What does the KEYRANGES parameter in Define Cluster commend do?
Answer / guest
It divides a large dataset into several volumes according to
the Key ranges specified. e.g., KEYRANGES ((0000001 299999
(3000000 599999). if the activity on the key ranges are
evenly distributed, concurrent access is possible, which is
a performance improvement.
| Is This Answer Correct ? | 5 Yes | 0 No |
How many cluster index can have in a table?
Explain the biggest disadvantage of using a vsam dataset?
How can you create a VSAM dataset? Can you write a JCL for it?
How to createing new version of GDG with out loosing the data in preaves GDG version?
How do you fix the problem associated with VSAM out of space condition?
Can we copy Vsam files from a Vsam file in Iebgener step?
4 Answers iGate, Tech Mahindra,
What are the distinctive features of a ksda, key sequenced dataset?
If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?
I have three fields in a Variable VSAM file X(2) Y(10) occurs X times Z(02) Say for the first record X=2 then the length of the file is 2+(10*3)+2=34 second record, x=4 then 4+(10*4)+2=46 If any time if the field x is updated then the total length changes. Is it feasible? Is it
is it required that primary key values have to be unique? Do alternate key values have to be unique?
print ids(/)char??what is the full form of ids??
to use the rewrite command, how should the vsam file be opened?