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-10 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 is 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 can be specified
whethert 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, 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.
FILE SMF BAT_JS 01 00 00 00 00 00 000 000
FILE SMF BAT_OE 10 00 00 02 00 00 000 024
FILE SMF BAT_SA 10 00 00 02 00 00 000 024
FILE SMF BAT_ST 10 00 00 02 00 00 000 024
FILE SMF BAT_TP 10 00 00 02 00 00 000 024
FILE SMF BAT_TS 10 00 00 02 00 00 000 024
FILE SMF BATATP 10 00 00 02 00 00 000 024
FILE SMF BATJOB 10 00 00 06 01 00 000 024
FILE SMF BATMUA 10 00 00 02 00 00 000 024
FILE SMF BATMUG 10 30 00 06 00 00 000 024
FILE SMF BATOEP 10 00 00 00 00 00 000 000
FILE SMF BATPGM 10 00 00 02 00 00 000 006
FILE SMF BATREN 10 00 00 02 00 00 000 024
FILE SMF BATSFH 01 00 00 00 00 00 000 000
FILE SMF BATSPL 10 00 00 06 01 00 000 024
FILE SMF BATWDA 00 01 00 00 00 00 000 000
FILE SMF OPSAVL 01 00 00 00 00 00 000 000
FILE SMF OPSCON 01 00 00 00 00 00 000 000
FILE SMF OPSCTF 00 00 00 00 00 01 000 000
FILE SMF OPSOPI 01 00 00 00 00 00 000 000
Note: In all units, the BAT_JS, OPSOPI, OPSCON, OPSAVL, and
OPSCTF files must be specified exactly as shown above.
+--------------------------------------------------------------------------+ | INSTALLATION PREPARATION WORKSHEET: Database Data Retention Definitions | | | | PARMS Library Member is DBMODEL | | | |Reference: Section 7.3.7.1 CA MICS Batch and Operations Analyzer Guide | +------+-----------------------------------------------+-------------------+ | | Online Database Retention | Archive Cutoff | | File |DETAIL DAYS WEEKS MONTHS YEARS TABLES | WEEKS MONTHS | | Name | | | +------+-----------------------------------------------+-------------------+ |BATJOB| __(10) __(00) __(00) __(06) _(1) 00(00) |___ (000) ___ (024)| |BAT_JS| 01(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |BATPGM| __(10) __(00) __(00) __(02) _(0) 00(00) |___ (000) ___ (006)| |BAT_TS| __(10) __(00) __(00) __(02) _(0) 00(00) |___ (000) ___ (006)| |BAT_OE| __(10) __(00) __(00) __(02) _(0) 00(00) |___ (000) ___ (006)| |BAT_TP| __(10) __(00) __(00) __(02) _(0) 00(00) |___ (000) ___ (006)| |BAT_SA| __(10) __(00) __(00) __(02) _(0) 00(00) |___ (000) ___ (006)| |BAT_ST| __(10) __(00) __(00) __(02) _(0) 00(00) |___ (000) ___ (006)| |BATOEP| __(10) __(00) __(00) __(02) _(0) 00(00) |___ (000) ___ (006)| |BATREN| __(10) __(00) __(00) __(02) _(0) 00(00) |___ (000) ___ (006)| |BATATP| __(10) __(00) __(00) __(06) _(1) 00(00) |___ (000) ___ (024)| |BATSPL| __(10) __(00) __(00) __(06) _(1) 00(00) |___ (000) ___ (024)| |BATWDA| 00(00) __(01) __(00) __(00) _(0) 00(00) |___ (000) ___ (000)| |BATMUG| __(10) __(90) __(00) __(12) _(0) 00(00) |___ (000) ___ (000)| |BATMUA| __(10) __(30) __(00) __(12) _(0) 00(00) |___ (000) ___ (000)| +------+-----------------------------------------------+-------------------+ |OPSOPI| 01(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |OPSCON| 01(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |OPSAVL| 01(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |OPSCTF| 00(00) 00(00) 00(00) 00(00) 0(0) 01(01) |000 (000) 000 (000)| +------+-----------------------------------------------+-------------------+
Figure 7-10. Data Retention Specifications Worksheet
|
Copyright © 2014 CA.
All rights reserved.
|
|