Customization

Procedure

After installing the z/OS offloader you must carry out the following customization steps:

  1. Customize the script /usr/lpp/ing/adapter/ingreport.sh. Adapt the installation path: 
    INSTALL_DIR=/usr/lpp/ing/adapter
  2. Copy the sample job INGXRPRT and follow the steps as described in it.
    There are several input parameters that you need to set correctly otherwise the conversion utility cannot access the DB2 table:
    Parameter Details
    INGDSN=HLQ.SMF.REPORT The data set of the SMF report created by the INGPUSMF utility.
    INGSEPCHAR=; This must be the separator as used by the INGPUSMF utility.
    INGDOMAIN=MyDomain The name of the E2E domain as specified in the E2E adapter configuration file, ing.adapter.plugin.properties. If omitted the default is used, which consists of the sysplex name and XCF group name.
    INGDB2_USER=db2inst1 The DB2® user name for remote logon.
    INGDB2_PSW=db2admin The DB2 password for remote logon.
    INGDB2_PORT=50000 The TCP/IP port to connect to the remote DB2.
    INGDB2_SERVER=db2-host-name The TCP/IP host name to connect to the remote DB2.
    INGDB2_NAME=EAUTODB The DB2 name or the DB2 location if DB2 resides on z/OS.
    INGDB2_SCHEMA=EAUTOUSR The DB2 schema of the table.
  3. (Optional) If the database is located on a z/OS system, a DB2 license file is required. An appropriate license file for z/OS platform, db2jcc_licencse_*.jar must be installed in the application classpath. Connectivity to z/OS databases is enabled with the license file as defined by the following table.
    Update DB2 database From==> To License file required
    Distributed system ==> z/OS® DB2 db2jcc_license_cisuz.jar
    z/OS system ==> z/OS DB2 db2jcc_license_cisuz.jar
    z/OS system ==> distributed DB2 db2jcc_license_cu.jar
    1. Copy the appropriate license file, for example, from DB2_INSTALL_PATH/db2/db2v8/jcc/classes/db2jcc_license_cisuz.jar to the directory /usr/lpp/ing/adapter/lib.
    2. Modify the classpath in the script /usr/lpp/ing/adapter/ingreport.sh and add the license file for example:
      DB2_LICENSE+$INSTALL_LIB/db2jcc_license_cu.jar
  4. Run the INGXRPRT job that copies the SMF report to DB2.