Joined: 01 Feb 2006
There is a KSDS AIX with Key Length 6 for Primary Key Length 7 and with the maximum possible as length = 229,380 (Any Alternate Index key can hold 32767 Unique records)
Unfortunately, due to business growth, the file is getting beyond 32767 records certain days (File gets cleaned up daily) for a non-unique alternate index.
Is there any JCL or VSAM Utility to get number of Unique Keys for each of the Non-Unique Alternate Index key? This is not a solution but I wanted to check if this is possible to keep a tab on the file until the permanent solution is developed.
Is removing the AIX the only solution and develop a solution outside VSAM to replace the functionality of AIX?
DEFINE ALTERNATEINDEX (
DEFINE PATH (
Joined: 31 Dec 2009
|In the IBM Using Data Sets manual it describes the AIX record layouts. It says that each data record has an indicator if it is for a unique record or not. So I guess you could run a SORT over the AIX data component directly to pull out the records that are unique.
Chapter 6: Organising VSAM datasets, on Page 99
Each record in the data component of an alternate index is of variable length and contains header data,
the alternate key, and at least one pointer to a base data record. Header data is fixed length and provides
the following information:
• Whether the alternate index data record contains primary keys or RBA pointers.
• Whether the alternate index data record contains unique or nonunique keys.
• The length of each pointer.
• The length of the alternate key.
• The number of pointers.