SAP Knowledge Base Article - Preview

3128946 - Db2 'Runstats' BSIS table results in excessive SQL0911N rc=68 lock-wait and timeout.

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

SAP ERP 6.0

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.