Solution : https://service.sap.com/sap/support/notes/1039544 (SAP Service marketplace login required)
Summary :
SAP Note details the use of ONLINE_TABLE_MOVE stored procedure for online table relocation across tablespaces within DB2 environments. Eligible from DB2 V9.7 onwards, it enables table moving during system operation while maintaining high data recoverability and minimizing downtimes. Prerequisites include specific DB2 versions, registry settings, and SYSPLAN accessibility configurations. Use DB6CONV for procedural calls to ensure functionality and minimize errors. For earlier DB2 versions or specific configuration setups, refer to additional SAP Notes provided for ensuring compatibility and addressing known issues like potential data inconsistencies, performance concerns, and DB2 limitations on certain table types.
Key words :
5 fp9 solved problems returns sql0969n / sql1188n / sql0408n error code, dpf systems stored procedure parametersthe stored procedure exists, avoid system downtimes perform regular commits, avoid high active log space requirement, workarounds removing online table move locks, solution related concepts incremental conversion, 5 fp6 solved problems secondary unique indexes, terms online table move stored procedure, java connect user sap<sapsid>db, removing online table move locks
Related Notes :
| 1543754 | Event: Trace during deactivation of event linkage |
| 1543745 | DB6: Using and troubleshooting ADMIN_MOVE_TABLE |
| 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 |
| 963602 | DB6: Moving tables online |
| 817709 | DB6: DB6CONV: Complete version history |
| 362325 | DB6: Table conversion using DB6CONV Version 4.10 or lower |