Previous Topic: 7.3.2 Database Space Modeling (DBMODEL)

Next Topic: 7.3.2.2 DBMODEL Input Statements

7.3.2.1 Data Retention Specifications (FILE Statement)

The unit level prefix.MICS.PARM(DBMODEL) 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 for each database unit.  Figures 7-3a and
7-3b are the worksheets for collecting this information.

For each file, the worksheet lists the default cycle
retention period in parentheses for each timespan (DETAIL,
DAYS, WEEKS, MONTHS, YEARS, and the TABLES area).

If '00' shows as the retention value for the timespan, the
file is not supported in that timespan.   See the RMFGENIN
FILE statement discussion in Section 7.2 for more information
about files that are not supported in the DETAIL timespan.

You must specify a cycle retention limit greater than zero if
a file has been defined in its RMFGENIN FILE statement to be
active in the timespan.   Likewise, you must specify a cycle
retention limit of 0 if a file has been defined in its
RMFGENIN FILE statement to be inactive in the timespan.

Note that a file is turned on or off in a particular
timespan on a complex-wide level through the RMFGENIN FILE
statement definitions; you customize the cycle retention
values on a unit level basis through the
prefix.MICS.PARM(DBMODEL) parameter.

EXAMPLE

The prefix.MICS.PARMS(DBMODEL) FILE statement below
illustrates how to enter the information for a file whose
RMFGENIN FILE statement specifies that the file is inactive
in the YEARS timespan and TABLES data area.

   FILE RMF HARCPU 01 33 09 06 00 00 053 024

Note:  The archive definitions have no impact on the size of
the database and can be specified whether or not the weekly
and/or monthly archive history files have actually been
activated.

+--------------------------------------------------------------------------+ | INSTALLATION PREPARATION WORKSHEET: Database Data Retention Definitions | | | | PARMS Library Member is DBMODEL | | | | Reference: Section 7.3.2.1, CA MICS Hardware and SCP Analyzer Guide | +------+-----------------------------------------------+-------------------+ | | Online Database Retention | Archive Cut-Off | | File |DETAIL DAYS WEEKS MONTHS YEARS TABLES | WEEKS MONTHS | | Name | __( ) __( ) __( ) __( ) _( ) __( )|___ ( ) ___ ( )| +------+-----------------------------------------------+-------------------+ |HARCCU| __(01) __(08) __(04) __(06) _(0) 00(00) |___ (027) ___ (024)| |HARCFC| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCFD| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCFH| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCFP| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCFR| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCFS| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCPU| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCRA| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCRF| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCRP| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARCVA| __(01) __(08) __(04) __(06) _(0) 00(00) |___ (027) ___ (024)| |HARDTA| 00(00) __(01) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARDVA| __(01) __(08) __(04) __(00) _(0) 00(00) |___ (027) ___ (000)| |HARELS| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARERS| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARFDC| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARFDP| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARIPU| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARLPC| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARPCA| __(01) __(15) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARPHY| 00(00) __(01) __(01) __(01) _(0) 00(00) |___ (000) ___ (000)| |HARRRA| __(01) __(08) __(04) __(06) _(0) 00(00) |___ (027) ___ (024)| |HARRSV| __(02) __(00) __(00) __(00) _(0) 00(00) |___ (000) ___ (000)| |HARSGA| 00(00) __(01) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARVPA| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |HARXPS| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPARD| __(02) __(00) __(00) __(00) _(0) 00(00) |___ (000) ___ (000)| |SCPENQ| __(01) __(08) __(04) __(00) _(0) 00(00) |___ (027) ___ (000)| |SCPIOC| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPIOP| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPKRN| __(08) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPLCA| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPLCU| 00(00) __(15) __(09) __(06) _(0) 00(00) |___ (053) ___ (000)| |SCPPAG| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| +------+-----------------------------------------------+-------------------+


Figure 7-3a. Data Retention Specifications Worksheet (Part 1 of 2)

+--------------------------------------------------------------------------+ | INSTALLATION PREPARATION WORKSHEET: Database Data Retention Definitions | | | | PARMS Library Member is DBMODEL | | | | Reference: Section 7.3.2.1, CA MICS Hardware and SCP Analyzer Guide | +------+-----------------------------------------------+-------------------+ | | Online Database Retention | Archive Cut-Off | | File |DETAIL DAYS WEEKS MONTHS YEARS TABLES | WEEKS MONTHS | | Name | __( ) __( ) __( ) __( ) _( ) __( )|___ ( ) ___ ( )| +------+-----------------------------------------------+-------------------+ |SCPPSD| __(01) __(08) __(04) __(00) _(0) 00(00) |___ (027) ___ (000)| |SCPSRC| __(02) __(00) __(00) __(00) _(0) 00(00) |___ (000) ___ (000)| |SCPSWP| __(01) __(33) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPTRC| __(02) __(00) __(00) __(00) _(0) 00(00) |___ (000) ___ (000)| |SCPVSM| __(07) __(30) __(06) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPVSU| __(07) __(30) __(06) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPXCA| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPXCM| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |SCPXCY| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLM_EA| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLM_EC| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLM_ED| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLM_EM| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLM_EW| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLMRGP| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLMSDE| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLMSDS| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLMSEA| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLMSEC| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLMSED| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLMSEM| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| |WLMSVC| __(01) __(10) __(09) __(06) _(0) 00(00) |___ (053) ___ (024)| +------+-----------------------------------------------+-------------------+


Figure 7-3b. Data Retention Specifications Worksheet (Part 2 of 2)