ALTER Command and LISTCAT Command in VSAM

ALTER Command

ALTER  entryname[/password]
    [ADDVOLUMES(volser[ volser...])]
    [FREESPACE(CI-percent[ CA-percent])]
    [KEYS(length offset)]
    [RECORDSIZE(average maximum)]
    [REMOVEVOLUMES(volser[ volser...])]
    [TO(date)  |  FOR(days)]
    [UPGRADE  |  NOUPGRADE] [CATALOG(catname[/password])] 

The ALTER is frequently used for:
  • Renaming (NEWNAME)
  • Temporarily disabling updates over dataset(INHIBIT)
  • Altering freespace (FREESPACE)
  • Increase the limit of GDG (LIMIT)


It is almost always a good idea to list the catalog entries for objects immediately following their creation to visually verify that all of the options you intended to specify were entered correctly and had the desired effect on the entry created.  It is also frequently necessary to list fields from the catalog entry for a VSAM object to diagnose problems.

[ENTRIES(entry name,entryname...] | LEVEL(level)] 

The parameters NAME, HISTORY, VOLUME, ALLOCATION, and ALL specify the type of information to list for catalog entries. 

NAME (default)
specifies that only the name and entry type should be listed. 
specifies that the name, entry type, ownerid, creation date, and expiration date should be listed. 
specifies that all information listed by the HISTORY parameter, plus the volume serial numbers and device type should be listed. 
specifies that all information listed by the VOLUME parameter, plus the detail information about space allocation should be listed. 
specifies that all information from the catalog entry should be listed.
may be used to specify that the output from the LISTCAT command should be written to a DD name other than SYSPRINT.

Either the ENTRIES or LEVEL parameter is used to select objects in the catalog for which the entries will be listed.  The names of one or more objects can be included as subparameters of the ENTRIES parameter to select specific objects.  It is also possible to use generic names to select groups of entries based upon the structure of their names.  A generic name uses an asterisk (*) instead of a node name at one or more levels to refer to objects that have any node names at that level.  The LEVEL provides an alternative for specifying a generic name.  When one or more initial qualifiers are specified in a LEVEL parameter, the parameter refers to all objects whose names begin with the specified qualifiers, no matter how long their names are.


Computers TopOfBlogs Technology Blogs Mainframe interview question and answers,mainframe jobs,cobol,vsam,jcl,cics,db2,rdbms,mvs,tso,ispf,ibm,hcl,tcs,cts,wibro Blog Directory