MICS database Split Table (DBSPLIT)
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.