Known issues for DB2 on HP-UX

Abstract

This document describes known HP-UX issues, related to DB2® database products.

Content

Three most recent additions. November 6, 2006. HP-UX 11i v2 - Itanium Architecture. Application with unbound threads traps with SIGBUS. November 15, 2005. HP-UX 11i v2 - Itanium Architecture. Create Database operation fails with SQL1366 error because of unsatisfied symbol in libIO77.so.1 August 23, 2005. HP-UX 11i v2 - PA-RISC Architecture. DB2 client running on HP-UX cannot connect to DB2 database running on AIX®. Known issues when running DB2 9 on HP-UX November 6, 2006. HP-UX 11i v2 - Itanium Architecture. Multi-threaded DB2 application, which is using unbound (MxN) threads, traps with SIGBUS. The problem is described in HP defect JAGag20888 and was fixed in the HP-UX 11i v3. The fix for HP-UX 11i v2 should be available in the middle of 2007. Known issues when running DB2 Universal Database™ (DB2 UDB) Version 8 on HP-UX November 15, 2005. HP-UX 11i v2 - Itanium Architecture. CREATE DATABASE fails with SQL1366N error. db2diag.log shows "Unsatisfied code symbol 'ots_verify' in load module '/usr/lib/hpux64/libIO77.so.1'". The problem was caused by HP patch PHSS_32231 and fixed by the patch PHSS_33424 August 23, 2005. HP-UX 11i v2 - PA-RISC Architecture. After upgrading HP-UX to 11i Update 2 (11.23.0409), DB2 client running on HP-UX hangs, attempting to connect to database on AIX. TCP clients advertise the incorrect window size if the server machine or operating system does not provide the window scaling option (see http://docs.hp.com/en/5990-8153/ch07s36.html) The problem is fixed by the patch PHNE_32606. Also, the connection problem could be fixed by executing the following HP-UX command: ndd -set /dev/tcp tcp_recv_hiwater_max 65535