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

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

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

Icon that indicates the type of topic Reference topic



Timestamp icon Last updated: March 5, 2017 17:54
File name: rdat_minreqdb2dist.html