ASE Error SQL1205 : Deadlocks - DBSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

[davide1706]

Hello,

I just performed a heterogeneous system copy from Solution Manager 7.2 (SP05) from DB2 to ASE 16.0.03.04

I got a few short dumps because of deadlock when running the SGEN.

And now after I scheduled the standard jobs, I keep on getting deadlocks shortdumps (more than 120 days):

SQL error "SQL code: 1205" occurred while accessing table "TBTCY".

Database error text: "SQL message: [ASE Error SQL1205:40001][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Your server command (family id #0, process id #52) encountered a deadlock situation. Please re-run your command.#"

When I ran the sick I couldn't find any error.

Also adapted the Sybase configuration as per the DBA COCKPIT SAP ASE configuration check.

Also the DB statistics update have been ran but didn't help.

Any idea what is wrong and how I could eliminate these deadlocks?

Thanks in advance.

David