Binding the IBM Data Server Driver for JDBC and SQLJ packages for the XML schema repository

The XSR_COMPLETE XML schema repository stored procedure is a Java™ stored procedure. It requires the IBM Data Server Driver for JDBC and SQLJ packages.

About this task

You need to bind the following sets of IBM Data Server Driver for JDBC and SQLJ packages:
  • The NULLID collection ID
  • The SYSXSR collection ID

Procedure

To bind the IBM Data Server Driver for JDBC and SQLJ packages for the XML schema repository:

  1. In z/OS® UNIX System Services, execute the DB2Binder utility to bind the IBM Data Server Driver for JDBC and SQLJ under the SYSXSR collection ID.

    The DB2Binder command that you need to use looks like this:

    java com.ibm.db2.jcc.DB2Binder -url url 
-user user-id -collection SYSXSR -password password -action replace

    For example:

    java com.ibm.db2.jcc.DB2Binder -url myserver.svl.ibm.com:446/MYDB 
-user myid -collection SYSXSR -password mypass -action replace

    You need to make these substitutions when you run DB2Binder.

    Value in example Value to substitute
    myserver.svl.ibm.com:446/MYDB The server, port, and location name values for the Db2 subsystem on which you are setting up the XML schema repository.
    myid Your user ID
    mypass Your password
  2. In z/OS UNIX System Services, execute the DB2Binder utility to bind the IBM Data Server Driver for JDBC and SQLJ under the NULLID collection ID.

    The DB2Binder command looks like this.

    java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://myserver.svl.ibm.com:446/MYDB 
-user myid -collection NULLID -password mypass -action replace

    You need to make the same substitutions as in step 1.