Data source minimum required settings for DB2 with the application server on AIX, HP-UX, Linux, Solaris, or Windows

These properties vary according to the database vendor requirements for JDBC driver implementations. You must set the appropriate properties on every data source that you configure. These settings are for a DB2® data source that is connecting to an application server that is running on AIX®, HP-UX, Linux®, Solaris, or Windows® systems.

[HP-UX] Avoid trouble: The SafepointPolling technology in the HP Java™ virtual machine (JVM) for HP-UX might interfere with DB2 transactions. Developed to ensure safepoints for Java threads, SafepointPolling technology generates a signal that can interfere with the signal between the application server and a DB2 database. Database deadlocks often result. Prevent the interference by starting the JVM with the -XX:-SafepointPolling option, which disables SafepointPolling during runtime.gotcha
[AIX HP-UX Solaris] Avoid trouble:

Starting with version 9 of DB2, Linux, HP-UX, and Solaris systems require a 64-bit kernel. In addition, the width of the default instance bit is now determined by the operating system, which is different than with previous versions of DB2. With these changes in operating system requirements, the -w option, which would have provided the ability to specify the bit width of the instance, was removed for the db2icrt, db2ilist and db2iupdt commands.

These changes on Linux, HP-UX, and Solaris systems preclude the ability to create or maintain a 32-bit instance of the application server with version 9 of DB2 on UNIX® platforms. On 64-bit UNIX systems that have a 32-bit instance created for version 8 of DB2, migrate the 32-bit instance for version 8 of DB2 to a 64-bit instance for version 8 of DB2 before you migrate the instance to version 9 of DB2.

gotcha
You can configure one of the following types of providers:
Attention: The LIBPATH for a 32-bit application is:
  • $INSTHOME/sqllib/lib
  • $INSTHOME/sqllib/lib32
The LIBPATH for a 64-bit application is:
  • $INSTHOME/sqllib/lib2
  • $INSTHOME/sqllib/lib64



Related tasks
Configuring a JDBC provider and data source
Configuring a JDBC provider using the administrative console
Configuring a data source using the administrative console
Creating and configuring a JDBC provider and data source using the JMX API
Configuring new data source custom properties using wsadmin
Related reference
Reference topic    

Terms of Use | Feedback

Last updated: Oct 20, 2010 7:53:43 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-nd-dist&topic=rdat_minreqdb2dist
File name: rdat_minreqdb2dist.html