IBM Support

IT31887: ADMIN_MOVE_TABLE: SQL2103N REASON CODE 17, DIFFERENCE OF PCTFREEVALUE OF SYSTEM GENERATED INDEXES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The stored procedure SYSPROC.ADMIN_MOVE_TABLE move operation
    might terminate with:
    
    SQL2103N The ADMIN_MOVE_TABLE procedure could not be completed
    because some
    aspect of either the source table or target table is not
    supported by the
    ADMIN_MOVE_TABLE procedure. Reason code: "17". SQLSTATE=5UA0M
    
    SYSPROC.ADMIN_MOVE_TABLE terminates in phase "SWAP" while
    comparing source and target index flags.
    
    The primary key (system generated) of the source table was
    created with PCTFREE=10.
    SYSPROC.ADMIN_MOVE_TABLE creates the primary key (system
    generated) of the target table with PCTFREE=0 according to the
    current setting of registry variable DB2_INDEX_PCTFREE_DEFAULT=0
    (with DB2_WORKLOAD=SAP)
    
    Comparing those two PCTFREE values leads to the error and
    termination mentioned above.
    PCTFREE cannot be specified for system generated indexes.
    

Local fix

  • use FORCE option of SYSPROC.ADMIN_MOVE_TABLE:
    CALL ADMIN_MOVE_TABLE('<schema>', '<tabname>', '', '', '', '',
    '', '', '', 'FORCE', 'MOVE');
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to the latest fix pack.                              *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 11.5 mod pack 4 fix
    pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31887

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-18

  • Closed date

    2021-03-15

  • Last modified date

    2021-03-15

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

  • 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

  • RB10 PSN

       UP

[{"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.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022