MICS database
Split Table (DBSPLIT)

The
MICS
Online Database is composed of five timespans: DETAIL, DAYS, WEEKS, MONTHS, and YEARS.
MICS
allows the files that are associated with each timespan to be spread across one to 37 OS files. This table is used to specify which
MICS
Information Areas (a logical grouping of component files) are in which OS files.
micsrm140cd
The
MICS
Online Database is composed of five timespans: DETAIL, DAYS, WEEKS, MONTHS, and YEARS.
MICS
allows the files that are associated with each timespan to be spread across one to 37 OS files. This table is used to specify which
MICS
Information Areas (a logical grouping of component files) are in which OS files.
The
MICS database
Split Table consists of several statements in a 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 (for example, ADM, TSO, SCP). The other fields are the DD names where the Information Area files are written. The possible DD names are:
  • DETAIL, DETAILs
  • DAYS, DAYSs  
  • WEEKS, WEEKSs
  • MONTHS, MONTHSs
  • YEARS, YEARSs
where s is the split ID 0-9-Z 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 written to DETAIL, DAYS, WEEKS, MONTHS, and YEARS DD names.
MICS database
Split Table Example 1 shows the
MICS database
Split Table for a database with the DETAIL timespan split into three more OS files and the MONTHS timespan split into two more 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
MICS database
Split Table Example 2.
MICS database
Split Table Example 1
  +---------------------------------------------------------+   | 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     |   |                                                         |   |                                                         |   +---------------------------------------------------------+
MICS database
Split Table Example 2
  +---------------------------------------------------------+   | 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    |   |                                                         |   +---------------------------------------------------------+
For the installation checklist for the DBSPLIT option, see Split an Existing Database Unit.