home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC73960 Status: Closed

DIAGNOSTIC PROBES, -901 sqlcode AND possible INSTANCE CRASH WITH
SEGMENTIONVIOLATION IN DB2AGNTP in DPF

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
Due to a timing issue (likely to be on AIX only) on DPF only,  a 
subagent process/thread may encounter some of the following 
issues: 
 
- diagnostic probes in the db2diag.log prefaced by "SHIPVAR" 
- files with an 'x' prefix in the db2dump directory 
- -901 sqlcode with token: "Conditional in post exit logic 
failed", e.g.: 
 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 37 
 sqlerrmc: Conditional in post exit logic failed 
 sqlerrp : SQLRA05E 
 
- instance crash due to a segmentation fault with the following 
functions in the stack: 
 
sqlra_find_ship_var 
sqlragsn_subagent 
sqlrr_subagent_router 
sqleSubRequestRouter 
sqleProcessSubRequest
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Due to a timing issue (likely to be on AIX only) on DPF      * 
* only,  a                                                     * 
* subagent process/thread may encounter some of the following  * 
* issues:                                                      * 
*                                                              * 
* - diagnostic probes in the db2diag.log prefaced by "SHIPVAR" * 
* - files with an 'x' prefix in the db2dump directory          * 
* - -901 sqlcode with token: "Conditional in post exit logic   * 
* failed", e.g.:                                               * 
*                                                              * 
* sqlcaid : SQLCA    sqlcabc: 136  sqlcode: -901  sqlerrml: 37 * 
* sqlerrmc: Conditional in post exit logic failed              * 
* sqlerrp : SQLRA05E                                           * 
*                                                              * 
* - instance crash due to a segmentation fault with the        * 
* following                                                    * 
* functions in the stack:                                      * 
*                                                              * 
* sqlra_find_ship_var                                          * 
* sqlragsn_subagent                                            * 
* sqlrr_subagent_router                                        * 
* sqleSubRequestRouter                                         * 
* sqleProcessSubRequest                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V91FP11 or higher.                     * 
****************************************************************
Local Fix:
N/A.
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
The problem was fixed on DB2 V91FP11 or higher.
Workaround
N/A
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC74128 IC74130 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.01.2011
19.01.2012
19.01.2012
Problem solved at the following versions (IBM BugInfos)
9.1.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList