Set up database connectivity for an IBM Db2 logging database

You must set up the database client software and the JDBC driver on all Application Tier Components computers with a connection to the logging database. You must set up the JDBC driver on the Content Manager computer, unless you are using the same type of database for the log messages as you use for the content store.

The driver version must be at least JCC 3.7 for a Linux® or UNIX operating system, or for a Microsoft Windows operating system version 9.1 fix pack, or JCC 3.42 for a Linux, UNIX operating system, or for a Microsoft Windows operating system version 9.5 fix pack 2.

Procedure

Copy the following files from DB2_installation\sqllib\java directory to the install_location\drivers directory:
  • The universal driver file, db2jcc4.jar
  • The license file:

    For Db2 on Linux, UNIX, or Windows operating systems, use db2jcc_license_cu.jar.

    For Db2 on z/OS®, use db2jcc_license_cisuz.jar.

    If you are connecting to Db2 on z/OS, use the driver version from Linux, UNIX, or Windows version 9.1 fix pack 5 or version 9.5 fix pack 2.

    Tip: To check the driver version, run the following command:

    java -cp path\db2jcc4.jar com.ibm.db2.jcc.DB2Jcc -version