IBM Support

IC80632: IF ADMIN_MOVE_TABLE WITH CANCEL OPTION IS INTERRUPTED SUBSEQUENT CANCEL WILL FAIL WITH SQL2104N RC=8

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If a call to sysproc.admin_move_table with an action to CANCEL
    is interrupted via CTRL C, and the command is re-issued again,
    it would fail with SQL2104N Rc=8.  This fix would make sure
    that a subsequent admin_move_table does not fail with this
    error and proceeds.
    .
    for example:
    .
    db2 "call sysproc.admin_move_table('schema1','tab1',tab1_new',
    'keep,copy_with_indexes,'CANCEL')"
    .
    And you interrupt this action and re-issue again the table
    would be stuck in this phase and no reorg/loads etc. would
    be possible against the original table.
    

Local fix

  • Do not cancel the cancel phase and let it complete.  It may
    take a bit of time for it to complete depending on how large
    the table is in this case.
    .
    If this happens and the state of the table is stuck in this
    phase, no subsequent loads/reorgs would be possible on the origi
    nal table and you would need to recreate the original table
    again.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 6.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80632

  • 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

    2012-01-03

  • Closed date

    2012-06-19

  • Last modified date

    2012-06-19

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

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

    IC84412

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80632

Modified date: 19 June 2012