Configuring data source JDBC providers to use IBM Optim pureQuery Runtime in a Java SE environment

Use this task to configure the application data source Java Database Connectivity (JDBC) provider to use IBM Optim pureQuery Runtime to access DB2® in a Java Standard Edition (JSE) environment.

Before you begin

If you need to use multiple DB2 package collections, see the documentation about configuring IBM Optim pureQuery Runtime to use multiple package collections, before continuing with this task.

About this task

Attention: Read more about the DB2 JAR level compliance for IBM Optim pureQuery Runtime at the IBM® Support Website: System requirements for IBM Optim pureQuery Runtime for Linux®, UNIX®, and Windows®.

Procedure

  1. Update the application data source JDBC provider configuration to include the IBM Optim pureQuery Runtime JAR files. Include the pdq.jar and pdqmgmt.jar files on the class path in addition to the JDBC driver jar files. Either define an new JDBC provider or modify an existing provider to include the JAR files. The class path must include the install location for the IBM Optim pureQuery Runtime. For more information, see the documentation about JDBC provider settings and installing IBM Optim pureQuery Runtime.
  2. Using the DB2 bind command provided by Data Studio, bind the XML file to the database. This creates the DB2 packages. For more information, see the documentation about the pureQuery Bind utility.

What to do next

If you want to reconfigure the data source for JDBC, remove the pdq.jar and pdqmgmt.jar from the class path.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Jun 11, 2013 8:40:09 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=v701sca&product=was-nd-mp&topic=tejb_configpdqjpase
File name: tejb_configpdqjpase.html