SAP Knowledge Base Article - Preview

2543442 - DB6: Long running work processes on tables with LOB columns

Symptom

Some activities have higher response times than normal/expected.

In transaction SM66/SM50, the corresponding work processes are shown as reading from tables with LOB (Large Object) columns.

RAWSTRING and STRING are ABAP dictionary datatypes that are represented by BLOB and CLOB columns respectively in the database.

Some of the most common tables are DYNPSOURCE, DYNPLOAD, REPOSRC, REPOLOAD, FPLAYOUTT, and FPCONTEXT.

sm66.PNG

The system appears to recover after several minutes but the issue repeats sporadically.

To confirm if the tables listed in SM66/SM50 contain LOB columns, use the following query:

SELECT table_name, column_name FROM dba_lobs WHERE owner = '<sapuser>';

Additionally, the STAD record of the long running step as shown in following figures:

stad1.PNG

Most of the time is spent on Database request time, and the average direct/sequential read time per row will be very high as shown in the STAD record above.

It may also show most of the time is spent in processing time as shown in the STAD record below.

stad2.PNG

Load and generate activities often select from tables with LOB columns and the client work process requesting the load/generate will accumulate processing time.


Read more...

Environment

SAP Netweaver

Database: IBM DB2 for Linux, UNIX, and Windows

  • DB2 10.1 lower than fix pack FP5SAP
  • DB2 10.5 lower than fix pack FP6SAP

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

System hang, Performance , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , SV-PERF , Performance Problems , 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.