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