Command ===>
---------- Component ESSENTIAL and DERIVED Options Report ----------- Product: ===> ___
. . . . . . . . . . . . . . . . . . . . . . . . . .
The Component ESSENTIAL and DERIVED Options Report provides a
listing of your complex and component level ESSENTIAL and
DERIVED options, as well as the options that are in effect
for each file for the selected component. These options can
be tailored to exclude groups of data elements as a means of
controlling the size of your database.
NOTE: This report is not supported for the CA MICS
Accounting and Chargeback Option (ACT). The ACT
component forces all accounting related files to
ESSENTIAL ALL and DERIVED DISK, regardless of customer
settings.
The report shows the ESSENTIAL and DERIVED database options:
o The complex level options apply to all components in the
database complex and are set in
sharedprefix.MICS.PARMS(CPLXDEF). The complex options can
be overridden by using component level options.
o The component level options apply only to a component and
are set in sharedprefix.MICS.GENLIB(cccGENIN). The COMPOPT
statement defines the ESSENTIAL and DERIVED data element
options for a component. The component options can be
overridden by using file level options.
o The file level options apply to a file within a component
and are set in sharedprefix.MICS.GENLIB(cccGENIN) by using
the FOPT statement.
Refer to Chapter 2 of the CA MICS Planning, Installation,
Operation and Maintenance Guide for more information on
complex level database options and Chapter 4 of the CA MICS
System Modification Guide for the component and file level
options.
To produce the Component ESSENTIAL and DERIVED Options
Report, choose option 3 from the CA MICS Administrator
Utilities menu (MWF 5;4;3).
Fill in a value, as described below, and press END or use the
PF3 key to submit the inquiry.
Product Required, no default. Enter one of
the following three-character (ccc)
component identifiers.
AUM AST BAS CIC DB2 DEX HSM
IDM IMS MQS MTI PWR RMF SMF
SNT SRL TDM TSO VCA VMC WEB
A sample report listing for the Component ESSENTIAL and
DERIVED Options Report follows.
In the following example, the Component ESSENTIAL and DERIVED Options Report provides a listing of the complex, component, and file level options that are in effect for the DB2 Analyzer.
+---------------------------------------------------------------------------------------------------------------------------------+ Component ESSENTIAL and DERIVED Options Report Page 1 CA MICS Component: DB2 Last Generated: Wed, Dec 10, 2003 at 7:32:28 +---------------------------------------------------------------------------------------------------------------------------------+ +----------------------------------+ +-----------------------------+ +-----------------------------+ | Area: DBP - DB2 Buffer Pool Area | | ESSENTIAL OPTION | | DERIVED OPTION | +----------------------------------+ +-----------------------------+ +-----------------------------+ In In File File Label Effect FOPT COMPOPT CPLXDEF Effect FOPT COMPOPT CPLXDEF ------ ------------------------------------------------- ------- ------- ------- ------- ------- ------- ------- ------- DBP_DB DB2 Buffer Pool SuSpend ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DBPDBP DB2 Plan Buffer Pool Activity ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DBPDBU DB2 User Buffer Pool Activity ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DBPDSB DB2 Buffer Pool Activity ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK +----------------------------------+ +-----------------------------+ +-----------------------------+ | Area: DB2 - DB2 Information Area | | ESSENTIAL OPTION | | DERIVED OPTION | +----------------------------------+ +-----------------------------+ +-----------------------------+ In In File File Label Effect FOPT COMPOPT CPLXDEF Effect FOPT COMPOPT CPLXDEF ------ ------------------------------------------------- ------- ------- ------- ------- ------- ------- ------- ------- DB2_DD DB2 Data Base Activity Suspend File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2_DS DB2 System Activity Suspend File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2_SH DB2 System DDF Suspend File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2DDP DB2 Plan DDF Activity File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2DDU DB2 User DDF Activity File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2DDY DB2 System DDF Statistics File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2DPP DB2 Package/DBRM Activity File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2DSD DB2 Data Base Activity File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2DSP DB2 Plan Activity File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2DSU DB2 User Activity File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK DB2DSY DB2 System Activity File ALL DEFAULT DEFAULT ALL DISK DEFAULT DEFAULT DISK +---------------------------------------------------------------------------------------------------------------------------------+
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |