4. EXCEPTIONS › 4.3 Detailed Exception Descriptions › 09008: DA Data Set is in Multiple Extents

09008: DA Data Set is in Multiple 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 direct data sets (DSORG=DA) whose
allocation has expanded beyond a single extent.

    RATIONALE:  Access to a multiple extent data set is
normally less efficient than if the data set were allocated
in a single extent because of the overhead involved in
positioning to the next data set extent.  This is especially
true for a direct data set (DSORG=DA) because of the random
nature of the access to such a data set.  Moving back and
forth among the extents is much easier if the data set is
accessed randomly rather than sequentially.

    DEFINITION:  This exception is detected when a data set's
organization (DSORG) is direct (DA) and the number of data
set extents (DAAEXTNO) is greater than one.

    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:

/*---------------------------------------------------------*/
/*                                                         */
/*  09008                                                  */
/*  DSORG=DA DATA SET IS IN MULTIPLE EXTENTS               */
/*                                                         */
/*---------------------------------------------------------*/
IF DSORG =:  'DA' AND DAAEXTNO GT ONE THEN DO;
  EXCCODE='09008'; SEVERITY='W'; MGMTAREA='PERFORMANCE';
  EXCDESC1='DSORG=DA DATA SET IS IN MULTIPLE EXTENTS.  ' ||
           'EXTENT COUNT=' || PUT(DAAEXTNO,3.);
  EXCDESC2='VOL=' || VOLSER || ', DSN=' || DSNAME;
  LINK HIT;
END;

    THRESHOLD MODIFICATION:  No threshold modification is
required.