2. Planning for Installation and Use of CA MICS › 2.3 Installation Planning and Parameter Specification › 2.3.3 CA MICS JCL Planning and Parameters › 2.3.3.3 JCLGEN Parameters for Special Requirements › 2.3.3.3.2 JCLGEN Definition Tables › 2.3.3.3.2.4 CA MICS Database Split Table (DBSPLIT)

2.3.3.3.2.4 CA MICS Database Split Table (DBSPLIT)

The CA MICS Online Database is composed of five timespans:
DETAIL, DAYS, WEEKS, MONTHS, and YEARS.  CA MICS allows the
files associated with each timespan to be spread across one
to 37 OS files.  This table is used to specify which CA MICS
Information Areas (a logical grouping of component files)
will be in which OS files.

The CA MICS Database Split Table consists of a number of
statements in member DBSPLIT in prefix.MICS.PARMS.  This
table is free-form but positional.  Comments are specified by
starting the line with an asterisk.  The first field is the
component's Information Area name (e.g. ADM, TSO, SCP,
etc.).  The other fields are the DD names where the
Information Area files are to be written.  The possible DD
names are:

    DETAIL  DETAILs
    DAYS    DAYSs
    WEEKS   WEEKSs
    MONTHS  MONTHSs
    YEARS   YEARSs

where s is the split id 0-9 or A-Z.

NOTE:  When a numeric database id is used, split id L
       cannot be used for DETAIL and S cannot be used for
       MONTHS.

As distributed, the Database Split Table is empty indicating
that all Information Area files are to be written to DETAIL,
DAYS, WEEKS, MONTHS, and YEARS DD names.  Figure 2-29 shows
the CA MICS Database Split Table for a database with the
DETAIL timespan split into three additional OS files and the
MONTHS timespan split into two additional OS files.  In
actual use, only the statements for Information Areas that
use some DD name other than the standard DETAIL, DAYS, WEEKS,
MONTHS, and YEARS would be required in the table, as shown in
Figure 2-30.
  +---------------------------------------------------------+
  | INFORMATION AREA   DDNAME LIST                          |
  +---------------------------------------------------------+
  |                                                         |
  |    ADM             DETAIL  DAYS WEEKS MONTHS  YEARS     |
  |    SCP             DETAIL1 DAYS WEEKS MONTHS  YEARS     |
  |    HAR             DETAIL  DAYS WEEKS MONTHS  YEARS     |
  |    BAT             DETAIL2 DAYS WEEKS MONTHS  YEARS     |
  |    TSO             DETAIL2 DAYS WEEKS MONTHS  YEARS     |
  |    CIC             DETAIL  DAYS WEEKS MONTHS2 YEARS     |
  |    IMS             DETAIL3 DAYS WEEKS MONTHS  YEARS     |
  |    OPS             DETAIL  DAYS WEEKS MONTHS  YEARS     |
  |    SRL             DETAIL3 DAYS WEEKS MONTHSB YEARS     |
  |    ACT             DETAIL  DAYS WEEKS MONTHS  YEARS     |
  |                                                         |
  |                                                         |
  +---------------------------------------------------------+

 Figure 2-29.  CA MICS Database Split Table Example 1

  +---------------------------------------------------------+
  | INFORMATION AREA   DDNAME LIST                          |
  +---------------------------------------------------------+
  |                                                         |
  |    BAT              DETAIL2 DAYS WEEKS MONTHSA YEARS    |
  |    TSO              DETAIL2 DAYS WEEKS MONTHS  YEARS    |
  |    CIC              DETAIL  DAYS WEEKS MONTHS9 YEARS    |
  |    IMS              DETAIL3 DAYS WEEKS MONTHS  YEARS    |
  |                                                         |
  +---------------------------------------------------------+

 Figure 2-30.  CA MICS Database Split Table Example 2

For the installation checklist for the DBSPLIT option, refer
to Section 3.8.5.