IBM Support

Known issues for DB2 on HP-UX

Flashes (Alerts)


Abstract

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

Content


Recommend Operating System Level


Three most recent additions.

  • August 14, 2011. HP-UX 11i v2, HP-UX 11i v3
    Veritas File System may corrupt DB2 SMS temporary files.
  • February 22, 2008. HP-UX 11i v3 - Itanium Architecture.
    Application traps, unloading shared library linked with DB2 client library (libdb2.so).
  • February 22, 2008. HP-UX 11i v2 - Itanium Architecture.
    Performance degradation with DB2 v9.5 on HP-UX with some workloads, compared to DB2 v9.1 under identical conditions.

Known issues when running DB2 9.5 and 9.7 on HP-UX
  • August 14, 2011. HP-UX 11i v2, HP-UX 11i v3
    Veritas File System may corrupt DB2 SMS temporary files.

    See the following technote: Veritas File System may corrupt DB2 SMS termporary files (1495849)
    http://www.ibm.com/support/docview.wss?uid=swg21495849
  • February 22, 2008. HP-UX 11i v2
    Performance degradation with DB2 v9.5 on HP-UX with some workloads, compared to DB2 Version 9.1 under identical conditions.

    The problem may be cause by the default timeshare scheduler (SCHED_HPUX) - defect JAGag39507 "Preemption behavior for TIMESHARED threads".
    One way to work around the issue is to set AGENTPRI. Another way is to enable the DB2 Workload Manager (WLM). In both cases DB2 will use a different HP-UX scheduler.

Known issues when running DB2 9 on HP-UX

  • August 14, 2011. HP-UX 11i v2, HP-UX 11i v3
    Veritas File System may corrupt DB2 SMS temporary files.
     
    See the section "Known issues when running DB2 9.5 and 9.7 on HP-UX" above for details.

  • February 22, 2008. HP-UX 11i v3 - Itanium Architecture.
    Application traps with FPE_INTDIV in BU_grow(), unloading shared library linked with DB2 client library (libdb2.so). This happens only if application and the shared library are built with cc (HP ANSI C compiler).

    The problem is fixed by the linker patch PHSS_37493.

  • 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. Patch PHCO_35997 fixes the problem for HP-UX 11i v2.

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

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Database","Platform":[{"code":"PF010","label":"HP-UX"}],"Version":"9.7;9.5;9.1;8.2;10.1;10.5","Edition":"Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 September 2022

UID

swg21257602