SAP Knowledge Base Article - Preview

2938116 - DB6: deadlock/ lock-timeout at the swap phase during the table conversion using DB6CONV

Symptom

During the table conversion using DB6CONV, the SWAP phase got failed due to the deadlock/ lock-timeout as below:

20200517 135857 ONLINE CONVERSION: Start of Step 4 (SWAP)
20200517 135857 CALL SYSPROC.ADMIN_MOVE_TABLE( '<table schema>', '<table name>', '', '', 'SWAP' )
20200517 135923 ADMIN_MOVE_TABLE - SWAP step aborted.
20200517 135923 SQL0911N  The current transaction has been rolled back because of a
                  deadlock or timeout.  Reason code "2".  SQLSTATE=40001
20200517 135923 >>> Content (key,value) of SYSTOOLS.ADMIN_MOVE_TABLE

The previous COPY step was successfully completed.
And from T-cd:DBACockpit-> Diagnostics-> Lock-Wait Events, program/job accessing the corresponding table when the SWAP phase was failed can be found.


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

SWAP, deadlock, lock-timeout, SQL0911N, Reason code "2", Reason code "68" , KBA , BC-DB-DB6-DBA , Database Administration , 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.