Data source minimum required settings for DB2 with the application server on Windows, UNIX, or Linux systems

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 Windows, Unix, Linux, or similar systems.

What type of configuration do you have?

DB2 on Windows, supported UNIX systems, or workstation-based Linux 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, UNIX 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 UNIX 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

DB2 on z/OS, connecting to an application server on Windows, supported UNIX systems, or workstation-based Linux systems




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 Java Management Extensions API
Reference topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 7:21:45 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=vela&product=was-nd-dist&topic=rdat_minreqdb2dist
File name: rdat_minreqdb2dist.html