SAP Knowledge Base Article - Preview

3265932 - SQLCODE = -646 TABLE CANNOT BE CREATED IN OR MOVED

Symptom

The SAP system is reporting the following errors in transaction code SM21:

=========================================
Database error -646 at EXE
> [IBM][CLI Driver][DB2] TABLE /BI0/0100000716 CANNOT BE
> CREATED IN OR MOVED TO SPECIFIED TABLE SPACE XSAP BECAUSE IT
> ALREADY CONTAINS A TABLE
Database error -646
=========================================

Same error is reported in the developer traces (dev_w):

=========================================
C Wed Nov 02 17:19:50 2022
C  *** ERROR => DB2 Call 'SQLExecDirectW' Error: conHdl = 00 SQLCODE = -646 : [IBM][CLI Driver][DB2] TABLE /BI0/0600000109 CANNOT BE
 [dbdb2cli.c   6403]
C  {root-id=36333632413638303633363241363830}_{conn-id=00000000000000000000000000000000}_0
C  DB2Trc: CREATE TABLE "/BI0/0600000109" ("SID" INTEGER NOT NULL WITH DEFAULT) IN "SY087710"."XSAP" CCSID UNIC\
C  DB2Trc: ODE;
B  ***LOG BY2=> sql error -646 performing EXE [dbds         578]
B  ***LOG BY0=> [IBM][CLI Driver][DB2] TABLE /BI0/0600000109 CANNOT BE CREATED IN OR MOVED TO SPECIFIED TABLE SPACE XSAP BECAUSE IT
B  ***LOG BY1=> sql error -646 [dbacds       1843]
A  Wed Nov 02 17:19:51 2022
A
A  ABAP Program SAPLRSDU_CORE_SQL_DB2                   .
A  Source LRSDU_CORE_SQL_DB2U04                    Line 33.
A  Error Code RAISE_EXCEPTION.
A  Module  $Id: //bas/722_STACK/src/krn/runt/abfunc.c#8 $ SAP.
A  Function ab_jfune Line 5971.
A  P1: DDIC_ERROR
=========================================


Read more...

Environment

  • Netweaver AS
  • Db2 z/OS v12 or later

Keywords

DB2 , -646 ,  DDIC_ERROR , XSAP  , KBA , BC-DB-DB2 , DB2 for z/OS , 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.