|
Problem IC74130
|
Status: Closed |
DIAGNOSTIC PROBES, -901 sqlcode AND possible INSTANCE CRASH WITH SEGMENTIONVIOLATION IN DB2AGNTP in DPF |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 V97fp5 or higher version. *
**************************************************************** |
| Local Fix: |
N/A. |
| available fix packs: |
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 |
The problem was fixed on DB2 V97fp5 or higher version. |
| Workaround |
N/A |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.01.2011
19.01.2012
19.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
