Manually upgrading the database on DB2 for z/OS from 11.4 to 11.5

Follow the steps to upgrade the version 11.4 InfoSphere® MDM database to the version 11.5 InfoSphere MDM database on DB2® for z/OS®.

Before you begin

If applicable, upgrade your MDM database from version 11.3 to version 11.4 before beginning this procedure.

Procedure

  1. To connect to DB2 for OS/390® and z/OS server from a DB2 Linux®, UNIX, or Windows server, DB2 Connect must be installed on the server you are connecting from. Enterprise editions contain DB2 Connect. To connect to the database, enter the following information:
    • Host name or IP address
    • DB2 port (default = 446)
    • Database name
    • Subsystem location name
    • User ID and password
  2. On the client server, catalog the database by running the following commands in this order:
    1. db2 catalog tcpip node YOUR_NODE_NAME remote Z/OS_HOSTNAME/IP_ADDRESS server Z/OS_PORT
    2. db2 catalog db YOUR_DB_NAME at node YOUR_NODE_NAME authentication dcs
    3. db2 catalog dcs db YOUR_DB_NAME as Z/OS_LOCATION_NAME
  3. If you are using this user ID to connect to the DB2 subsystem for the first time, rebind the packages for the database by following either of these steps:
    1. Rebind all the packages by running the command: db2rbind YOUR_DB_NAME all /u USER_NAME /p PASSWORD /r any
    2. Rebind individual packages by running the command: db2 bind package_name
  4. Change the placeholder tags in the all of the scripts:
    • Replace <DBA_ACCOUNT> with the user ID of the database administrator.
    • Replace <USER_ACCOUNT> with the user ID of the table owner.
    • Replace <db_prefix> with the three character database prefix.
    • Replace <STOGROUP_NAME> with the storage group name.
    • Replace <SCHEMA> with the schema name, in uppercase characters.
  5. From the upgrade folder, run the following script to create indexes for the existing tables: 
    db2 -tvf create_ix_zos.sql -1 log_file_name
  6. Navigate to the MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/DB2/ZOS/ddl directory.
  7. In the folder name, CODE_LANG is the language that is currently installed. If you are loading English data only, set CODE_LANG to en. Otherwise, set CODE_LANG to the language code of the language you are loading.
    Note: If any of the directories are empty, no data was generated and you do not need to run the scripts.
    • MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/DB2/ZOS/ddl/data_req_CODE_LANG/data
    • MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/DB2/ZOS/ddl/data_CODE_LANG/data-industry
    • MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/DB2/ZOS/ddl/data_opt_CODE_LANG/data
  8. To load the common data from the command line, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/DB2/ZOS/ddl/data_req_en/data directory. Use the command: db2 -tvf script_name-l log_file_name:
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
  9. To load the English industry data from the command line, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/DB2/ZOS/ddl/data_en/data-industry directory. Use the command: db2 -tvf script_name -l log_file_name:
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
  10. If you are loading industry data for a language other than English, from the command line, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/DB2/ZOS/ddl/data_CODE_LANG/data-industry directory.
    Use the command: db2 -tvf script_name -l log_file_name
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
  11. If you are loading code table data for a language other than English, from the command line, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/DB2/ZOS/ddl/data_opt_CODE_LANG/data directory. Use the command: db2 -tvf script_name -l log_file_name:
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
  12. Repeat the previous step for each non-English language that is installed.
  13. From the command line, run the command: db2 -tvf ImpReqDataCfgMgr_zos.sql -l log_file_name.
  14. From the command line, run the command: db2 -tvf QryUpdCfgMgrData_zos.sql -l log_file_name.