4. EXCEPTIONS › 4.3 Detailed Exception Descriptions › 09006: VSAM Data Set has Too Many Extents

09006: VSAM Data Set has Too Many Extents

    FILE:             DAA Data Set Allocation File
    SAS FILE NAME:    DETAIL.VCADAA01
    SOURCE LOCATION:  prefix.MICS.USER.SOURCE(DYVCAEXC)

    SEVERITY:         Warning       (SEVERITY='W')
    MANAGEMENT AREA:  Performance   (MGMTAREA='PERFORMANCE')

    PURPOSE:  Identifies when the number of data set extents
exceeds a specified level.

    RATIONALE:  Access to a data set that expands into many
extents can be less efficient than if the data set were
allocated in a single extent due to the increased overhead
required to reposition the data volume to each different
extent.  Also, because a VSAM data set is limited to 128
extents, processing will be aborted if an attempt is made to
expand a data set that already has allocated 128 extents.

    DEFINITION:  This exception is detected when the number
of data set extents (DAAEXTNO) exceeds the specified maximum.

    EXCEPTION STATEMENTS:  The SAS statements identifying the
exception situation and describing the condition are stored
in the source member named in SOURCE LOCATION and are
described below:

/*---------------------------------------------------------*/
/*                                                         */
/*  09006                                                  */
/*  VSAM DATA SET HAS TOO MANY EXTENTS                     */
/*                                                         */
/*---------------------------------------------------------*/
IF DAAEXTNO GE extent#
THEN DO;
  EXCCODE='09006'; SEVERITY='W'; MGMTAREA='PERFORMANCE';
  EXCDESC1='DATA SET HAS TOO MANY EXTENTS.  EXTENT COUNT=' ||
            PUT(DAAEXTNO,3.);
  EXCDESC2='VOL=' || VOLSER || ', DSN=' || DSNAME;
  LINK HIT;
END;
    THRESHOLD MODIFICATION:   The user should modify the
extent# value according to the following conventions:

    extent# - The maximum acceptable number of extents for
         a data set.  A maximum value of 115 would appear as:

         DAAEXTNO GE 115