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.