Solution : https://service.sap.com/sap/support/notes/362325 (SAP Service marketplace login required)
Summary :
SAP Note describes the application of the DB6CONV report for table conversions within DB2 UDB for LUW databases up to and including Version 4.10. The note outlines usage procedures, offers caution regarding Unicode systems, identifies prerequisites such as DB2 and SAP Basis versions, and provides a downloadable transport for implementation in SAP systems. Key issues addressed include ONLINE_TABLE_MOVE version requirements to prevent data loss, the necessity for preserving data through upgrades, troubleshooting status discrepancies in conversions, and space requirements for offline conversions utilizing the TEMP tablespace. It recommends carrying out offline conversions with LOGGED setting to avoid unexpected space shortages and highlights necessary preparations for offline conversions affecting system tables and dictionary activities.
Key words :
/db2/<sid>/db2<sid>/nodexxx/sqlxxx, update rsdodso set odsadatcls = 'ztnew', update rsdodso set odsmdatcls = 'ztnew', target table + alter table add field, update rsts set psadatcls = 'ztnew', db2 udb v7for online table conversions, update rsdcube set cubedatcls = 'ztnew', update rsdcube set dimedatcls = 'ztnew', update rsdcube set aggrdatcls = 'ztnew', page size-dependent size limit
Related Notes :
| 1543745 | DB6: Using and troubleshooting ADMIN_MOVE_TABLE |
| 1513862 | DB6: Table conversion using DB6CONV Version 5.01 or higher |
| 1314293 | DB6: Potential data loss when running Online Table Move |
| 1267419 | TABLE CORRUPTION WHEN USING LOAD + MDC + ROW Compression |
| 1256153 | DB6: Rollforward may fail "Page count incorrect during redo" |
| 1039544 | DB6: Stored procedure for online table move |
| 963602 | DB6: Moving tables online |
| 844371 | Preparations and adjustments when importing SP3 |
| 817709 | DB6: DB6CONV: Complete version history |
| 778784 | Inconsistencies between data class and database container |
| 737914 | DB6: CLI LOAD for INSERT ... FULLSELECT |
| 648432 | DB6: New function modules for hash partitioning |
| 525988 | Upgrade problems in the fact table views /BIC/V<Infocube>F |
| 515968 | DB6: Creating data classes and tablespaces in DBA cockpit |
| 436717 | DB6: Introduce DDL autocommit |
| 147634 | DB6: Tips and tricks for creating DB2 tablespaces |
| 46272 | Implement new data class in technical settings |