Configuring IBM Optim pureQuery Runtime to use multiple DB2 package collections

Set up a IBM Optim pureQuery Runtime Java Persistence API (JPA) application to use multiple DB2® package collections.

About this task

It is possible for multiple copies of a database schema to exist. This situation might happen in a partitioned database schema where there is one database for east coast employee data and another database for west coast employee data. In this case, the two databases have the same schema. There might be two databases with two database catalogs. Or there might be only one database, in which case, the high-level qualifier of the table names (the schema name) must be different. Since the schemas are the same, there can be a single set of JPA entities that are used to access both sets of data. There are several ways to configure JPA to handle these situations.

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

The following three scenarios exist that require the use of multiple DB2 package collections. If you need more information on configuring IBM Optim pureQuery Runtime, read about configuring an application to use IBM Optim pureQuery Runtime.
  1. When there are two persistence units with different data source names, using static SQL, two sets of DB2 packages exist: one DB2 package in each database. Since two persistence units exist, two persistence_unit_name.pdqxml files for the JPA runtime environment exist.



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_pdqconfigpkg
File name: tejb_pdqconfigpkg.html