DB2 FOR LUW / DB2FORLUW / 970 - DB2

When compiling a DB2 CLI application or routine it is important 
to include both the -mt and -lunwind compiler and linker options 
on the HPUX platform to prevent an error from occurring. 
 
Without the -mt option, the application will compile, but during 
runtime you could get the following error message: 
 
SQL1042C  An unexpected system error occurred. 
 
 
Without the -lunwind option, the application may fail to 
compile, producing the following compile/link errors/warnings: 
 
ld: (Warning) Unsatisfied symbol "uwx_register_callbacks" in 
file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "_Unwind_SetIP" in file 
/usr/lib/hpux64/libCsup.so.1 
ld: (Warning) Unsatisfied symbol "_Unwind_SetGR" in file 
/usr/lib/hpux64/libCsup.so.1 
ld: (Warning) Unsatisfied symbol "_Unwind_GetIP" in file 
/usr/lib/hpux64/libCsup.so.1 
ld: (Warning) Unsatisfied symbol "_Unwind_GetGR" in file 
/usr/lib/hpux64/libCsup.so.1 
ld: (Warning) Unsatisfied symbol "uwx_self_lookupip" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "_Unwind_RaiseException" in 
file 
/usr/lib/hpux64/libCsup.so.1 
ld: (Warning) Unsatisfied symbol "_Unwind_GetRegionStart" in 
file 
/usr/lib/hpux64/libCsup.so.1 
ld: (Warning) Unsatisfied symbol "uwx_free" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "uwx_init" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "uwx_get_reg" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "_Unwind_Resume" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "uwx_step" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "uwx_self_free_info" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "uwx_self_init_info" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "uwx_self_init_context" in file 
.. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol 
"_Unwind_GetLanguageSpecificData" in 
file /usr/lib/hpux64/libCsup.so.1 
ld: (Warning) Unsatisfied symbol "uwx_self_copyin" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "_UNW_STACK_TRACE" in file .. 
/clidriver/lib/libdb2.so 
ld: (Warning) Unsatisfied symbol "uwx_self_do_context_frame" in 
file .. 
/clidriver/lib/libdb2.so 
20 warnings. 
 
 
 
These options are going to be added to the DB2 documentation as 
well as required options for compiling DB2 CLI applications and 
routines on HPUX.  This APAR address the sample build scripts 
(bldapp, bldrtn) that are included with the sqllib/samples 
directory when DB2 is installed so that they use these options 
as well on the HPUX platform.

**************************************************************** 
* USERS AFFECTED:                                              * 
* HPUX users                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fixpak 7                         * 
****************************************************************

Manually modify the DB2 sample build scripts to include both the 
-mt and -lunwind compile/linker options.

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7, Fixpak 7

see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC85977 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

17.08.2012
05.11.2012
05.11.2012

9.7.