2. INSTALLATION › 2.4 Database Space Modeling (DBMODEL) › 2.4.1 Data Retention Specifications (FILE Statements)

2.4.1 Data Retention Specifications (FILE Statements)

Data retention specifications tell the CA MICS database how
many cycles of each file to save, in each supported timespan,
both online and in archive mode.  Figure 2-1 is the worksheet
for collecting this 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.

EXAMPLE

The FILE statements listed below illustrate how to enter the
information.  The Accounting and Chargeback journal files,
ACTJxx, and the audit files, ACTAUDIT, are not part of the
normal retention of CA MICS.  They are described in Chapter 7
of this guide.

FILE ACT  ACTLGR 00 02 00 03 02 00 000 000
FILE ACT  ACTRCP 00 00 00 00 00 18 000 000
FILE ACT  ACTSCT 00 00 00 00 00 06 000 000
FILE ACT  ACTSDT 00 00 00 00 00 06 000 000
FILE ACT  ACTBGT 00 00 00 00 00 02 000 000
FILE ACT  ACTCCA 00 00 00 00 00 01 000 000
FILE ACT  ACTSEQ 00 00 00 00 00 01 000 000
FILE ACT  ACT_YR 00 00 00 00 00 01 000 000
FILE ACT  ACT_RC 00 00 00 00 00 01 000 000
FILE ACT  ACT_YT 00 00 00 00 00 01 000 000
FILE ACT  ACT_SC 00 00 00 00 00 01 000 000
FILE ACT  ACT_CA 00 00 00 00 00 01 000 000

WARNING!  Do NOT change the retention specifications given as
          zero.

+--------------------------------------------------------------------------+
| INSTALLATION PREPARATION WORKSHEET: Database Data Retention Definitions  |
|                                                                          |
| PARMS Library Member is DBMODEL                                          |
|                                                                          |
| Reference Sections:  2.4.1                                               |
+------+-----------------------------------------------+-------------------+
|      |           Online Database Retention           |  Archive Cutoff   |
| File |DETAIL    DAYS   WEEKS   MONTHS  YEARS  TABLES | WEEKS    MONTHS   |
| Name | __(NA)  __(NA)  __(NA)  __(NA)  _(NA)  __(NA) |___ (NA)  ___ (NA) |
+------+-----------------------------------------------+-------------------+
|ACTLGR| 00(00)  __(02)  00(00)  __(03)  _(2)   00(00) |___ (000) ___ (000)|
|ACTRCP| 00(00)  00(00)  00(00)  00(00)  0(0)   __(18) |000 (000) 000 (000)|
|ACTSCT| 00(00)  00(00)  00(00)  00(00)  0(0)   __(03) |000 (000) 000 (000)|
|ACTSDT| 00(00)  00(00)  00(00)  00(00)  0(0)   __(03) |000 (000) 000 (000)|
|ACTBGT| 00(00)  00(00)  00(00)  00(00)  0(0)   __(02) |000 (000) 000 (000)|
|ACTCCA| 00(00)  00(00)  00(00)  00(00)  0(0)   01(01) |000 (000) 000 (000)|
|ACTSEQ| 00(00)  00(00)  00(00)  00(00)  0(0)   01(01) |000 (000) 000 (000)|
|ACT_YR| 00(00)  00(00)  00(00)  00(00)  0(0)   01(01) |000 (000) 000 (000)|
|ACT_RC| 00(00)  00(00)  00(00)  00(00)  0(0)   01(01) |000 (000) 000 (000)|
|ACT_YT| 00(00)  00(00)  00(00)  00(00)  0(0)   01(01) |000 (000) 000 (000)|
|ACT_SC| 00(00)  00(00)  00(00)  00(00)  0(0)   01(01) |000 (000) 000 (000)|
|ACT_CA| 00(00)  00(00)  00(00)  00(00)  0(0)   01(01) |000 (000) 000 (000)|
+------+-----------------------------------------------+-------------------+
| ....5...10...15...20...25...30...35...40...45...50...55...60...65...70.. |
+--------------------------------------------------------------------------+

 Figure 2-1.  Data Retention Specifications Worksheet