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 IC69198 Status: Closed

SYSPROC.ADMIN_MOVE_TABLE CRASHES

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
The stored procedure SYSPROC.ADMIN_MOVE_TABLE crashes with a 
signal #11 with the following 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 to v9.7 Fixpack 4.                                   * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux

Solution
First fixed in v9.8 Fixpack 4. At minimum this fix should be 
applied to the server side.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.06.2010
22.08.2011
22.08.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP4,
9.8.FP4
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.4 FixList