7. PARAMETERS › 7.3 Unit-Level Parameters › 7.3.8 Database Space Modeling (DBMODEL) › 7.3.8.1 Data Retention Specifications (FILE Statements)
7.3.8.1 Data Retention Specifications (FILE Statements)
Data retention specifications tell the CA MICS database how
many cycles of each file, in each supported timespan, to save
both online and in archive mode. Figure 7-9 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. 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. The two definitions for the archive
database files quantify the number of cycles of data to be
retained, up to the cut-off 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 provides an underscored area for your
definition, followed by the default value in parentheses. If
the underscored area contains '00', the file is by default
not active in the indicated timespan. Though you can
activate files in these timespans (see the chapter entitled
Database Tailoring Facility in the System Modification
Guide), we recommend that you not do so due to the volume of
data generated.
When specifying a retention limit, keep in mind that the
number may never be less than 1 if the file has been defined
to be active in the timespan. See the chapter entitled
Database Tailoring Facility in the SMG.
EXAMPLE
The IMS Analyzer is comprised of one Information Area, IMS,
consisting of seven files.
FILE IMS IMSISY 10 33 53 18 02 00 001 001
FILE IMS IMSISU 00 02 00 06 02 00 000 001
FILE IMS IMS_IS 00 02 00 06 02 00 000 001
FILE IMS IMSIAU 00 02 00 06 00 00 000 001
FILE IMS IMS_IA 00 02 00 06 00 00 000 001
FILE IMS IMSIAC 00 10 00 18 02 00 000 001
FILE IMS IMSINC 33 00 00 00 00 00 000 000
+--------------------------------------------------------------------------+
| INSTALLATION PREPARATION WORKSHEET:Database Data Retention Definitions |
| |
| PARMS Library Member is DBMODEL |
| Reference Sections: 7.3.8.1 |
+------+-----------------------------------------------+-------------------+
| | Online Database Retention | Archive Cut-Off |
| File |DETAIL DAYS WEEKS MONTHS YEARS TABLES | WEEKS MONTHS |
| Name | __(NA) __(NA) __(NA) __(NA) _(NA) __(NA) |___ (NA) ___ (NA) |
+------+-----------------------------------------------+-------------------+
|IMSISY| __(10) __(33) __(09) __(06) _(1) 00(00) |___ (053) ___ (024)|
|IMSISU| 00(00) __(02) __(00) __(02) _(1) 00(00) |___ (000) ___ (024)|
|IMS_IS| 00(00) __(02) __(00) __(02) _(1) 00(00) |___ (000) ___ (024)|
|IMSIAU| 00(00) __(02) __(00) __(02) _(0) 00(00) |___ (000) ___ (024)|
|IMS_IA| 00(00) __(02) __(00) __(02) _(0) 00(00) |___ (000) ___ (024)|
|IMSIAC| 00(00) __(10) __(00) __(06) _(1) 00(00) |___ (000) ___ (024)|
|IMSINC| __(33) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)|
+------+-----------------------------------------------+-------------------+
| ....5...10...15...20...25...30...35...40...45...50...55...60...65...70.. |
+--------------------------------------------------------------------------+
Figure 7-9. Database Data Retention Worksheet
Copyright © 2014 CA.
All rights reserved.
|
|