Symptom
Excessive lock-waits and timeouts observed during RUNSTATS operation on table BSIS. Accounting/Financial applications are experiencing delay and failure.
The 'db6util' locking report ( note 327595 ) shows numerous BSIS table inserts waiting for long periods of time. This can also be observed in Dbacockpit using transaction code DB01.
======================================================
Status : Lock Waiting (1175 seconds)
User Id : FMENDOZAR
Wkstn : vtoaprpd4700
Appl. : ptype UPD
Acc. Info : WPBHELP_REGISTRATION
Lock Name : 0C00C606000000000000000054
Last SQL : INSERT INTO "BSIS" VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) WITH CS -- OPTLEVEL( 5 )
-- QUERY_DEGREE( 1 ) -- SYSTEM( RPD , SAPRPD )
Status : Lock Waiting (1567 seconds)
User Id : GENDCRV
Wkstn : vtoaprpd3600
Appl. : ptype UPD
Acc. Info : WPBHELP_REGISTRATION
Lock Name : 0C00C606000000000000000054
Last SQL : INSERT INTO "BSIS" VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) WITH CS -- OPTLEVEL( 5 )
-- QUERY_DEGREE( 1 ) -- SYSTEM( RPD , SAPRPD )
======================================================
Read more...
Environment
- Db2 (DB6) any release
- Netweaver AS any release
Product
Keywords
BSEG DB6 SQL0911N -911 , KBA , BC-DB-DB6-DBA , Database Administration , 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.