SAP Knowledge Base Article - Preview

2474624 - SQL0911N The current transaction has been rolled back because of a deadlock or timeout - DB6

Symptom

  • Software Upgrade Manager (SUM) abnormally stopping in Phase MAIN_NEWBAS/PARCONV_UPG

              . . .
              3 ETP379X21:06:01: activating Nametab "BSIS":
              2 ETP000   >> Name of inactive nametab to read  : DDXTT
              2 ETP000   >> Format of inactive nametab to read: B
              3 ETP355Xstatements:
              3 ETP000 ALTER TABLE "BSIS"
              3 ETP000 ADD "KIDNO" SAPDB6CHAR(000030)
              3 ETP000 DEFAULT ' ' NOT NULL
              3 ETP000 ADD "INWARD_NO" SAPDB6CHAR(000030)
              3 ETP000 DEFAULT ' ' NOT NULL
              3 ETP000 ADD "INWARD_DT" SAPDB6CHAR(000008)
              3 ETP000 DEFAULT '00000000' NOT NULL
              3 ETP000
              2EETP345 22:06:03: Retcode 1: SQL-error "-911-SQL0911N  The current transaction has been rolled bac
              2EETP345 k because of a deadlock or timeout.  Reason code "68".  SQLSTATE=40001" in DDL statement f
              2EETP345 or "BSIS                          "
              2 ETP000                  DB-ROLLBACK()
              2EETP334 22:06:03: error in DDL, nametab for "BSIS" not activated

  • DB2 reporting -911 (SQL0911N) deadlock or timeout

             SQL-error -911-SQL0911N  The current transaction has been rolled back because of a deadlock or
                                       timeout.  Reason code 68.  SQLSTATE=40001 in DDL statement for BSIS


Read more...

Environment

  • DB2 LUW
  • SUM

Keywords

SQL0911N -911 911  PARCONV_UPG ALTER TABLE REORG TABLE DB6 DB2 LUW AIX The current transaction has been rolled back because of a deadlock or timeout , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.