Transaction code DB12 (history overview) takes a long time (1-2 minutes).
ST12 trace shows that most of the time is spent on a SQL statement (attached) on the database level.
The table function PD_GET_DIAG_HIST is called within the statement.
SAP on IBM Db2 for Linux, UNIX, and Windows
DB12, performance, poor, slow , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem
About this pageThis 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.