Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC63080 Status: Closed

DB2 MAY TRAP OR HANG WHEN THE TRACEREFRESHINTERVAL OR
QUERYTIMEINTERVAL KEYWORD IS USED WITH A TRUSTED ROUTINE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When TRACEREFRESHINTERVAL OR QUERYTIMEINTERVAL is set and a 
trusted routine is called it may cause the db2 instance to hang 
or crash. 
 
The following stack is an example or what has been observed: 
 
0x09000000062a01a0 
SqloMemoryProtectionEDU::enterSignalHandler()(??) + 0x20 
<signal> 
0x09000000062a01a0 
SqloMemoryProtectionEDU::enterSignalHandler()(??) + 0x20 
<signal> 
0x09000000045a4b40  fdprpro_symbol_fixer_5__fdpr_57(??) + 0x12c 
0x09000000045a4850  MemGetThrd__fdpr_1(??, ??, ??) + 0x20 
0x09000000041a5388  sqloMemFreePools(0x9001000a0c4f350, 0x0) + 
0xac 
0x0900000004107afc  sqloExitAppThread() + 0x34 
0x0900000004194964  CLI_cpTraceRefreshMon(??) + 0xbc 
0x09000000003594f4  _pthread_body(??) + 0xdc
Problem Summary:
Users Affected: Any using the TRACEREFRESHINTERVAL OR 
 
QUERYTIMEINTERVAL KEYWORD 
Problem Description: DB2 MAY TRAP OR HANG WHEN THE 
TRACEREFRESHINTERVAL OR QUERYTIMEINTERVAL KEYWORD IS USED WITH A 
TRUSTED ROUTINE 
Problem Summary: see above
Local Fix:
Unset the keyword to avoid this issue.
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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

Solution
Problem was first fixed in Version 9.7 FixPak 3
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.09.2009
07.10.2010
07.10.2010
Problem solved at the following versions (IBM BugInfos)
9.7.
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.