|
Problem IC64084
|
Status: Closed |
GETTING DATABASE CONFIGURATION USING 9.5 CLIENT FROM DOWNLEVEL SERVERS CAN CAUSE THE SERVER INSTANCE TO TRAP OR GET SQL5060N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When you are using v9.5 client against any of the downlevel
servers to get database configuration, without any connection to
the database or attachment to the instance, the server instance
will crash. The trap file on the server instance will have the
stack as below. Please note that on v9.1 server you will
receive error SQL5060N and may not see the crash.
.
<StackTrace>
-------Frame------ ------Function + Offset------
0xD794BC28 sqlfGetDbCfg__FP8sqledbcbP6db2CfgiP5sqlca + 0x364
0xD7933090 sqlfxdb_backend__FP10sqle_db2ra + 0x18C
0xD7934150 sqlesrvr__FP7UCintfc + 0x1AC
0xD7935AF0 sqleMappingFnServer__FP5sqldaP5sqlca + 0x6B0
0xD7936AA4
sqlerKnownProcedure__FlPcPlP5sqldaT4P13sqlerFmpTableP13sqle_agen
t_cbP5sqlca + 0x184
0xD792B53C sqlerCallDL__FP7UCintfcP9UCstpInfo + 0x8B0
0xD7335B10 sqljs_ddm_excsqlstt__FP7UCintfcP14sqljsDDMObject +
0x480
0xD7327074
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP7UCint
fc + 0x58
0xD7326F14 sqljsParse__FP13sqljsDrdaAsCbP7UCintfc + 0x250
0xD732B950 sqljsSqlam__FP7UCintfcP13sqle_agent_cbb + 0x8C
0xD732BEF4 sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle +
0x88
0xD732BD98 sqljsDrdaAsInnerDriver__FP17sqlcc_init_structb + 0xB0
0xD732BB48 sqljsDrdaAsDriver__FP17sqlcc_init_struct + 0x84
0xD7401B40 sqleRunAgent__FPcUl + 0x260
0xD719E1F4 sqloCreateEDU__FPFPcUl_vPcUlP13SQLO_EDU_INFOPl +
0x1A8
0xD719DDB4 sqloRunGDS__Fv + 0x78
0xD719E844 sqloInitEDUServices + 0x14C
0xD71A21E0 sqloRunInstance + 0x4E4
0x10002910 DB2main + 0x888
0x100035A0 main + 0xC
</StackTrace>
.
The db2diag.log will show few entries as following:
.
2009-03-26-15.43.52.066334-300 I4379574C435 LEVEL: Error
PID : 3702874 TID : 1 PROC :
db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfGetDbCfg, probe:999
MESSAGE : SQL5060: sqlfGetDbCfg tok =
DATA #1 : Hexdump, 4 bytes
0x2004DF20 : 0000 0000 ....
. |
| Problem Summary: |
When you are using v9.5 client against any of the downlevel
servers to get database configuration, without any connection to
the database or attachment to the instance, the server instance
will crash. The trap file on the server instance will have the
stack as below. Please note that on v9.1 server you will
receive error SQL5060N and may not see the crash.
.
<StackTrace>
-------Frame------ ------Function + Offset------
0xD794BC28 sqlfGetDbCfg__FP8sqledbcbP6db2CfgiP5sqlca + 0x364
0xD7933090 sqlfxdb_backend__FP10sqle_db2ra + 0x18C
0xD7934150 sqlesrvr__FP7UCintfc + 0x1AC
0xD7935AF0 sqleMappingFnServer__FP5sqldaP5sqlca + 0x6B0
0xD7936AA4
sqlerKnownProcedure__FlPcPlP5sqldaT4P13sqlerFmpTableP13sqle_agen
t_cbP5sqlca + 0x184
0xD792B53C sqlerCallDL__FP7UCintfcP9UCstpInfo + 0x8B0
0xD7335B10 sqljs_ddm_excsqlstt__FP7UCintfcP14sqljsDDMObject +
0x480
0xD7327074
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP7UCint
fc + 0x58
0xD7326F14 sqljsParse__FP13sqljsDrdaAsCbP7UCintfc + 0x250
0xD732B950 sqljsSqlam__FP7UCintfcP13sqle_agent_cbb + 0x8C
0xD732BEF4 sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle +
0x88
0xD732BD98 sqljsDrdaAsInnerDriver__FP17sqlcc_init_structb + 0xB0
0xD732BB48 sqljsDrdaAsDriver__FP17sqlcc_init_struct + 0x84
0xD7401B40 sqleRunAgent__FPcUl + 0x260
0xD719E1F4 sqloCreateEDU__FPFPcUl_vPcUlP13SQLO_EDU_INFOPl +
0x1A8
0xD719DDB4 sqloRunGDS__Fv + 0x78
0xD719E844 sqloInitEDUServices + 0x14C
0xD71A21E0 sqloRunInstance + 0x4E4
0x10002910 DB2main + 0x888
0x100035A0 main + 0xC
</StackTrace>
.
The db2diag.log will show few entries as following:
.
2009-03-26-15.43.52.066334-300 I4379574C435 LEVEL: Error
PID : 3702874 TID : 1 PROC :
db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfGetDbCfg, probe:999
MESSAGE : SQL5060: sqlfGetDbCfg tok =
DATA #1 : Hexdump, 4 bytes
0x2004DF20 : 0000 0000 .... |
| Local Fix: |
Avoid getting database configuration using v9.5 client from a
downlevel server without connection to the database or
attachment to the instance. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows
|
| Solution |
defect -> wsdbu00562731
fixed in -> V9.5 + FP5
Module -> engn_sqf |
| Workaround |
Avoid getting database configuration using v9.5 client from a
downlevel server without connection to the database or
attachment to the instance. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2009
01.03.2010
01.03.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
