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.
SAP Knowledge Base Article - Preview