DB2 - Problem description
Problem IC68995 | Status: Closed |
SYSPROC.ADMIN_MOVE_TABLE CRASHES | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Calling the stored procedure SYSPROC.ADMIN_MOVE_TABLE to move a table returns SQL1131 Stored procedure process has been terminated abnormally. The trap file for the db2fmp process will indicate there was a segmentation fault (signal #11) and contain the following function stack: <StackTrace> ##### Object: /view/db2_v97fp1_sun64_special_23457_special_23487/vbs/db2tools/ lib/SPARC_64/db2dbroutext __1cDOtmPstringArrayFree6Fppcpi_v_(0xffffffff683f8a58,0xffffffff 683f8a54,0x0,0xffffffff77d03480,0x0,0x1c600000) + 0x58 __1cDOtmJcopyTable6Mpkc22222pnFsqlca__v_(0x100176d30,0x100177160 ,0xffffffff683ffbc0,0x1c600000,0x100177158,0xffffffff683faa00) + 0x4184 __1cDOtmEcopy6MpnFsqlca__v_(0x100176d30,0xffffffff683ffbc0,0x200 0,0x0,0xffffffffffffffff,0x100176fea) + 0x500 admin_move_table(0xffffffff6790f980,0xffffffff6790fa18,0x0,0x1c6 00000,0xffffffff73a1ba08,0xffffffffffffffff) + 0x134c admin_move_table1(0x0,0x20e348,0xffffffff73a1ba08,0x0,0x0,0xffff ffff6790fc78) + 0xd4 ##### Object: /view/db2_v97fp1_sun64_special_23457_special_23487/vbs/engn/lib/ libdb2.so.1 sqloInvokeFnArgs(0xffffffff7380d67c,0xffffffff6792fd50,0xfffffff f6792fc88,0x0,0x0,0xffffffff6792fbf0) + 0x118 sqlerDyload(0xffffffff73b01480,0xffffffff683ffcc8,0xa,0xffffffff 683ffbc0,0xb,0xffffffff7f0534c8) + 0x8e0 sqlerDyload(0xffffffff73b01480,0xffffffff683ffcc8,0x20000,0xffff ffff7de098d0,0x0,0xffffffff683ffbc0) + 0x16c sqlerFmpListener(0xffffffff73b01a70,0x19200000,0xffffffff73b0064 0,0x2,0x0,0x1) + 0x1544 __1cWsqlerWorkerThreadEntry6Fpv_0_(0xffffffff77d132c0,0xffffffff 77e11ca0,0x1,0x0,0xffffffff7f0534c8,0xffffffff7e8e3b78) + 0x240 ##### Object: /usr/lib/sparcv9/libthread.so.1 _resume_ret(0x0,0x0,0x0,0x0,0x0,0x0) + 0x2dc </StackTrace> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See ERROR DESCRIPTION. * **************************************************************** * RECOMMENDATION: * * Upgrade the server to DB2 v9.7 Fixpack 3. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
This was first fixed in v9.7 Fixpack 3. At minimum this fix should be applied to the server side. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC69198 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.06.2010 11.11.2010 11.11.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP3 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.3 | |
9.7.0.3 |