Wednesday, December 21, 2011

VSAM - Explanation for UPGRADE and UPDATE options

UPGRADE/NOUPGRADE:
Specifies whether the alternate index is part of the base cluster's upgrade set. An upgrade set consists of all of a base cluster's upgradeable alternate indexes.

If you want VSAM to update the alternate index whenever you make a change to the base cluster, code the UPGRADE option in the DEFINE AIX command, or allow it to default to UPGRADE. 

UPDATE/NOUPDATE:
Specifies whether the upgrade set should be updated when this path is processed.

This option tells AMS whether you want VSAM to maintain the base cluster's upgrade set when you process the base cluster via the path. If you sepecify UPDATE, VSAM will open all the alternate indexes in the base cluster's upgrade set when you open the path. And it will maintain those upgrade set members when you process the data set.

The relationship between the UPGRADE/NOUPGRADE parameter of DEFINE AIX and UPDATE/NOUPDATE parameter of DEFINE PATH is sometimes confusing. On the DEFINE AIX command, the UPGRADE/NOUPGRADE parameter specifies whether VSAM should include that particular alternate index in the base cluster's upgrade set. VSAM always maintains this upgrade set when you process the base cluster via its primary key. When you use the UPDATE/NOUPDATE parameter of the DEFINE PATH command, you have additional control over whether VSAM maintains the upgrade set when you process the base cluster via an alternate key.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.