Previous Topic: 7.3.5 Database Space Modeling (DBMODEL)Next Topic: 7.3.5.2 DBMODEL Input Statements


7.3.5.1 Data Retention Specifications (FILE Statement)


The System Reliability Analyzer contains one Information
Area, which has fourteen files.

The suggested retention period is specified within each of
the online and archive timespans.  If the specification is a
value of '00', the file is not supported for the indicated
timespan and the '00' value may not be changed unless the
user performs database tailoring in order to add support for
that particular file in that particular timespan.

EXAMPLE

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

   FILE SRL SRLSSM 01 33 09 06 00 00 053 024

NOTE:  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.

+--------------------------------------------------------------------------+ | INSTALLATION PREPARATION WORKSHEET: Database Data Retention Definitions | | | | PARMS Library Member is DBMODEL | | | | Reference Section: 7.3.5.2 | +------+-----------------------------------------------+-------------------+ | | Online Data Base Retention | Archive Cut-Off | | File |DETAIL DAYS WEEKS MONTHS YEARS TABLES | WEEKS MONTHS | | Name | __(NA) __(NA) __(NA) __(NA) _(NA) __(NA) |___ (NA) ___ (NA) | +------+-----------------------------------------------+-------------------+ |SRLSSD| __(10) __(00) __(00) __(00) _(0) 00(00) |___ (000) ___ (000)| |SRL_UD| __(02) __(00) __(00) __(00) _(0) 00(00) |___ (000) ___ (000)| |SRLSSM| __(01) __(33) __(27) __(06) _(0) 00(00) |___ (000) ___ (000)| |SRL_UM| __(01) __(08) __(12) __(03) _(0) 00(00) |___ (000) ___ (000)| |SRLRNC| __(10) __(00) __(00) __(00) _(0) 00(00) |___ (000) ___ (000)| |SRLPRL| __(10) __(33) __(27) __(12) _(0) 00(00) |___ (000) ___ (000)| |SRLSTR| __(10) __(33) __(27) __(12) _(0) 00(00) |___ (000) ___ (000)| |SRLCRL| __(10) __(33) __(12) __(06) _(0) 00(00) |___ (000) ___ (000)| |SRLDRL| __(10) __(33) __(12) __(06) _(0) 00(00) |___ (000) ___ (000)| |SRLMRL| __(10) __(33) __(12) __(06) _(0) 00(00) |___ (000) ___ (000)| |SRLXRL| __(10) __(33) __(12) __(06) _(0) 00(00) |___ (000) ___ (000)| |SRLTRL| __(10) __(33) __(12) __(06) _(0) 00(00) |___ (000) ___ (000)| |SRLDMR| __(10) __(33) __(12) __(06) _(0) 00(00) |___ (000) ___ (000)| |SRLMMR| __(10) __(33) __(12) __(06) _(0) 00(00) |___ (000) ___ (000)| +------+-----------------------------------------------+-------------------+ | ....5...10...15...20...25...30...35...40...45...50...55...60...65...70.. | +--------------------------------------------------------------------------+


 Figure 7-6.  Database Data Retention Worksheet