|
|
|
This section describes cycle (data retention) definitions that are required, discusses how to determine the data cycles required, and provides instructions for completing the FILE statements in the PARMS member DBMODEL. DATABASE DATA RETENTION WORKSHEET DEFINITION Figure 7-6 provides a worksheet to define the different retention limits for the online and archive database files. The numbers shown on the worksheet reflect the default retention values in prefix.MICS.PARMS(DBMODEL). Use the worksheet to define your retention specifications, which in turn will allow you to determine the appropriate values for the modeling process. Note that the DBMODEL worksheet shown here contains values for this product only. For more information, see Section 2.3.3.2.1.5 in the PIOM. 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. VM COMPONENT DATA RETENTION DEFINITION The CA MICS Analyzer Option for VM/CMS contains the VMC and VMX Information Areas. The FILE statements shown below specify the default online and archive history retention limits for each of these files in t@fi-archese information areas. A complete description of the FILE statement is provided in section 2.3.4.1, Preparing the Modeling Input, in the PIOM.
+--------------------------------------------------------------------------+ | INSTALLATION PREPARATION WORKSHEET: Database Data Retention Definitions | | | | PARMS Library Member is DBMODEL | | | | Reference Sections: 7.2.3.1 | +------+-----------------------------------------------+-------------------+ | | Online Database Retention | Archive Cut-Off | | File |DETAIL DAYS WEEKS MONTHS YEARS TABLES | WEEKS MONTHS | | Name | | | +------+-----------------------------------------------+-------------------+ |VMCVXC| __(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMCCMU| __(10) 00(00) 00(00) __(13) __(2) 00(00) |___ (001) ___ (001)| |VMCDAC| __(10) 00(00) 00(00) __(13) __(2) 00(00) |___ (001) ___ (001)| |VMCVRA| __(10) 00(00) 00(00) __(13) __(2) 00(00) |___ (001) ___ (001)| |VMCNTU| __(10) 00(00) 00(00) __(13) __(2) 00(00) |___ (001) ___ (001)| |VMCNDT| __(10) 00(00) 00(00) __(13) __(2) 00(00) |___ (001) ___ (001)| +------+-----------------------------------------------+-------------------+ |VMXSCF| __(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXPCF| __(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXSGP| __(10) __(10) __(02) __(01) __(0) 00(00) |___ (001) ___ (001)| |VMXSPP| __(03) __(01) __(01) __(01) __(0) 00(00) |___ (001) ___ (001)| |VMXDCF| __(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXXDV| __(01) __(01) 00(00) __(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXXDS| __(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXACF| __(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXCPV| __(03) __(01) __(01) __(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXVXF| __(01) 00(00) 00(00) __(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXVXU| __(01) __(01) 00(00) __(01) 0(0) 00(00) |000 (000) 000 (000)| |VMX_VU| __(01) __(01) 00(00) __(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXVXT| __(01) __(01) 00(00) __(01) 0(0) 00(00) |000 (000) 000 (000)| |VMX_VT| __(01) __(01) 00(00) __(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXCHC| __(03) 00(00) __(01) __(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXBPG| __(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXXSS| __(01) 00(00) 00(00) __(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXXSF| __(01) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXSTP| __(03) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXCDI| __(03) 00(01) 00(00) 00(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXCDP| __(03) 00(01) 00(00) 00(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXLPR| __(03) 00(01) 00(00) 00(01) 0(0) 00(00) |000 (000) 000 (000)| |VMXLCP| __(03) 00(00) 00(00) 00(00) 0(0) 00(00) |000 (000) 000 (000)| |VMXSCX| __(01) 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-6. Database Data Retention Worksheet
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |