Solution : https://service.sap.com/sap/support/notes/1543745 (SAP Service marketplace login required)
Summary :
This SAP Note details the ADMIN_MOVE_TABLE stored procedure for online table migration in SAP systems running DB2 LUW, offering guidelines on its implementation and troubleshooting. Key topics covered include requisite authority levels, potential inconsistencies due to untriggered deletion commands, and data type preservation across tablespace moves. Additionally, it addresses permissions, performance implications of multiple table moves, preferred tools such as report DB6CONV, and links to related documentation. This guide is crucial for maintaining system continuity and data integrity during migrations, with special attention to the procedure's potential space and speed limitations.
Key words :
customer component bc-db-db6-dba database administration, unix / nt priority recommendations / additional info category, amt_<tabschema>_<tabname>_<operation>_trc, components bc-db-db6 db2 universal database, avoid system downtime perform regular commits, collect sampled detailed statistics clause, removing online table move semaphore locks, achieve 'table level recovery' compress, terms online table move stored procedure, removing online table move locks
Related Notes :
1513862 | DB6: Table conversion using DB6CONV Version 5.01 or higher |
1508151 | DB6: SQLADM authority needed for ADMIN_MOVE_TABLE |
1430621 | DB6: Performance of VBDATA |
1379362 | DB6: Support for partitioned tables in the ABAP DDIC |
1314293 | DB6: Potential data loss when running Online Table Move |
1256153 | DB6: Rollforward may fail "Page count incorrect during redo" |
1168893 | DB6: Adjusting SAP BI compression to Online Table Move |
1156597 | DB6: TRUNCATE TABLE on table with DELETE TRIGGER |
1099936 | DB6: SQL0670N The row length of a table exceeds 4005 bytes |
1039544 | DB6: Stored procedure for online table move |
963602 | DB6: Moving tables online |
817709 | DB6: DB6CONV: Complete version history |
362325 | DB6: Table conversion using DB6CONV Version 4.10 or lower |