Configuring JDBC providers to use pureQuery to access DB2

Use this task to configure the application data source Java™ Database Connectivity (JDBC) provider to use pureQuery to access DB2® in a Java EE environment.

Before you begin

If you need to use multiple DB2 package collections, see the information center topic, Configuring pureQuery to use multiple package collections, before continuing with this task.

About this task

Attention: Read more about the DB2 JAR level compliance for pureQuery 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 pureQuery runtime JAR file. Either define an new JDBC provider or modify an existing provider to include the following JAR files. See information center topics on JDBC provider settings and installing pureQuery Runtime for more information.
    • pdq.jar
    • pdqmgmt.jar
  2. Using the DB2 bind command, bind the XML file to the database. This creates the DB2 packages. There are three ways to do this:
    • Use the wsadmin command. Refer to the information center topic on application management command group for the AdminTask object for more information.
    • Using the administrative console. Refer to the information center topic on SQLj profiles and pureQuery bind files settings for more information.
    • Using the DB2 bind command provided by Data Studio. Refer to the information center topic on the pureQuery Bind utility for more information.

What to do next

If you want to reconfigure the data source for JDBC, just 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    

Terms of Use | Feedback

Last updated: Oct 21, 2010 7:37:48 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=v701sca&product=was-nd-mp&topic=tejb_configpdq
File name: tejb_configpdq.html