IBM Optim pureQuery Runtime makes
use of DB2 packages. These packages
consist of information for one or more Structured Query Language (SQL)
statements and are stored in the DB2 catalog.
You must first run the wsdbgen command on a Java Persistence API (JPA) application to create
the packages. The wsdbgen command creates an XML file containing
SQL statement information. This XML file must be included into the
application Java archive (JAR)
file. The DB2 bind command uses
this file as input to create the DB2 package.
Important:
- JPA sets the IBM Optim pureQuery Runtime property pdq.executionMode to
the value STATIC.
- The class path must include the install location for the IBM Optim
pureQuery Runtime. For more information, see the documentation about
installing IBM Optim pureQuery Runtime.
- The JPA provider implementation must be JPA for the application
server (com.ibm.websphere.persistence.PersistenceProviderImpl).
The OpenJPA persistence provider does not provide support for IBM
Optim pureQuery Runtime.
- The wsdbgen command requires the URL of a database. The wsdbgen
command forces a synchronize mapping function that creates or alters
the required tables. For DB2 zOS,
V8 unique indexes and LOB tables must be manually created prior to
executing the wsdbgen command.
newfeatIBM Optim
pureQuery Runtime properties are specified in a
pdq.properties file
in the META-INF directory of the application JAR file. The
pdq.ExecutionMode property
is defaulted to STATIC for JPA applications. You can use the pdqProperties
property to use IBM Optim pureQuery Runtime in DYNAMIC mode. For more
information, see the documentation about using IBM Optim pureQuery
Runtime in dynamic mode. PDQ properties, if specified, pass on to
the pureQuery runtime. See IBM Optim pureQuery Runtime documentation
for list of properties and valid values.
- wsjpa.jdbc.CollectionId :
String value specifying the collection ID to use. This overrides
any collection ID that is used during wsdbgen.
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®.