7. Writing Field-developed Applications › 7.6 MSI Unit Level Parameters › 7.6.1 FDA Processing Options (fdaOPS) › 7.6.1.3 Work File Parameters

7.6.1.3 Work File Parameters

FDAs using MSI can utilize standard CA MICS multiple work
file support to spread FDA work files across multiple WORKnn
data sets.  Use the WORK parameter described below to
activate multiple work file support for your MSI FDA.

Note: Before using the WORK parameter, see information on the
use of the MULTWORK parameter in Section 4.2.4.3.1, MSI
Options Statement (MSIOPTS).

WORK n XXX pppp ssss
--------------------

This statement is optional.  It enables sites experiencing
either SAS WORK space allocation problems or out of work
space conditions during DAYnnn, where nnn is the job step
step number, daily update processing to allocate multiple
WORK files.

You can allocate up to nine SAS WORK files for use during the
daily update step.  These additional work files are used in
conjunction with the single work data set allocated by
default using the WORKSPACE parameter.

Because the individual space allocation requirement for each
WORK file is typically much smaller, it is more likely to be
satisfied.

To take advantage of multiple WORK files support, edit
prefix.MICS.PARMS(cccOPS), where (ccc) is the component
identifier, and insert a WORK statement as shown below:

       WORK n XXX pppp ssss

where: n (0-9) is the number of WORK data sets
       XXX  is TRK or CYL
       pppp is the primary allocation
       ssss is the secondary allocation

NOTE:  When allocating any number of SAS WORK data sets, be
aware that one additional SAS WORK data set will
automatically appear in the DAYnnn JCL to facilitate sorting.
For example, if you allocate six SAS WORK data sets, you will
get seven in actuality.

Example 1:  WORK 6 TRK 800 100

In this example, six WORK data sets are specified.  Each data
set has an allocation of 800 tracks primary and 100 tracks
secondary.

Example 2:  WORK 4 CYL 100 20

In this example, four WORK data sets are specified.  Each
data set has an allocation of 100 cylinders primary and 20
cylinders secondary.

NOTE:  Since there is some performance impact when using
multiple work files, you should specify the minimum number of
work data sets to meet your work space requirements.  As a
start, try specifying 2 or 3 work data sets.

How Much Space Should You Allocate?
-----------------------------------

Review prefix.MICS.PARMS(JCLDEF) for EACH unit containing
this product.  Find the WORKSPACE parameter.  It will
resemble this sample statement:

      WORKSPACE      TRK 500 250

The value shows the current SAS WORK space allocation for the
unit as a single data set.  It also serves as the default
value used in the units DAYnnn daily update step unless you
provide a WORK parameter.

To achieve the equivalent work space allocation of
WORKSPACE TRK 500 250 using multiple WORK data sets that will
collectively share the work space requirements of the daily
update step, you could code either:

      WORK 2 TRK 250 125 or WORK 5 TRK 100 50

To determine the total work space, multiply the number of
work files (n) by the primary (pppp) and secondary (ssss)
values specified.

SASWORK
-------

This statement is optional.

The WORK DD statement in the CA MICS procedures allocates
a temporary data set where SAS keeps its temporary data
files and other items that SAS uses during processing of
the current job.

By default, the space allocated is defined in the member
prefix.MICS.PARMS(JCLDEF) with the WORKSPACE and WORKUNIT
parameters, then generated into all the JCL procedures for
a given unit.

With the SASWORK statement you have the option to override
this unit-wide definition to specify the space allocation
individually for the current step.

The format of the SASWORK statement is:

SASWORK data_set_allocation_parameters

where data_set_allocation_parameters is one or more data set
allocation parameters (for example, STORCLAS or SPACE)
separated by spaces.

You can also specify the SASWORK parameter as the following:

SASWORK XXX pppp ssss

where:

  XXX  is TRK or CYL
  pppp is the primary allocation
  ssss is the secondary allocation

If you omit the data_set_allocation_parameters or the SASWORK
statement, the WORK data set is allocated according to the
values you specified for the WORKUNIT and WORKSPACE
parameters in prefix.MICS.PARMS(JCLDEF).  Use the
data_set_allocation_parameters to override this default,
either to alter the space allocation or to use System Managed
Storage (SMS) parameters to control data set placement and
characteristics.

Specify data set allocation parameters, separated by blanks,
according to SAS LIBNAME statement syntax.  If you need
multiple lines, repeat the SASWORK keyword on the
continuation line.

Example:

SASWORK STORCLAS=MICSTEMP SPACE=(XXX,(pppp,ssss))

where:

  STORCLAS - specifies a storage class for a new data set.
             The name can have up to 8 characters.
  SPACE    - specifies how much disk space to provide for
             a new data set being allocated.
  XXX      - is TRK or CYL.
  pppp     - is the primary allocation.
  ssss     - is the secondary allocation.


Note:  If you change the SASWORK parameter, you must:

o  Run cccPGEN
o  Run JCLGENU for DAILY (to regenerate DAILY)