Skip to content

Impact Analysis Housekeeping (Db2)

The Db2 tables that hold the impact analysis information should be scheduled for backup via image copy in accordance with your usual processes around production Db2 tables.

Load Impact Analysis Db2 tables

Restore the Impact Analysis tables by loading data from a set of sequential BUNSPACE, CMPSPACE, and RELSPACE files.
Sample JCL Member CMNDB2IL
Utilities DSNUTLIB (Db2 load)
CMNIALC0
ICEMAN
CMNIA910
Suggested Frequency On request
SERNET Status No requirements (it can be active or not)
Process Steps
  • Load the Db2 BUN table
  • Analyze incoming component and relationship flat files using CMNIALC0 and create two temporary files for later use.
  • Sort component data twice with ICEMAN dropping duplicates.
  • Sort relationship data with ICEMAN
  • Expand compressed version identifiers to visible character format
  • Load the Db2 component table
  • Load the Db2 relationship table
Comments Db2 locking will handle the loading of these tables while they are in use. However, to guarantee the avoidance of inconsistent data retrieval the load should be done at a time of little or no ZMF activity.

...

Note

You can also use this job to load the Impact Analysis Db2 tables with the BUNSPACE, CMPSPACE, and RELSPACE files created by the job initiated by the online Impact Analysis Maintenance function and file tailored from skeleton CMN$$IAX.

Synchronize Impact Analysis Data (Db2)

Extract impact analysis data from the ChangeMan ZMF package master and component master files to create sequential files BUNSPACE, CMPSPACE, and RELSPACE.

Perform multiple steps to load this information into the Db2 tables
Sample JCL Member IMPACTD2
CMNDB2IL
Utilities CMNIA000
DSNUTLIB (Db2 load)
CMNIALC0
ICEMAN
CMNIA910
Suggested Frequency On request whenever library types or baseline libraries are changed in application administration.
SERNET Status No requirements (it can be active or not).
Process Steps Impact job:
  • Delete BUNSPACE, CMPSPACE and RELSPACE using IEFBR14.
  • Build BUNSPACE, CMPSPACE and RELSPACE using CMNIA000.

CMNDB2IL job - refer to heading Load Impact Analysis Db2 tables above.
Comments Program CMNIA000 parses a component for relationships only if the component has never been baselined in a change package.

...