7. DEFINING PARAMETERS › 7.3 Unit Level Parameters › 7.3.4 Database Space Modeling (DBMODEL) › 7.3.4.1 Data Retention Specifications (FILE Statements)
7.3.4.1 Data Retention Specifications (FILE Statements)
Figure 7-6 provides a worksheet to define the different
retention limits for the online and archive data base files.
The numbers shown on the worksheet reflect the default
retention values in prefix.MICS.PARMS(DBMODEL).
Use the worksheet to define your retention specifications,
which, in turn, will allow you to determine the appropriate
values for the modeling process.
Note that the DBMODEL worksheet shown here contains values
for this product only. See Section 2.3.4.1, Preparing the
Modeling Input, in the PIOM for additional information.
The worksheet is organized by information area. Each file in
the area is listed by name. For each file, a line is
formatted to allow six definitions in the online database and
two in the archive database:
o The online database files quantify the number of cycles of
data that will be maintained in the DETAIL, DAYS, WEEKS,
MONTHS, and YEARS timespans and the TABLES data area.
o The two definitions for the archive database files quantify
the number of cycles of data to be retained, up to the
cutoff limit defined. The archive definitions have no
impact on the size of the database and may be specified
whether or not the weekly and/or monthly archive history
files have actually been activated (see Section 2.3.3,
CA MICS JCL Planning and Parameters, of the PIOM).
The worksheet formats provide an underscored area for the
user's definition, followed by the recommended value, shown
within parentheses. If the underscored area contains a value
of 00, the file is not supported for the indicated timespan.
To add support, you must perform database tailoring as
described in Section 6.2, Tailoring the Database, of the
System Modification Guide (SMG).
When specifying a retention limit, remember that the number
may never be zero if the file has been defined to be active
in the timespan.
+--------------------------------------------------------------------------+
| INSTALLATION PREPARATION WORKSHEET: Database Data Retention Definitions |
| |
| PARMS Library Member is DBMODEL |
| Reference Sections: 7.3.4.2 |
+------+-----------------------------------------------+-------------------+
| | Online Database Retention | Archive Cut-Off |
| File |DETAIL DAYS WEEKS MONTHS YEARS TABLES | WEEKS MONTHS |
| Name | __(NA) __(NA) __(NA) __(NA) _(NA) __(NA) |___ (NA) ___ (NA) |
+------+-----------------------------------------------+-------------------+
|DEAPRC| __(10) __(00) __(00) __(13) _(05) 00(00) |___ (000) ___ (036)|
|DEAIMG| __(10) __(00) __(00) __(06) _(00) 00(00) |___ (000) ___ (036)|
|DEAINT| __(10) __(00) __(00) __(00) _(00) 00(00) |___ (000) ___ (000)|
|DEA_LF| __(10) __(00) __(00) __(13) _(05) 00(00) |___ (000) ___ (036)|
|DEAPRQ| __(10) __(00) __(00) __(13) _(05) 00(00) |___ (000) ___ (036)|
+------+-----------------------------------------------+-------------------+
|DEMPRO| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMMOD| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMDSK| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMSCS| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMRMS| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMSPR| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
+------+-----------------------------------------------+-------------------+
|DESDKD| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DESDKQ| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DESDKU| __(02) __(02) __(00) __(13) _(05) 00(00) |___ (000) ___ (036)|
|DESPRX| __(01) __(07) __(13) __(13) _(03) 00(00) |___ (053) ___ (036)|
|DESSYU| __(01) __(14) __(53) __(24) _(00) 00(00) |___ (053) ___ (036)|
+------+-----------------------------------------------+-------------------+
| ....5...10...15...20...25...30...35...40...45...50...55...60...65...70.. |
+--------------------------------------------------------------------------+
+--------------------------------------------------------------------------+
| INSTALLATION PREPARATION WORKSHEET: Database Data Retention Definitions |
| |
| PARMS Library Member is DBMODEL |
| Reference Sections: 7.3.4.2 |
+------+-----------------------------------------------+-------------------+
| | Online Database Retention | Archive Cut-Off |
| File |DETAIL DAYS WEEKS MONTHS YEARS TABLES | WEEKS MONTHS |
| Name | __(NA) __(NA) __(NA) __(NA) _(NA) __(NA) |___ (NA) ___ (NA) |
+------+-----------------------------------------------+-------------------+
|DEAPRC| __(10) __(00) __(00) __(13) _(05) 00(00) |___ (000) ___ (036)|
|DEAIMG| __(10) __(00) __(00) __(06) _(00) 00(00) |___ (000) ___ (036)|
|DEAINT| __(10) __(00) __(00) __(00) _(00) 00(00) |___ (000) ___ (000)|
|DEA_LF| __(10) __(00) __(00) __(13) _(05) 00(00) |___ (000) ___ (036)|
|DEAPRQ| __(10) __(00) __(00) __(13) _(05) 00(00) |___ (000) ___ (036)|
+------+-----------------------------------------------+-------------------+
|DEMPRO| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMMOD| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMDSK| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMSCS| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMRMS| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DEMSPR| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
+------+-----------------------------------------------+-------------------+
|DESDKD| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DESDKQ| __(01) __(07) __(13) __(13) _(00) 00(00) |___ (053) ___ (036)|
|DESDKU| __(02) __(02) __(00) __(13) _(05) 00(00) |___ (000) ___ (036)|
|DESPRX| __(01) __(07) __(13) __(13) _(03) 00(00) |___ (053) ___ (036)|
|DESSYU| __(01) __(14) __(53) __(24) _(00) 00(00) |___ (053) ___ (036)|
+------+-----------------------------------------------+-------------------+
| ....5...10...15...20...25...30...35...40...45...50...55...60...65...70.. |
+--------------------------------------------------------------------------+
