IBM Support

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

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

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
16 March 2021