IBM Support

IC68995: SYSPROC.ADMIN_MOVE_TABLE CRASHES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the server to DB2 v9.7 Fixpack 3.                    *
    ****************************************************************
    

Problem conclusion

  • This was first fixed in v9.7 Fixpack 3.  At minimum this fix
    should be
    applied to the server side.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68995

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-07

  • Closed date

    2010-11-11

  • Last modified date

    2010-11-11

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC69198

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

  • R970 PSN

       UP

  • R980 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 November 2010