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
- 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.
- 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.