Solution : https://service.sap.com/sap/support/notes/1513862 (SAP Service marketplace login required)
Summary :
The SAP Note discusses the use of the report DB6CONV, strictly applicable to the DB2 for Linux, UNIX, and Windows platforms, for relocating SAP database tables within tablespaces. As of version 5.01, numerous updates and features are introduced enhancing table handling capabilities such as Adaptive Data Compression, management of hidden columns, and more efficient LONGLOB conversions post-DB2 v9.7. Issues addressed include conversion challenges during SAP upgrades, where critical tables might be lost and need re-importing. Advanced handling of dependent views and role-based security adjustments for DB2 LUW Version 9.7 are also incorporated. It's recommended to always utilize the most current version for optimal functionality.
Key words :
db2 alter table <tabname> compress, role-based security concept, init maximum retries exceeded, swap maximum retries exceeded, relevant database monitoring tools, insert/update/delete accesses, replacing long-varchar fields, trigger individual replay calls, mass conversion previously corresponded, long varchar field
Related Notes :
| 1700631 | DB6: Using DB2 10.1 with SAP Applications |
| 1678401 | DB6: DB6CONV: Complete version history for V5.01 and higher |
| 1678159 | DB6: Role-Based Security Concept |
| 1574965 | DB6: Correction to distribution key check and repair |
| 1555903 | DB6: Supported DB2 Database Features |
| 1543745 | DB6: Using and troubleshooting ADMIN_MOVE_TABLE |
| 1524339 | DB6: SQL0301N after LONG to LOB conversion |
| 1523227 | DB6: Use of BLOCKNONLOGGED database configuration parameter |
| 1508151 | DB6: SQLADM authority needed for ADMIN_MOVE_TABLE |
| 1227165 | DB6: RENAME TABLESPACE in virtual tables |
| 1039544 | DB6: Stored procedure for online table move |
| 778784 | Inconsistencies between data class and database container |
| 515968 | DB6: Creating data classes and tablespaces in DBA cockpit |
| 486559 | DB2DART: Reducing high water mark |
| 362325 | DB6: Table conversion using DB6CONV Version 4.10 or lower |
| 46272 | Implement new data class in technical settings |