Remote DB2 for z/OS Connectivity

About this task

Before the connection can be established to the remote database it must be configured. The full details of installation of DB2 for z/OS are beyond the scope of this document set. However the following are the main post-installation steps to note:

Procedure

  1. A database can be configured for EBCDIC, ASCII, or UNICODE mode for use by the application. This can be done when creating the database using theCCSID keyword. For ASCII or UNICODE databases see the Cúram Server Developer's Guide for information about required property curam.db.zos.encoding.

    CREATE DATABASE <database_name> BUFFERPOOL BP0 INDEXBP BP0 STOGROUP <storage_group> CCSID <EBCDIC, ASCII or UNICODE>;

  2. An environment variable called DB2JCC_LICENSE_CISUZ_JAR must be created which points to the installed DB2 for z/OS license jar file used for connectivity to the remote database server. This is normally named db2jcc_license_cisuz.jar and is provided with the DB2 for z/OS or DB2 Connect product.