Providing DB2 administration modules
For some tasks, you need to issue SQL statements or DSN or Utility commands that are contained in a specific administration module. To copy these modules from the HFS deployment directory to MVS™ data sets on the runtime system:
- Log on to TSO as a customizer (UCUST1).
- Check whether the following partitioned
target data sets are already on the runtime system and, if not, allocate
them:
- The instance administration data set, which is the data set in
which instance-level administration modules that operate on objects
that are shared by different OUs of the same FTM SWIFT instance are stored. Give the
data set a name of the form:
prefix.DNIvINST.ADMIN - The OU administration data set, which is the data set in which
OU-specific administration modules that operate within the scope of
a single OU are stored. You must define one such data set per OU.
Give each of the data sets a name of the form:
prefix.DNIvINST.ADMIN.ou
- prefix
- The data set prefix, for example, FTMDEP.FTMSW300.
- ou
- The name of the OU addressed by the modules in the data set.
DSORG = PO RECFM = FB LRECL = 80 - The instance administration data set, which is the data set in
which instance-level administration modules that operate on objects
that are shared by different OUs of the same FTM SWIFT instance are stored. Give the
data set a name of the form:
- Open a z/OS UNIX session.
-
Change to the following directory:
This directory contains the deployment data for the ADMIN resource class of the instance server and the following scripts, which copy the administration modules from the HFS file system to the MVS data sets that were allocated in step 2:deployment_directory/DNIvINST/admin- dniczcpa
- Copies instance-level administration modules of FTM SWIFT to your instance administration data set.
- dnfczcpa
- Copies instance-level administration modules of the SIPN FIN service to your instance administration data set. This module is needed (and is available) only if the SIPN FIN service bundle was assigned to one or more server-OU combinations.
- <ou>_dniczcpo
- Copies OU-specific administration modules of FTM SWIFT to your OU administration data set.
- Edit each of these scripts:
- In the copy commands, replace the prefix FTMDEP.FTMSW300 with the prefix specified in step 2.
- Search for placeholders that were not assigned values during customization (these will begin with the characters DNFv or DNIv), and replace each of them with an appropriate value.
- Run the scripts from the deployment directory. For example,
if the name of your instance is INST1:
- Change to the directory:
/var/ftmswift_v300/cus/depdata/INST1/admin - To run dniczcpa enter:
This script makes the following modules available in your instance administration data set (FTMDEP.FTMSW300.DNIvINST.ADMIN):./dniczcpa- DNICDHCV
- Generates, in the history database, audit views for the instance-related (not OU-related) data in the FTM SWIFT configuration and security administration tables.
- DNIMZCFO
- Invokes REORG utility for selected table spaces of configuration and security administration tables.
- DNIMZCFR
- Restores, to the FTM SWIFT configuration and security administration tables, the consistent set of image copies previously generated by module DNIMZCFS.
- DNIMZCFS
- Creates a consistent set of image copies that contain the data in the FTM SWIFT configuration and security administration tables.
- DNIMZORO
- Invokes REORG utility for selected table spaces of service bundle DNFEFAS.
- DNIMZOST
- Starts RUNSTATS for table spaces of service bundle DNFEFAS.
- DNIMZRST
- Starts RUNSTATS for the FTM SWIFT configuration and security administration tables.
- To run dnfczcpa enter:
This script makes the following modules available in your instance administration data set (FTMDEP.FTMSW300.DNIvINST.ADMIN):./dnfczcpa- DNFCZFUS
- Manipulates the catalog statistics of tables DNF_OAMS and DNF_IAMS.
- DNFMZBND
- Binds the DB2® application package of the finite state machine (FSM) of the SWIFTNet FIN Daemon (SFD).
- DNFMZRBD
- Rebinds the DB2 application package of the FSM of the SWIFTNet FIN Daemon.
- DNFMZREO
- Reorganizes table spaces DNFTS01 and DNFIAMS of service bundle DNFFIN.
- DNFMZRST
- Starts RUNSTATS for table spaces of service bundle DNFFIN.
- DNFMZRS1
- Starts RUNSTATS for table spaces of service bundle DNFFIN. The statistics information in the catalog is not updated.
- To run each script with a name of the form ou_dniczcpo
enter:
Each of these scripts makes the following modules available in the corresponding OU administration data set (FTMDEP.FTMSW300.DNIvINST.ADMIN.ou):./ou_dniczcpo- DNICDCAP
- Creates the DB2 objects of the partitioned message audit log for the default partitioning scheme.
- DNICDATR
- Creates the trigger to activate the data integrity framework for the partitioned message audit log.
- DNICDHOV
- Generates, in the history database, audit views for the OU-related data in the FTM SWIFT configuration and security administration tables.
- DNICDVAP
- Creates a view on the partitioned message audit log to allow applications to access it as if it were a non-partitioned message audit log.
- Change to the directory: