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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.