SAP Note 1543745 - DB6: Using and troubleshooting ADMIN_MOVE_TABLE

Component : Database Administration with DB2 Universal Database - DB2 Universal Database for Unix / NT

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 :

1513862DB6: Table conversion using DB6CONV Version 5.01 or higher
1508151DB6: SQLADM authority needed for ADMIN_MOVE_TABLE
1430621DB6: Performance of VBDATA
1379362DB6: Support for partitioned tables in the ABAP DDIC
1314293DB6: Potential data loss when running Online Table Move
1256153DB6: Rollforward may fail "Page count incorrect during redo"
1168893DB6: Adjusting SAP BI compression to Online Table Move
1156597DB6: TRUNCATE TABLE on table with DELETE TRIGGER
1099936DB6: SQL0670N The row length of a table exceeds 4005 bytes
1039544DB6: Stored procedure for online table move
963602DB6: Moving tables online
817709DB6: DB6CONV: Complete version history
362325DB6: Table conversion using DB6CONV Version 4.10 or lower