SAP Knowledge Base Article - Preview

3267668 - ADMIN_MOVE_TABLE aborts with SQL0911N rc=2 deadlock

Symptom

ADMIN_MOVE_TABLE aborts with SQL0911N rc=2 deadlock.

==============================================================
20221103 021455 ADMIN_MOVE_TABLE - SWAP step aborted.
20221103 021455 SQL0911N  The current transaction has been rolled back because of a
                deadlock or timeout.  Reason code "2".  SQLSTATE=40001
20221103 021455 >>> Content (key,value) of SYSTOOLS.ADMIN_MOVE_TABLE
==============================================================


Read more...

Environment

  • IBM DB2 LUW (DB6) any release

Keywords

admin_move_table , swap , db6conv , sql0911n , lock , deadlock , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.