SAP Knowledge Base Article - Preview

2784141 - SQL error -904 RC=00D70043 and -204 during upgrade

Symptom

SAP upgrade fails with the following error:

---------------------------------------------------------------------------------------------------------------------------

4 ETW000 [ dev trc,00000] Fri Apr 19 10:32:54 2019
4 ETW000 [dbdb2cli.c ,00000] *** ERROR => DB2 Call 'SQLExecute' Error: conHdl = 00 SQLCODE = -904 : [IBM][CLI Driver][DB2] UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D70043
4 ETW000 [ dev trc,00000] DB2Trc: INSERT INTO "BTP_DL_KW_CTX" VALUES( ? , ? , ? ) ;
4 ETW000 [ dbtrtab ,00000] ***LOG BY4=>sql error -904 performing INS on table BTP_DL_KW_CTX
4 ETW000 [ dbtrtab ,00000] ***LOG BY0=>[IBM][CLI Driver][DB2] UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D70043
2EETW000 insert / update sequence failed due to an error in DBI.
2EETW000 maybe there's a concurrent process which inserted this table entry at the same time.
----------------------------------------------------------------------------------------------------------------------------

With the following Db2 reason code 00D70043 reported in the z/OS syslog and DB2MSTR.  The logging below references database A000XX8E, tablespace BTPXDLX.

----------------------------------------------------------------------------------------------------------------------------

10.32.54 STC06256 DSNP016I -DB2E DSNPCPS0 - CREATE FAILED FOR 556
556 A000XX8E.BTPXDLX.I0001.
556 RC=00D70043
556 CONNECTION-ID=DB2E, CORRELATION-ID=022.SUBSTK04,
556 LUW-ID=XXXXX.LUDB2E.D5FF3473DA30=0
----------------------------------------------------------------------------------------------------------------------------


Read more...

Environment

DB2 z/OS all versions

Product

SAP ERP 6.0 ; SAP NetWeaver all versions

Keywords

SQL0904N SQL0204N 00D70043 SUM SAPINST SPAM SAINT , KBA , BC-DB-DB2-INS , DB2 for z/OS - Installation , BC-DB-DB2 , DB2 for z/OS , BC-DB-DB2-UPG , DB2 for z/OS - Upgrade , 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.