|
|
|
Command ===>
----------------------- Database Modification Report ---------------- Product: ===> ___ Report Selection: Y - Generate Report N - Suppress Report ===> _ Product Maintenance Blocks ===> _ Product User Maintenance Blocks/Comments ===> _ Product Global Statement Modifications ===> _ Product Common Data Element Modifications ===> _ Product File Level Modifications ===> _ Include Data Element Timespan Changes ===> _ Complex ($DEGENIN) Common Data Element Modifications NOTE: The $DEGENIN report is the only report that does not require a specified product.
. . . . . . . . . . . . . . . . . . . . . . . . . .
Note: The Database Modification Report generation requires
significant temporary WORK and SORT space. If you receive SAS
errors due to SORT failure or out-of-space conditions,
increase the following MICF resource specifications. From the
CA MICS Workstation Facility (MWF) main menu, select:
2;0;6 - Data Set Allocation Parameters
Increase space for the SORTWK and WORK parameters
2;0;3 - MICF Parameter Update
Increase the Sort Work parameter value to 6
The Database Modification Report provides a comprehensive
list of user modifications that were made to the CA MICS
database. The Database Modification Report is comprised of
six reports that can be run individually or in combination
with each other. These reports generate listings of
additions, deletions, exceptions, and modifications to the
database at the product (reports 1 thru 5) and complex levels
(report C).
To produce the Database Modification Report, choose option 4
from the CA MICS Administrator Utilities menu (MWF 5;4;4).
Enter the following options as described below and type END
or press the PF3 key to begin report generation.
Product Required for all reports except the
Complex ($DEGENIN) Common Data
Element Modifications Report, no
default. Enter one of the
following three-character (ccc)
component identifiers.
ACT AUM AST BAS CIC DB2
DEX HSM IDM IMS MQS MTI
PWR RMF SMF SNT SRL TDM
TSO VCA VMC WEB
Product Maintenance Required, no default. Enter Y
Blocks (yes) to include product
maintenance block modifications in
the report. Enter N (no) to
exclude product maintenance block
modifications from the report.
Product User Maintenance Required, no default. Enter Y
Blocks/Comments (yes) to include product user
maintenance block/comment
modifications in the report.
Enter N (no) to exclude product
user maintenance block/comment
modifications from the report.
Product Global Statement Required, no default. Enter Y
Modifications (yes) to include product global
statement modifications in the
report. Enter N (no) to exclude
product global statement
modifications from the report.
Product Common Data Required, no default. Enter Y
Element Modifications (yes) to include product common
data element modifications in the
report. Enter N (no) to exclude
product common data element
modifications from the report.
Product File Level Required, no default. Enter Y
Modifications (yes) to include product file level
modifications in the report. Enter
N (no) to exclude product file
level modifications from the
report.
Include Data Element Required, no default. Enter Y
Timespan Changes (yes) to include data element
timespan changes in the report.
Enter N (no) to exclude data
element timespan changes from the
report.
Note: This option is valid only
when the Product File Level
Modifications option is selected.
Complex ($DEGENIN) Required, no default. Enter Y
Common Data Element (yes) to include complex common
Modifications data element modifications in the
report. Enter N (no) to exclude
complex common data element
modifications from the report.
A sample report listing for the Database Modification Report
follows.
The Product Maintenance Blocks Report provides a listing of the maintenance blocks for changes that affect database content and structure, which are changes made to sharedprefix.MICS.GENLIB(cccGENIN). In the following example, the report shows the product maintenance blocks for the MQSeries Analyzer. +---------------------------------------------------------------------------------------------------------------------------------+ D A T A B A S E M O D I F I C A T I O N R E P O R T Page 1 CA MICS Component: MQS Report: REPORT 1 - Product Maintenance Blocks MQS Last Generated: Mon, Jan 5, 2004 at 14:12:40 +---------------------------------------------------------------------------------------------------------------------------------+ */* CHANGE | PROBLEM|MMYY|VENDOR CHANGE DESCRIPTION */ 00003000 */*--------+--------+----+------------------------------------------*/ 00004000 */*--------+--------+----+------------------------------------------*/ 00005000 */* MQS0000| |1297|CA MICS MQSeries Initial Release */ 00006000 */* MQS6005| |0498|Consolidated Maintenance */ 00006005 */* MQS6080| |1001|Support for MQSeries V5R2 */ 00006080 */* MQS6150| |1002|Supp of MQS Task Acct, Queue, CF, & Maint */ 00006150 */* MQS6350| |0403|Supp for DB2, Report Enhancemnts, & Maint */ 00006350 */* MQS6370| |1003| Report Enhancements & Consolidated Maint */ 00006370 */*--------+----+---------------------------------------------------*/ 00007000 +---------------------------------------------------------------------------------------------------------------------------------+
The Product User Maintenance Blocks/Comments Report provides a listing of the maintenance blocks and comments added by a user. In the following example, the report shows a maintenance block entered by a user to record the addition of new data elements to the Task Accounting File for the MQSeries Analyzer. +---------------------------------------------------------------------------------------------------------------------------------+ D A T A B A S E M O D I F I C A T I O N R E P O R T Page 1 CA MICS Component: MQS Report: REPORT 2 - User Maintenance Blocks/Comments MQS Last Generated: Mon, Jan 5, yyyy at 14:12:40 +---------------------------------------------------------------------------------------------------------------------------------+ */* | |1103| New Data Elements Added to Task Accounting*/ 00009100 +---------------------------------------------------------------------------------------------------------------------------------+
The Product Global Statement Modifications Report provides a listing of the changes made to the COMP, COMPJOB, COMPOPT, DBMDATA, GEN, INPUTSOURCE, and OPTION global statements for a component. In the following example, the report shows that a change was made to remove SMF type 116 records from the INPUTSOURCE statement for the MQSeries Analyzer. +---------------------------------------------------------------------------------------------------------------------------------+ D A T A B A S E M O D I F I C A T I O N R E P O R T Page 1 CA MICS Component: MQS Report: REPORT 3 - Product Global Statement Modifications MQS Last Generated: Mon, Jan 5, yyyy at 14:12:40 +---------------------------------------------------------------------------------------------------------------------------------+ Statement Sequence Type Statement Value Number ------------ ------------------------------------------------------------ -------- COMP Master: MQS 051 32000 VBS ACCT MQS Component 00013000 User: MQS 051 32000 VBS ACCT MQS Component <-No Change 00013000 COMPJOB Master: DWMY EDWM AWM 00016000 User: DWMY EDWM AWM <-No Change 00016000 COMPOPT Master: DEFAULT DEFAULT 00014000 User: DEFAULT DEFAULT <-No Change 00014000 DBMDATA1 Master: 30 1440 5 50 6 00017000 User: 30 1440 5 50 6 <-No Change 00017000 GEN Master: GENFILES 00012000 User: GENFILES <-No Change 00012000 INPUTSOURCE1 Master: SMF 115 116 00015000 User: SMF 116 <-Modified 00015000 OPTION Master: 00018000 User: <-No Change 00018000 +---------------------------------------------------------------------------------------------------------------------------------+
The Product Common Data Element Modifications Report provides a listing of the changes made to common data elements for a component. Common data elements are present in multiple files within a component. In the following example, the report shows that the label for data element MQSATYP has been changed for the MQSeries Analyzer. +---------------------------------------------------------------------------------------------------------------------------------+ D A T A B A S E M O D I F I C A T I O N R E P O R T Page 1 CA MICS Component: MQS Report: REPORT 4 - Product Common Data Element Modifications MQS Last Generated: Mon, Jan 5, yyyy at 14:12:40 +---------------------------------------------------------------------------------------------------------------------------------+ +--------------------------------------------+ | MQS Common File Data Element MODIFICATIONS | +--------------------------------------------+ Element Label -------- --------------------------------------- MQSATYP MQ Type of Connection Modified Modification Seq Number Source ------------ ------------------------------------------------------------- ---------- -------- LABEL Master: Type Of Connection 00020610 MQSGENIN User: MQ Type of Connection 00020610 MQSGENIN +---------------------------------------------------------------------------------------------------------------------------------+
The Product File Level Modifications Report provides a listing of the changes made to file options and data element attributes for all of the files in a component. In the following example, a partial report is shown for the MQSeries Analyzer. The data element modification sections of the report show that the label for the common data element MQSATYP has been changed in the Message Manager Accounting (MQAMMA) file and in the Queue Activity (MQAQAA) file. For the MQAQAA file, the overview section of the report shows that the Detail timespan has been turned on (Y) and the cycles have been changed to 03. Because the "Include Data Element Timespan Changes" option was selected, the modification section of the report shows that QAABUFFP has been turned off (N) in the Days, Weeks, Months, and Year timespans. +---------------------------------------------------------------------------------------------------------------------------------+ D A T A B A S E M O D I F I C A T I O N R E P O R T Page 1 CA MICS Component: MQS Report: REPORT 5 - Product File Level Modifications MQS Last Generated: Mon, Jan 5, yyyy at 14:12:40 +---------------------------------------------------------------------------------------------------------------------------------+ AREA: MQA MQS Accounting Information Area FILE: MQAMMA Message Manager Accounting File +----------------------+ | MQAMMA FILE OVERVIEW | +----------------------+ DET DAY WKS MON YRS AUD WHS MHS --- --- --- --- --- --- --- --- Timespans Master: Y Y Y Y N N Y Y User: Y Y Y Y N N Y Y <-No Change CYCLES Master: 03 10 06 06 00 00 053 024 User: 03 10 06 06 00 00 053 024 <-No Change COMPRESS Master: Y Y Y Y Y User: Y Y Y Y Y <-No Change Essential Derived Type --------- ------- ---- FOPT File Master: DEFAULT DEFAULT USER Options User : DEFAULT DEFAULT USER <-No Change +----------------------------------------+ | MQAMMA File Data Element MODIFICATIONS | +----------------------------------------+ Element Label -------- --------------------------------------- MQSATYP MQ Type of Connection Modified Modification Seq Number Source ------------ ------------------------------------------------------------- ---------- -------- LABEL Master: Type Of Connection 00452000 MQSGENIN User: MQ Type of Connection 00452000 MQSGENIN +---------------------------------------------------------------------------------------------------------------------------------+
+---------------------------------------------------------------------------------------------------------------------------------+ D A T A B A S E M O D I F I C A T I O N R E P O R T Page 2 CA MICS Component: MQS Report: REPORT 5 - Product File Level Modifications MQS Last Generated: Mon, Jan 5, yyyy at 14:12:40 +---------------------------------------------------------------------------------------------------------------------------------+ AREA: MQA MQS Accounting Information Area FILE: MQAQAA Queue Activity File +----------------------+ | MQAQAA FILE OVERVIEW | +----------------------+ DET DAY WKS MON YRS AUD WHS MHS --- --- --- --- --- --- --- --- Timespans Master: N E Y Y N N Y Y User: Y E Y Y N N Y Y <-Modified CYCLES Master: 00 10 06 06 00 00 053 024 User: 03 10 06 06 00 00 053 024 <-Modified COMPRESS Master: Y Y Y Y Y User: Y Y Y Y Y <-No Change Essential Derived Type --------- ------- ---- FOPT File Master: DEFAULT DEFAULT USER Options User : DEFAULT DEFAULT USER <-No Change +----------------------------------------+ | MQAQAA File Data Element MODIFICATIONS | +----------------------------------------+ Element Label -------- --------------------------------------- MQSATYP MQ Type of Connection Modified Modification Seq Number Source ------------ -------------------------------------------------------------- ---------- -------- LABEL Master: Type Of Connection 01415100 MQSGENIN User: MQ Type of Connection 01415100 MQSGENIN Element Label -------- --------------------------------------- QAABUFFP Buffer Pool Number Modified Modification Seq Number Source ------------ ------------------------------------------------------------- ---------- -------- Timespan Master: 0 0 0 0 0 01463000 MQSGENIN User: 0 N N N N 01463000 MQSGENIN +---------------------------------------------------------------------------------------------------------------------------------+
The Complex ($DEGENIN) Common Data Element Modifications Report provides a listing of all additions, deletions, exceptions, and modifications made to the CA MICS database at the complex level. In the following example, the report shows that a new data element has been added at the complex level. +---------------------------------------------------------------------------------------------------------------------------------+ D A T A B A S E M O D I F I C A T I O N R E P O R T Page 1 CA MICS Component: BAS Report: REPORT C - Complex ($DEGENIN) Common Data Element Modifications BAS Last Generated: Wed, Dec 10, yyyy at 7:30:31 +---------------------------------------------------------------------------------------------------------------------------------+ +--------------------------------------+ | $DEGENIN File Data Element ADDITIONS | +--------------------------------------+ Element Label -------- --------------------------------------- AVTYAREX New Data Element NAME/NAMX TYPE Data Statement Statement Data Element Info Timespans Length Output Format Seq Number Seq Number ----------------------- --------- ------ -------------- ---------- ---------- Essential (NAME) DETAIL $8 . 00021200 00021100 Common Retained (XR) DAYS $8 . ALIAS: None WEEKS $8 . ALTNAME: None MONTHS $8 . YEARS $8 . +---------------------------------------------------------------------------------------------------------------------------------+
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |