Fixes are available
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