If RECSZ of base cluster for KSDS is changed. How will it impact the RECSZ of the alternate index for the same base ksds cluster. If in case it impacts the alternate index RECSZ then how will we calculate the RECSZ for alt index.
RECSZ(259,259) for KSDS cluster changed to
currently Alter index record length is RECSZ(259,130400).How should we change this
record length corresponds to above base cluster record length.
Joined: 06 Jun 2008 Posts: 8339 Location: Dubuque, Iowa, USA
You DO realize, I hope, that the record size for an alternate index has absolutely no relationship to the base cluster record size? If you read the manual (Access Method Services for Catalogs, accessible from the manuals link at the top of the page) about DEFINE ALTERNATEINDEX you will learn much and be able to answer your own questions.
To calculate the record sixe of the AIX we use the formula:
RECSZ = 5 + AIXKL + (n x BCKL) where where:
- RECSZ is the average record size.
- AIXKL is the alternate-key length (see the KEYS parameter).
- BCKL is the base cluster's prime-key length (you can issue the
access method services LISTCAT command to determine the base
cluster's prime-key length).
- n = 1 when UNIQUEKEY is specified (RECSZ is also the maximum
- n = the number of data records in the base cluster that contain
the same alternate-key value, when NONUNIQUEKEY is specified.
So in the above formula we dont use the RECORD SIZE OF THE PRIMARY key so that also proofs that we don't need to change the RECSZ of AIX if we are changing RECSZ for base cluster.Only if we are changind the keys lenght then we require RECSZ to be changed for AIX.