|
Problem IC62984
|
Status: Closed |
UPGRADE FROM V8 TO V97 ON SUNAMD PLATFORM CAUSES INSTANCE TO SUSPEND WITH SIGNAL #11 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Database upgrade would fail when upgrading a Version 8 database
on Sunamd servers. This problem is platform specific.
The following gives an example of the types of db2diag.log
messages seen during the failed upgrade attempts:
2009-08-21-07.55.05.555119-240 I6369252E480 LEVEL: Warning
PID : 15522 TID : 17 PROC : db2sysc
2
INSTANCE: svtdbm3 NODE : 002 DB : DMFRC1
APPHDL : 2-55 APPID: *N2.svtdbm3.090821115222
AUTHID : SVTDBM3
EDUID : 17 EDUNAME: db2agent (DMFRC1 ) 2
FUNCTION: DB2 UDB, catalog migration, sqlrlm_catalog_migrate,
probe:4917
DATA #1 : <preformatted>
Begin migrating catalog table: SYSTABLES
2009-08-21-07.55.05.872022-240 I6369733E561 LEVEL: Error
PID : 15522 TID : 17 PROC : db2sysc
2
INSTANCE: svtdbm3 NODE : 002 DB : DMFRC1
APPHDL : 2-55 APPID: *N2.svtdbm3.090821115222
AUTHID : SVTDBM3
EDUID : 17 EDUNAME: db2agent (DMFRC1 ) 2
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0xFFFFFD7FEDC0991E : 0200
..
...
2009-08-21-07.55.13.302479-240 E6441453E670 LEVEL: Severe
PID : 15522 TID : 17 PROC : db2sysc
2
INSTANCE: svtdbm3 NODE : 002 DB : DMFRC1
PID : 15522 TID : 17 PROC : db2sysc
2
INSTANCE: svtdbm3 NODE : 002 DB : DMFRC1
APPHDL : 2-55 APPID: *N2.svtdbm3.090821115222
AUTHID : SVTDBM3
EDUID : 17 EDUNAME: db2agent (DMFRC1 ) 2
FUNCTION: DB2 UDB, oper system services, sqloSleepInstance,
probe:38
MESSAGE : ADM0504C An unexpected internal processing error has
occurred. All
DB2 processes associated with this instance have been
suspended.
Diagnostic information has been recorded. Contact IBM
Support for
further assistance.
The following shows a sample callstack:
-----FRAME------ ------FUNCTION + OFFSET------
FFFFFD7FF4940560 strlen + 0x0020
(/lib/amd64/libc.so.1)
FFFFFD7FFA04C091
__1cTsqlrlm_8to9_tablepd6FpnIsqeAgent_pcpnKSQdDLD_VALUE_pnIsqlr_
tid_pnKv8sqlrg_pd_bpnQv9sqlrg_2pt_name_p2pI_i_
+ 0x1ba1
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF9F5CBEB
__1cVsqlrlm_8to9_systables6FpnIsqeAgent_HpnKSQdDLD_VALUE_pnIsqlr
_tid_pcp6plpb9A_i_
+ 0x032b
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FFA03F966
__1cTsqlrlm_catalogFixup6FpnIsqlrr_cb_HllLnRsqlrlm_catChanges_pc
nIsqlr_tid_p4pnSsqlrlm_runstatsCmd__i_
+ 0x15a6
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF9DC5208
__1cWsqlrlm_catalog_migrate6FpnIsqeAgent_hpnFsqlca__i_ + 0x28c8
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7603C82 __1cIsqlefmig6FpcpnISQdDLE_BWA_pnFsqlca__i_ +
0x0592
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF76066B0
__1cIsqlemigr6FpnISQdDLE_BWA_pnOdb2UCinterface__i_ + 0x1890
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF76A1598
__1cOsqeApplicationbAInheritAppCoordPITNodeInfo6MpnQSQdDLE_CLIEN
T_INFO__v_
+ 0x0228
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF769BE50
__1cOsqeApplicationNAppLocalStart6MpnOdb2UCinterface__i_ +
0x0280
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7847024 __1cLsqlelostWrp6FpnOdb2UCinterface__i_ +
0x0054
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7842594 __1cOsqleUCengnInit6FpnOdb2UCinterface_H_i_ +
0x02d4
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7843D78 sqleUCagentConnect + 0x0f38
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7AE5D33
__1cSsqljsConnectAttach6FpnNsqljsDrdaAsCb_pnOdb2UCinterface__i_
+ 0x0393
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7A730D7
__1cQsqljs_ddm_accsec6FpnOdb2UCinterface_pnNsqljDDMObject__i_ +
0x0097
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7A66CD4
__1cRsqljsParseConnect6FpnNsqljsDrdaAsCb_pnNsqljDDMObject_pnOdb2
UCinterface__i_
+ 0x0084
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7A6802D
__1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface__i_ + 0x013d
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7A5C49A
__1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_
b_i_
+ 0x081a
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7A5DBBA
__1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_
b_i_
+ 0x1f3a
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7A59B0D
__1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_ + 0x101d
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF7A58C79
__1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_ + 0x0189
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF767E4A9 __1cIsqeAgentGRunEDU6M_v_ + 0x02a9
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FFAC0512A __1cJsqzEDUObjJEDUDriver6M_v_ + 0x01ea
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FFAC039EC __1cKsqlzRunEDU6FpcI_v_ + 0x000c
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF91C04BE sqloEDUEntry + 0x02ce
(/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
FFFFFD7FF49BFD7B _thr_slot_offset + 0x031b
(/lib/amd64/libc.so.1)
FFFFFD7FF49BFFB0 _thr_slot_offset + 0x0550
(/lib/amd64/libc.so.1) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Only on Sun AMD machines *
****************************************************************
* PROBLEM DESCRIPTION: *
* Database upgrade would fail when upgrading a Version 8 *
* database on Sunamd servers. This problem is platform *
* specific. *
* *
* The following gives an example of the types of db2diag.log *
* messages seen during the failed upgrade attempts: *
* *
* 2009-08-21-07.55.05.555119-240 I6369252E480 LEVEL: *
* Warning *
* PID : 15522 TID : 17 PROC : *
* db2sysc 2 *
* INSTANCE: svtdbm3 NODE : 002 DB : *
* DMFRC1 *
* APPHDL : 2-55 APPID: *
* *N2.svtdbm3.090821115222 *
* AUTHID : SVTDBM3 *
* EDUID : 17 EDUNAME: db2agent (DMFRC1 ) *
* 2 *
* FUNCTION: DB2 UDB, catalog migration, *
* sqlrlm_catalog_migrate, probe:4917 *
* DATA #1 : <preformatted> *
* Begin migrating catalog table: SYSTABLES *
* *
* 2009-08-21-07.55.05.872022-240 I6369733E561 LEVEL: *
* Error *
* PID : 15522 TID : 17 PROC : *
* db2sysc 2 *
* INSTANCE: svtdbm3 NODE : 002 DB : *
* DMFRC1 *
* APPHDL : 2-55 APPID: *
* *N2.svtdbm3.090821115222 *
* AUTHID : SVTDBM3 *
* EDUID : 17 EDUNAME: db2agent (DMFRC1 ) *
* 2 *
* FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, *
* probe:1 *
* MESSAGE : Error in agent servicing application with *
* coor_node: *
* DATA #1 : Hexdump, 2 bytes *
* 0xFFFFFD7FEDC0991E : 0200 *
* .. *
* *
* ... *
* *
* 2009-08-21-07.55.13.302479-240 E6441453E670 LEVEL: *
* Severe *
* PID : 15522 TID : 17 PROC : *
* db2sysc 2 *
* INSTANCE: svtdbm3 NODE : 002 DB : *
* DMFRC1 *
* PID : 15522 TID : 17 PROC : *
* db2sysc 2 *
* INSTANCE: svtdbm3 NODE : 002 DB : *
* DMFRC1 *
* APPHDL : 2-55 APPID: *
* *N2.svtdbm3.090821115222 *
* AUTHID : SVTDBM3 *
* EDUID : 17 EDUNAME: db2agent (DMFRC1 ) *
* 2 *
* FUNCTION: DB2 UDB, oper system services, sqloSleepInstance, *
* probe:38 *
* MESSAGE : ADM0504C An unexpected internal processing error *
* has occurred. All *
* DB2 processes associated with this instance have *
* been suspended. *
* Diagnostic information has been recorded. Contact *
* IBM Support for *
* further assistance. *
* *
* The following shows a sample callstack: *
* -----FRAME------ ------FUNCTION + OFFSET------ *
* FFFFFD7FF4940560 strlen + 0x0020 *
* (/lib/amd64/libc.so.1) *
* FFFFFD7FFA04C091 *
* __1cTsqlrlm_8to9_tablepd6FpnIsqeAgent_pcpnKSQdDLD_VALUE_pnIsql
* + 0x1ba1 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF9F5CBEB *
* __1cVsqlrlm_8to9_systables6FpnIsqeAgent_HpnKSQdDLD_VALUE_pnIsq
* + 0x032b *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FFA03F966 *
* __1cTsqlrlm_catalogFixup6FpnIsqlrr_cb_HllLnRsqlrlm_catChanges_
* + 0x15a6 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF9DC5208 *
* __1cWsqlrlm_catalog_migrate6FpnIsqeAgent_hpnFsqlca__i_ + *
* 0x28c8 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7603C82 __1cIsqlefmig6FpcpnISQdDLE_BWA_pnFsqlca__i_ *
* + 0x0592 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF76066B0 *
* __1cIsqlemigr6FpnISQdDLE_BWA_pnOdb2UCinterface__i_ + 0x1890 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF76A1598 *
* __1cOsqeApplicationbAInheritAppCoordPITNodeInfo6MpnQSQdDLE_CLI
* + 0x0228 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF769BE50 *
* __1cOsqeApplicationNAppLocalStart6MpnOdb2UCinterface__i_ + *
* 0x0280 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7847024 __1cLsqlelostWrp6FpnOdb2UCinterface__i_ + *
* 0x0054 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7842594 __1cOsqleUCengnInit6FpnOdb2UCinterface_H_i_ *
* + 0x02d4 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7843D78 sqleUCagentConnect + 0x0f38 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7AE5D33 *
* __1cSsqljsConnectAttach6FpnNsqljsDrdaAsCb_pnOdb2UCinterface__i
* + 0x0393 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7A730D7 *
* __1cQsqljs_ddm_accsec6FpnOdb2UCinterface_pnNsqljDDMObject__i_
* + 0x0097 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7A66CD4 *
* __1cRsqljsParseConnect6FpnNsqljsDrdaAsCb_pnNsqljDDMObject_pnOd
* + 0x0084 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7A6802D *
* __1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface__i_ + *
* 0x013d *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7A5C49A *
* __1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterfac
* + 0x081a *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7A5DBBA *
* __1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterfac
* + 0x1f3a *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7A59B0D *
* __1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_ + 0x101d *
* *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF7A58C79 *
* __1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_ + 0x0189 *
* *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF767E4A9 __1cIsqeAgentGRunEDU6M_v_ + 0x02a9 *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FFAC0512A __1cJsqzEDUObjJEDUDriver6M_v_ + 0x01ea *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FFAC039EC __1cKsqlzRunEDU6FpcI_v_ + 0x000c *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF91C04BE sqloEDUEntry + 0x02ce *
* *
* (/view/db2_v97fp1_sunamd64_n090817/vbs/engn/lib/libdb2e.so.1)
* FFFFFD7FF49BFD7B _thr_slot_offset + 0x031b *
* (/lib/amd64/libc.so.1) *
* FFFFFD7FF49BFFB0 _thr_slot_offset + 0x0550 *
* (/lib/amd64/libc.so.1) *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 fix pack 1. *
**************************************************************** |
| Local Fix: |
|
| 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 |
The problem is fixed in DB2 Version 9.7 fix pack 1 and all
subsequent fix packs. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.09.2009
04.01.2010
04.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
