2906390 - Deadlocks (SQL1205) reported on custom tables since migration to SAP ASE

• Since database migration to SAP ASE a lot of deadlock errors are being reported in SM21 with ST22 dump like this:

Category Installation Errors
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB

Date and Time dd.mm.yyyy hh:MM:ss

Short Text
SQL error "SQL code: 0" occurred while accessing table "ZXXXX".

[...]

DB C1(1205) [40001] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Your server command (family id [/bas/753_REL/src/dbs/syb/dbsyb.c#50649]
DB C1 #0, process id #625) encountered a deadlock situation. Please re-run your comma  /bas/753_REL/src/dbs/syb/dbsyb.c#50649]
DB C1nd. [/bas/753_REL/src/dbs/syb/dbsyb.c#50649]
DB C1sql statement is ==> <truncated_SQL_statement_may_appear_here>
[/bas/753_REL/src/dbs/syb/dbsyb.c#50649]

• From related developper trace you'll find the complete SQL statement :

C ERROR: -1 in function StartSelect (execute) [line 30116]
C (1205) [40001] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Your server command (family id
C #0, process id #625) encountered a deadlock situation. Please re-run your comma
C nd.
C
C sql statement is ==> <SQL_statement_here>
C /* R3:<program>:<id> T:Z<table> M:<client> */
C
C transaction aborted by server
B ***LOG BYO=> deadlock aborts transaction [dbsh 1207]
B SQL code: 1205, SQL text: [ASE Error SQL1205:40001][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Your server command (family id #0, process id #625) encountered a deadlock sit
B

• Same Deadlock errors also reported in the ASE error log.
• $SYBASE/$SYBASE_ASE/install/<SID>.log for Unix, %SYBASE%\%SYBASE_ASE%\install\<SID>.log for Windows platforms
  
  
• Involved tables reported in the deadlock messages are custom tables (Z tables).
• Statistics of those tables are being updated regularly thru ATM of DBACockpit.
• Involved tables are "volatile" tables, which means contents can vary from empty to very large at run time, so data changing/moving all the time.

• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP NetWeaver (NW) - All versions 

deadlock, custom table, Z table, concurrency threshold, concurrency_opt_threshold, SQL1205 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem