SAP Knowledge Base Article - Preview

2842639 - DB6: SQL0284N error during table REORG using temporary tablespace

Symptom

Reorg table using temporary tablespace fails

Reorg_Table:reorg table SAPABC."/ABCD/EFGH" index SAPABC."/ABCD/EFGH~0" allow no access DB6PM 000 S
Object : Method call GET_SNAPSHOT failed with return code = ADBC error DB6PM 001 S
Reorg_Table:RUNSTATS/REORGCHK failed for table SAPABC."/ABCD/EFGH" DB6PM 000 S
REASON=ADBC error DB6PM 000 S

In the dev_w*, you find the SQL0284N error.

B  ***LOG BY2=> sql error -284 performing OPC [dbds         398]
B  ***LOG BY0=> SQL0284N  The table was not created because the table space "SYSTOOLSTMPSPACE" following the clause "IN" is a "LARGE" table space.  SQLSTATE=42838 row=1 [dbds         398]
B  ***LOG BY1=> sql error -284 [dbacds       1843]


Read more...

Environment

  • SAP on IBM DB2 for Linux, UNIX, and Windows
  • Database is using automatic storage

Product

SAP ERP 6.0

Keywords

Reorg, SQL0284N, DB13, SYSTOOLSTMPSPACE , KBA , BC-DB-DB6-DBA , Database Administration , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-CCM , CCMS/Database Monitors , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.