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:

  1. Log on to TSO as a customizer (UCUST1).
  2. 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
    where:
    prefix
    The data set prefix, for example, FTMDEP.FTMSW300.
    ou
    The name of the OU addressed by the modules in the data set.
    Use the following DCB values:
    DSORG = PO
    RECFM = FB
    LRECL = 80
  3. Open a z/OS UNIX session.
  4. Change to the following directory:
    deployment_directory/DNIvINST/admin
    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:
    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.
  5. 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.
  6. Run the scripts from the deployment directory. For example, if the name of your instance is INST1:
    1. Change to the directory:
      /var/ftmswift_v300/cus/depdata/INST1/admin
    2. To run dniczcpa enter:
      ./dniczcpa
      This script makes the following modules available in your instance administration data set (FTMDEP.FTMSW300.DNIvINST.ADMIN):
      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.
    3. To run dnfczcpa enter:
      ./dnfczcpa
      This script makes the following modules available in your instance administration data set (FTMDEP.FTMSW300.DNIvINST.ADMIN):
      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.
    4. To run each script with a name of the form ou_dniczcpo enter:
      ./ou_dniczcpo
      Each of these scripts makes the following modules available in the corresponding OU administration data set (FTMDEP.FTMSW300.DNIvINST.ADMIN.ou):
      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.