Solution : https://service.sap.com/sap/support/notes/1099936 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the SQL0670 database error in DB2 for Linux, UNIX, and Windows (DB6) when operating a non-Unicode SAP system. The issue arises while creating or enhancing tables in a 4 KB page-sized tablespace. To resolve this, reduce the table width if possible for the existing tablespace. If a table delivered by SAP exceeds the width limit, alter the tablespace to a larger page size unless it involves UUTAB00, where a different approach involving customer support is recommended. Steps include identifying and possibly resizing tablespaces and buffer pools, executing commands as specific database users, and renaming tablespaces for clarity in operations. This note provides commands and conditions for different tablespace types (DMS, ADMS, ASTO), including creating new tablespaces and granting access. It advises simultaneous resizing of associated index tablespaces and contains special procedures for moving existing tables, dependent on the DB2 version.
Key words :
bufferpool <bufferpool_16k> extentsize 2 prefetchsize automatic dropped table recovery, tbsp_type 0 0 0 1tbsp_using_auto_storage 0 0 1 0tbsp_auto_resize_enabled 0 1 1 -=====================================================================description dms adms asto sms, '/db2/<sapsid>/sapdata<xx>/node0000', alter table add field, <nodegroup> pagesize 16k managed, description = admsthe create tablespace, database error sql0670 occurs, alter tablespace <tablespace> autoresize, renamed tablespace d3d#pool4kd, rename tablespace d3d#poold
Related Notes :
| 1543745 | DB6: Using and troubleshooting ADMIN_MOVE_TABLE |
| 1147174 | Table N2TRANSPORTBCSET Is Too Long |
| 1039544 | DB6: Stored procedure for online table move |