Catalog Utilities

ce18
Endevor
uses an Element Catalog file to support long element names and to boost performance by reducing the volume of I/O operations.
Catalog Rename Utility
The
Endevor
MCF Catalog Rename Utility lets you change the catalog name in the MCF's stage record. This utility should be run after you have created a new catalog and have defined it to the C1DEFLTS table.
With the implementation of the Element Catalog, all MCF's have the catalog name recorded in its stage record. The first time
Endevor
is invoked after migration from a prior release, the MCF's, at open time, are updated with the Element Catalog name. From that point on, (at open time)
Endevor
checks the stage record's catalog name against the name specified in the C1DEFLTS table. If the names are not equal, the MCF open fails. This check prevents MCF's from belonging to more than one catalog.
The
Endevor
MCF Catalog Rename Utility allows you to change the catalog name in the MCF's stage record. This utility should be run after you have created a new Catalog and have defined it to the C1DEFLTS table.
The utility can run in two modes:
  • Validate Mode-All environments defined in the C1DEFLTS table are examined. A report is produced showing the current MCF catalog name and a statement as to whether or not the name agrees or disagrees with the C1DEFLTS table. A return code of 0 indicates all environments match the table's definition. A return code of 4 indicates that some or all environments are not current with the table's definition.
  • Update Mode-All environments defined in the C1DEFLTS table are examined, but instead of just reporting the mismatches, the utility rewrites the stage records with the name defined from the C1DEFLTS table. A return code of 0, under Update mode, indicates that all environments match the table's definition. A return code of 4 indicates that some or all of the stages were updated with the table's name.
To execute the rename utility, use member BC1JXCNM from your JCL library. To invoke validate or update mode, change the PARM= parameter on the execute statement.
Catalog Synchronization Utility
The
Endevor
Catalog Synchronization Utility (BC1PCSYN) allows you to update the element catalog to recover differences between the element catalog and its related MCF files.
This utility has two modes, a validate mode and an update mode. The validate mode simply reports on the differences between the catalog and MCF files. The update mode actually recovers the differences between the element catalog and its related MCFs by updating the element catalog file.
Under the update mode, the utility synchronizes the element catalog and the MCF element records in two phases.
The first phase validates MCF records against the catalog. A catalog segment is created for any MCF record found missing from the catalog. A catalog segment is updated with MCF element data when the associated catalog data is found to be different.
The second phase validates the catalog to MCF to remove dead segments from the catalog. All segments which do not have a MCF element record are removed from the catalog.
Under validate mode, the utility performs the same two-phase check but does not modify the catalog. Any differences are simply reported in the execution log.
To select the mode, use the PARM= parameter on the JCL execution statement. 4.
In both phases, processing is done by environment. You can specify which environments the utility will process, or allow the environment selection to default to all environments defined in the C1DEFLTS table.
Do not use this utility to initially load the catalog file. Use job BC1JXCNV to load the catalog file. For more information, see Run the Catalog Build Utility.
Catalog Synchronization Utility JCL
To execute the synchronization utility (BC1PCSYN), use JCL member BC1JCSYN, which is available in your site's
Endevor
CSIQJCL data set. Edit this member to conform to the needs of your installation before executing the job.
Catalog Synchronization Utility Syntax
To select which environments the utility will process, you need to edit the BSTIPT DD JCL statement. If the DD statement is omitted or if the file is empty (no input syntax), all environments in the C1DEFLTS table are selected. The BSTIPT file is a 80 character fixed record file. The syntax follows the same parsing rules as
Endevor
SCL statements.
To select a single environment, specify the following:
ENVIRONMENT env-name.
To select multiple environments on a single line, specify the following:
ENVIRONMENT (env-name, env-name, env-name).
To select multiple environments on multiple lines, specify the following:
ENVIRONMENT (env-name, env-name, env-name,   env-name, env-name).
Catalog Synchronization Utility Sample Reports
The following sample report results from executing the utility in validate mode against a test
Endevor
system with three environments. In this example, the first two environments are out of sync with its catalog.
1  (C) 2005 Computer Associates International, Inc.                                                10NOV04 14:33:53       PAGE   1                                            Endevor MCF Catalog Synchronization UTILITY LOG              RELEASE 7.0  SERIAL B7000C        SYN0000I  BEGINNING PHASE 1      SYN0002I  ENVIRONMENT ENV1     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING    *MISSING* CTLG SGMT: ELEMENT EJZZBLONGNAME02                  TYPE JDOHFS   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *MISSING* CTLG SGMT: ELEMENT JBEANlongld5VERYLONGNAMEverylongnameVERYLONGNAMEverylongnameLAROSE                  TYPE JDOHFS   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *MISSING* CTLG SGMT: ELEMENT EJudylarose01                  TYPE JDOHFS   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *OLD    * CTLG SGMT: ELEMENT EJudylarose02                  TYPE JDOHFS   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *OLD    * CTLG SGMT: ELEMENT IA6PGM                  TYPE ASMPGM   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *OLD    * CTLG SGMT: ELEMENT OLENIC01                  TYPE JDOHFS   AT ENV ENV1     SID 2 SYS SYST100  SBS SBS100    SYN0003I  TOTAL # OF MISSING CTLG SGMTS FROM ENVIRON ENV1    :        3  SYN0004I  TOTAL # OF OLD CTLG SGMTS FOUND IN ENVIRON ENV1    :        3  SYN0005I  TOTAL # OF ELEMENTS PROCESSED FROM ENVIRON ENV1    :      102    SYN0002I  ENVIRONMENT ENVA     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING    *MISSING* CTLG SGMT: ELEMENT TESTJO1                  TYPE JCLI     AT ENV ENVA     SID 2 SYS SYSTA00  SBS SBSA00  *MISSING* CTLG SGMT: ELEMENT SANELM1                  TYPE JCLI     AT ENV ENVA     SID 2 SYS SYSTC00  SBS SBSC00    SYN0003I  TOTAL # OF MISSING CTLG SGMTS FROM ENVIRON ENVA    :        2  SYN0004I  TOTAL # OF OLD CTLG SGMTS FOUND IN ENVIRON ENVA    :        0  SYN0005I  TOTAL # OF ELEMENTS PROCESSED FROM ENVIRON ENVA    :        5    SYN0002I  ENVIRONMENT ENVZ     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING      SYN0003I  TOTAL # OF MISSING CTLG SGMTS FROM ENVIRON ENVZ    :        0  SYN0004I  TOTAL # OF OLD CTLG SGMTS FOUND IN ENVIRON ENVZ    :        0  SYN0005I  TOTAL # OF ELEMENTS PROCESSED FROM ENVIRON ENVZ    :        1    SYN0011I  TOTAL # OF ELEMENTS PROCESSED, ALL ENVIRONMENTS:          108      SYN0000I  BEGINNING PHASE 2      SYN0031I  ENVIRONMENT ENV1     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    *ORPHAN * CTLG SGMT: ELEMENT EJudylarose01                  TYPE JDOHFS   AT ENV ENV1     SID 2 SYS SYST100  SBS SBS100  *ORPHAN* CTLG SGMT: ELEMENT EJZZBLONGNAME02 1  (C) 2005 Computer Associates International, Inc.                                                10NOV04 14:34:03       PAGE   2                                            Endevor MCF Catalog Synchronization UTILITY LOG              RELEASE 7.0  SERIAL B7000C                        TYPE JDOHFS   AT ENV ENV1     SID 2 SYS SYST100  SBS SBS100  *ORPHAN * CTLG SGMT: ELEMENT JBEANlongld5VERYLONGNAMEverylongnameVERYLONGNAMEverylongnameLAROSE                  TYPE JDOHFS   AT ENV ENV1     SID 2 SYS SYST100  SBS SBS100  SYN0032I  TOTAL # OF ORPHAN CTLG SGMTS     IN  ENVIRON ENV1    :        3  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENV1    :      105    SYN0031I  ENVIRONMENT ENVA     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    *ORPHAN * CTLG SGMT: ELEMENT SANELM1                TYPE JCLI     AT ENV ENVA     SID 1 SYS SYSTC00  SBS SBSC00  *ORPHAN * CTLG SGMT: ELEMENT TESTJO1                TYPE JCLI     AT ENV ENVA     SID 1 SYS SYSTA00  SBS SBSA00  SYN0032I  TOTAL # OF ORPHAN CTLG SGMTS     IN  ENVIRON ENVA    :        2  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENVA    :        7    SYN0031I  ENVIRONMENT ENVZ     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    SYN0032I  TOTAL # OF ORPHAN CTLG SGMTS     IN  ENVIRON ENVZ    :        0  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENVZ    :        1    SYN0034I  TOTAL CATALOG SEGMENTS PROCESSED, ALL ENVIRONMENTS:         113        
If the utility is executed again, but this time in update mode, the catalog is repaired and the following log report is produced.
  1  (C) 2005 Computer Associates International, Inc.                                                10NOV04 14:33:53       PAGE   1                                            Endevor MCF Catalog Synchronization UTILITY LOG              RELEASE 7.0  SERIAL B7000C        SYN0000I  BEGINNING PHASE 1      SYN0002I  ENVIRONMENT ENV1     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING    *CREATED* CTLG SGMT: ELEMENT EJZZBLONGNAME02                  TYPE JDOHFS   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *CREATED* CTLG SGMT: ELEMENT JBEANlongld5VERYLONGNAMEverylongnameVERYLONGNAMEverylongnameLAROSE                  TYPE JDOHFS   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *CREATED* CTLG SGMT: ELEMENT EJudylarose01                  TYPE JDOHFS   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *UPDATED* CTLG SGMT: ELEMENT EJudylarose02                  TYPE JDOHFS   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *UPDATED* CTLG SGMT: ELEMENT IA6PGM                  TYPE ASMPGM   AT ENV ENV1     SID 1 SYS SYST100  SBS SBS100  *UPDATED* CTLG SGMT: ELEMENT OLENIC01                  TYPE JDOHFS   AT ENV ENV1     SID 2 SYS SYST100  SBS SBS100    SYN0003I  TOTAL CATALOG SEGMENTS CREATED FOR ENVIRON ENV1    :        3  SYN0004I  TOTAL CATALOG SEGMENTS UPDATED FOR ENVIRON ENV1    :        3  SYN0005I  TOTAL #  OF ELEMENTS PROCESSED FOR ENVIRON ENV1    :      102    SYN0002I  ENVIRONMENT ENVA     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING    *CREATED* CTLG SGMT: ELEMENT TESTJO1                  TYPE JCLI     AT ENV ENVA     SID 2 SYS SYSTA00  SBS SBSA00  *CREATED* CTLG SGMT: ELEMENT SANELM1                  TYPE JCLI     AT ENV ENVA     SID 2 SYS SYSTC00  SBS SBSC00    SYN0003I  TOTAL CATALOG SEGMENTS CREATED FOR ENVIRON ENVA    :        2  SYN0004I  TOTAL CATALOG SEGMENTS UPDATED FOR ENVIRON ENVA    :        0  SYN0005I  TOTAL #  OF ELEMENTS PROCESSED FOR ENVIRON ENVA    :        5    SYN0002I  ENVIRONMENT ENVZ     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING      SYN0003I  TOTAL CATALOG SEGMENTS CREATED FOR ENVIRON ENVZ    :        0  SYN0004I  TOTAL CATALOG SEGMENTS UPDATED FOR ENVIRON ENVZ    :        0  SYN0005I  TOTAL #  OF ELEMENTS PROCESSED FOR ENVIRON ENVZ    :        1    SYN0011I  TOTAL # OF ELEMENTS PROCESSED, ALL ENVIRONMENTS:          108      SYN0000I  BEGINNING PHASE 2      SYN0031I  ENVIRONMENT ENV1     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    *DELETED* CTLG SGMT: ELEMENT EJudylarose01                  TYPE JDOHFS   AT ENV ENV1     SID 2 SYS SYST100  SBS SBS100  *DELETED* CTLG SGMT: ELEMENT EJZZBLONGNAME02 1  (C) 2005 Computer Associates International, Inc.                                                10NOV04 14:34:03       PAGE   2                                            Endevor MCF Catalog Synchronization UTILITY LOG              RELEASE 7.0  SERIAL B7000C                        TYPE JDOHFS   AT ENV ENV1     SID 2 SYS SYST100  SBS SBS100  *DELETED* CTLG SGMT: ELEMENT JBEANlongld5VERYLONGNAMEverylongnameVERYLONGNAMEverylongnameLAROSE                  TYPE JDOHFS   AT ENV ENV1     SID 2 SYS SYST100  SBS SBS100  SYN0032I  TOTAL CATALOG SEGMENTS DELETED   FOR ENVIRON ENV1    :        3  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENV1    :      105    SYN0031I  ENVIRONMENT ENVA     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    *DELETED* CTLG SGMT: ELEMENT SANELM1                TYPE JCLI     AT ENV ENVA     SID 1 SYS SYSTC00  SBS SBSC00  *DELETED* CTLG SGMT: ELEMENT TESTJO1                TYPE JCLI     AT ENV ENVA     SID 1 SYS SYSTA00  SBS SBSA00  SYN0032I  TOTAL CATALOG SEGMENTS DELETED   FOR ENVIRON ENVA    :        2  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENVA    :        7    SYN0031I  ENVIRONMENT ENVZ     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    SYN0032I  TOTAL CATALOG SEGMENTS DELETED   FOR ENVIRON ENVZ    :        0  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENVZ    :        1    SYN0034I  TOTAL CATALOG SEGMENTS PROCESSED, ALL ENVIRONMENTS:         113        
If the utility is executed again in update mode, no discrepancies should be found, as indicated in the following sample report.
  1  (C) 2005 Computer Associates International, Inc.                                                10NOV04 14:36:29       PAGE   1                                            Endevor MCF Catalog Synchronization UTILITY LOG              RELEASE 7.0  SERIAL B7000C        SYN0000I  BEGINNING PHASE 1      SYN0002I  ENVIRONMENT ENV1     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING      SYN0003I  TOTAL CATALOG SEGMENTS CREATED FOR ENVIRON ENV1    :        0  SYN0004I  TOTAL CATALOG SEGMENTS UPDATED FOR ENVIRON ENV1    :        0  SYN0005I  TOTAL #  OF ELEMENTS PROCESSED FOR ENVIRON ENV1    :      102    SYN0002I  ENVIRONMENT ENVA     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING      SYN0003I  TOTAL CATALOG SEGMENTS CREATED FOR ENVIRON ENVA    :        0  SYN0004I  TOTAL CATALOG SEGMENTS UPDATED FOR ENVIRON ENVA    :        0  SYN0005I  TOTAL #  OF ELEMENTS PROCESSED FOR ENVIRON ENVA    :        5    SYN0002I  ENVIRONMENT ENVZ     MCF ELEMENT TO CATALOG SYNCRONIZATION STARTING      SYN0003I  TOTAL CATALOG SEGMENTS CREATED FOR ENVIRON ENVZ    :        0  SYN0004I  TOTAL CATALOG SEGMENTS UPDATED FOR ENVIRON ENVZ    :        0  SYN0005I  TOTAL #  OF ELEMENTS PROCESSED FOR ENVIRON ENVZ    :        1    SYN0011I  TOTAL # OF ELEMENTS PROCESSED, ALL ENVIRONMENTS:          108      SYN0000I  BEGINNING PHASE 2      SYN0031I  ENVIRONMENT ENV1     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    SYN0032I  TOTAL CATALOG SEGMENTS DELETED   FOR ENVIRON ENV1    :        0  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENV1    :      102    SYN0031I  ENVIRONMENT ENVA     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    SYN0032I  TOTAL CATALOG SEGMENTS DELETED   FOR ENVIRON ENVA    :        0  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENVA    :        5    SYN0031I  ENVIRONMENT ENVZ     CATALOG TO MCF ELEMENT SYNCRONIZATION STARTING.    SYN0032I  TOTAL CATALOG SEGMENTS DELETED   FOR ENVIRON ENVZ    :        0  SYN0033I  TOTAL CATALOG SEGMENTS PROCESSED FOR ENVIRON ENVZ    :        1    SYN0034I  TOTAL CATALOG SEGMENTS PROCESSED, ALL ENVIRONMENTS:         108
Catalog Build Utility
Should you need to create, or re-create a catalog, you can use the catalog build utility.
Run the Catalog Build Utility
Run the catalog utility to populate the catalog data set with element information. This utility should only be run during the conversion process and it must be run against all environments defined in your C1DEFLTS table.
BC1PXMCS allows you to selectively choose the environments you want to populate. You can run it against each environment separately or against all environments collectively in a single step. Before you begin to use
Endevor
, you must have run the conversion utility against all environments defined in your C1DEFLTS table. Use member BC1JXCNV from your
Endevor
JCL library to tailor the job stream to do your initial build of the element catalog.
The person running this job must have the authority to access all the environments in the C1DEFLTS table (if BSTIPT is omitted) or all environments specified on the BSTIPT statement. Otherwise, the catalog contents will be incomplete and may result in "element not found" errors.
The output report of running the BC1JXCNV job is written to BSTLST. This report contains the number of catalog segments read and written to the catalog data set.
Sample Output Report
This section describes the sample output of running the BC1JXCNV utility that loaded an empty catalog data set from a C1DEFLTS table, containing two environments, TEST and PROD, with BSTIPT omitted. The output generated by BC1PXMCS, BC1PXCCS, and BC1PXCSC to BSTLST is described next.
BC1PXMCS in step 3 creates element segment records from MCFS and generates the following report:
Endevor
MCF Conversion Element Extract UTILTIY LOGMCF CATALOG SEGMENT DATA WILL BE CREATED FOR ENVIRONMENT TESTNUMBER OF CATALOG SEGMENTS WRITTEN FOR ENVIRONMENT TEST: 9243MCF CATALOG SEGMENT DATA WILL BE CREATED FOR ENVIRONMENT PRODNUMBER OF CATALOG SEGMENTS WRITTEN FOR ENVIRONMENT PROD: 5978TOTAL NUMBER OF CATALOG SEGMENTS WRITTEN, ALL ENVIRONMENTS: 15221
BC1PXCCS in step 4 extracts segment records and produces the following report:
Endevor
Catalog Segment Extraction UTILITY LOGCCS0008I TOTAL NUMBER OF CATALOG SEGMENTS READ: 0CCS0009I TOTAL NUMBER OF CATALOG SEGMENTS WRITTEN: 0
If you are loading an empty catalog data set, the number of catalog segments read and written should be zero.
BC1PXCSC in step 6 creates catalog records from the catalog segments and generates the following output:
Endevor
MCF Element Segment Conversion to Catalog Format UTILITY LOGTOTAL NUMBER OF ELEMENT ENTRIES READ, ALL ENVIRONMENTS: 15221TOTAL NUMBER OF CATALOG ENTRIES WRITTEN, ALL ENVIRONMENTS: 13366TOTAL NUMBER OF ELEMENT INDEX RECORDS WRITTEN, ALL ENVIRONMENTS: 10183
You can also use the BC1JXCNV utility to add a new, populated environment to an existing C1DEFLTS table and catalog data set. In the following sample output, the ARCHIVE environment is added to an existing catalog data set. The output reports produced by step 3, step 4 and step 6 are described next.
BC1PXMCS in step 3 generates the following output:
Endevor
MCF Conversion Element Extract UTILTIY LOGENV ARCHIVEMCF CATALOG SEGMENT DATA WILL BE CREATED FOR ENVIRONMENT ARCHIVE: 75TOTAL NUMBER OF CATALOG SEGMENTS WRITTEN, ALL ENVIRONMENTS: 75
BC1PXCCS in step 4 generates the following output:
Endevor
Catalog Segment Extraction UTILITY LOGNUMBER OF CATALOG SEGMENTS WRITTEN: 2500NUMBER OF CATALOG SEGMENTS WRITTEN: 5000NUMBER OF CATALOG SEGMENTS WRITTEN: 7500NUMBER OF CATALOG SEGMENTS WRITTEN: 10000NUMBER OF CATALOG SEGMENTS WRITTEN: 12500NUMBER OF CATALOG SEGMENTS WRITTEN: 15000TOTAL NUMBER OF CATALOG SEGMENTS READ: 15221TOTAL NUMBER OF CATALOG SEGMENTS WRITTEN: 15221
BC1PXCSC in step 6 generates the following output:
Endevor
MCF Element Segment Conversion to Catalog Format UTILITY LOGTOTAL NUMBER OF ELEMENT ENTRIES READ, ALL ENVIRONMENTS: 15296TOTAL NUMBER OF CATALOG ENTRIES WRITTEN, ALL ENVIRONMENTS: 13420TOTAL NUMBER OF ELEMENT INDEX RECORDS WRITTEN, ALL ENVIRONMENTS: 10215