DB6 Dead lock between DFKKOP and STXH for transaction FPVB

[jespergk]

After changing the Database from DB2 to DB6 we are experiencing consisting dead locks when running transaction FPVB (Dunning activity run).

It occured seldomly on DB6, but now it is almost every day for specific clients (multi-client setup).

In DBACOCKPIT it states that the dead lock happens between DFKKOP and STXH and the dump happens in FM FKK_SET_OPSTA_FROM_FKKMAZE in when an update is performed:

UPDATE dfkkop SET   opsta = u_dfkkop-opsta
                    WHERE opbel = u_dfkkop-opbel AND
                          opupw = u_dfkkop-opupw AND
                          opupk = u_dfkkop-opupk AND
                          opupz = u_dfkkop-opupz AND
                          opsta < u_dfkkop-opsta.

We then run it again if the night batch job dumped, and often it also dumps for us a couple of times before it finally works.

This is the dump:

Category               Installation Errors
Runtime Errors         DBIF_RSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB
Date and Time          28.09.2021 08:58:47

 Short text
     SQL error "-911" when accessing table "DFKKOP".

 What happened?
     Error Text of the Database: "SQL0911N The current transaction has been rolled
      back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1"

I have not been able to find any relevant notes. The closest being 2041382 which seems to adress Oracle and the dump is not really the same. Also the problem is not running out of number ranges.

Can I somehow set some trace up in DBACOCKPIT to investigate further or do you have any other ideas what could be wrong?

For many clients on the same system this runs just fine only a few seems to experience the problem.

[maria_shen]

Hello Jesper,

Once you have one of data collected, feel free to contact us by creating SAP case under component BC-DB-DB6.
We will continue to help you.

Thank you.

Kind regards
Maria