Special setup for accessing DB2 for z/OS servers from Java™ programs

If you plan to write JDBC or SQLJ applications that access DB2® for z/OS® database servers, your IBM® Data Server Driver for JDBC and SQLJ installation process requires additional steps.

Follow these steps to allow connectivity to DB2 for z/OS servers:

1. If you plan to connect to any DB2 for z/OS data servers, install these PTFs on those database servers.

   Table 1. PTFs for DB2 for z/OS data servers

   DB2 for z/OS	PTF or APAR numbers
   Version 8	UQ93890, UK21849
   Version 9	UK38087
   Version 10	UK91146 (needed for connections from IBM Data Server Driver for JDBC and SQLJ Version 3.66 or 4.16 only)

2. Run the com.ibm.db2.jcc.DB2Binder utility to bind the DB2 packages that are used at the server by the IBM Data Server Driver for JDBC and SQLJ.
3. On DB2 for z/OS database servers, customize and run job DSNTIJMS.

   DSNTIJMS is located in data set prefix.SDSNSAMP. It performs the following functions:

   • Creates the following stored procedures to support DatabaseMetaData methods, tracing, and error message formatting.
     • SQLCOLPRIVILEGES
     • SQLCOLUMNS
     • SQLFOREIGNKEYS
     • SQLFUNCTIONS
     • SQLFUNCTIONCOLUMNS
     • SQLGETTYPEINFO
     • SQLPRIMARYKEYS
     • SQLPROCEDURECOLS
     • SQLPROCEDURES
     • SQLPSEUDOCOLUMNS (DB2 for z/OS Version 10 or later)
     • SQLSPECIALCOLUMNS
     • SQLSTATISTICS
     • SQLTABLEPRIVILEGES
     • SQLTABLES
     • SQLUDTS
     • SQLCAMESSAGE
   • Creates the following tables to support efficient storing of data in CLOB or DBCLOB columns and the use of LOB locators for CLOB or DBCLOB retrieval:
     • SYSIBM.SYSDUMMYU
     • SYSIBM.SYSDUMMYA
     • SYSIBM.SYSDUMMYE
     An alternative way to create those tables is to run the com.ibm.db2.jcc.DB2LobTableCreator utility on the client, against each of the DB2 for z/OS servers.
4. Enable Unicode support for OS/390® and z/OS servers.

   If any SQLJ or JDBC programs will use IBM Data Server Driver for JDBC and SQLJ type 4 connectivity to connect to a DB2 for z/OS Version 7 server, the OS/390 or z/OS operating system must support the Unicode UTF-8 encoding scheme. This support requires OS/390 Version 2 Release 9 with APAR OW44581, or a later release of OS/390 or z/OS, plus the OS/390 R8/R9/R10 Support for Unicode. Information APARs II13048 and II13049 contain additional information.