IBM Support

IT38790: THE ADMIN_MOVE_TABLE PROCEDURE MAY STUCK IN CANCEL PHASE.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • If ADMIN_MOVE_TABLE procedure fails at the very beginning of
    INIT phase then it may not be possible to cancel it.
    Any subsequent execution of the ADMIN_MOVE_TABLE fail with error
    SQL2105N e.g
    
    
    db2 "CALL
    SYSPROC.ADMIN_MOVE_TABLE('MYSCHEMA','MYTABLE','TEST','TEST','TES
    T','','','','','','CANCEL')"
    SQL2105N The ADMIN_MOVE_TABLE procedure could not be completed
    because a
    prerequisite for running the procedure was not satisfied. Reason
    code: "11".
    SQLSTATE=5UA0M
    
    To confirm one hit the issue described following command can be
    used:
    
    db2 "select
    char(TABSCHEMA,20),char(tabname,60),key,char(value,70) from
    systools.ADMIN_MOVE_TABLE"
    
    If the output does not have following two records then it is
    high probably this APAR
    
    1          2                              KEY               4
    
    --------------------
    ------------------------------------------------------------
    ..
    MYSCHEMA       MYTABLE                            INDEXSCHEMA
    
    MYSCHEMA       MYTABLE                            INDEXNAME
    
    ..
    

Local fix

  • One can execute following two inserts followed by
    ADMIN_MOVE_TABLE with CANCEL option
    
    Note: MYSCHEMA and MYTABLE need to be replaced with appropriate
    schema and table name for which ADMIN_MOVE_TABLE procedure
    failed
    
    db2 "insert into systools.ADMIN_MOVE_TABLE values ('MYSCHEMA',
    'MYTABLE', 'INDEXSCHEMA', '')"
    db2 "insert into systools.ADMIN_MOVE_TABLE values ('MYSCHEMA',
    'MYTABLE', 'INDEXNAME', '')"
    
    db2 "CALL
    SYSPROC.ADMIN_MOVE_TABLE('MYSCHEMA','MYTABLE','TEST','TEST','TES
    T','','','','','','CANCEL')"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ADMIN_MOVE_TABLE users                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 v11.5.7.1                                     *
    ****************************************************************
    

Problem conclusion

  • Fix included in Db2 v11.5.7.1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT38790

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-10-25

  • Closed date

    2021-12-09

  • Last modified date

    2021-12-09

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

    IT28390

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5"}]

Document Information

Modified date:
10 December 2021