Providing the DB2 packages required by the routines

The FTM SWIFT routines require the DB2® packages for the Data Server Driver for JDBC and SQLJ. They must be bound into a collection which is used later in the customization process when the procedures are created.

To bind the Data Server Driver for JDBC and SQLJ packages into the collection for the routines:

  1. On the runtime system, log on z/OS® UNIX as a DB2 administrator (UDB2ADM1). The access rights of this user are described in Users involved in installation, customization, and configuration.
  2. Change to the routine instance directory that you created in Creating the runtime directory structure for the Java database routines. Change to:
    /var/ftmswift_v300/run/routines_jcc/DNIvINST
  3. Run dnimzrcc by entering:
    . ./dnimzrcc
  4. Issue the following command:
    java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://server:port/DNIvDSN
                                   -user userid 
                                   -password password 
                                   -size 1 
                                   -collection DNIvSN
    where:
    server
    The domain name or IP address of the database server.
    port
    The TCP/IP server port number that is assigned to the database server. This is an integer in the range 0 - 65535. The default is 446.
    DNIvDSN
    The name of the DB2 location where the runtime database of FTM SWIFT resides. All characters in this value must be uppercase characters.
    userid and password
    The user ID and password of the DB2 administrator (UDB2ADM1) under which the packages are to be bound.
    DNIvSN
    The DB2 collection of the FTM SWIFT routines. It has the same value as the DB2 schema used by FTM SWIFT.