[AIX Solaris HP-UX Linux Windows]

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 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 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 prior to migrating 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
Reference topic    

Terms and conditions for information centers | Feedback

Last updated: April 20, 2014 08:46 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=phil&product=was-nd-mp&topic=rdat_minreqdb2dist
File name: rdat_minreqdb2dist.html