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 ONE Support launchpad (Login required).

Search for additional results

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