Skip to Content

No historical statements in st04 Statement Cache

Hi,

today i investigate a performance Problem we faced this night.
So i check the "Display historical Statements" in the st04 Statement Cache.

But no historical snapshot was available.

In the SAP Collector Profile i have this values, so i expect it has to work.

Where is my fault ? Did i miss something ?

regards
Kay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 28, 2015 at 10:14 AM

    SAPCL Alert Router is collecting the data, it needs to be active. Can you check.

    If it is active check the *READA* log file in the log directory USS for any errors.

    You should increase the interval to 30 minutes and reduce the number of statements to 50, otherwise to much CPU is consumed.

    Regards,
    Thomas

    Add comment
    10|10000 characters needed characters exceeded

    • Hallo Thomas,

      the alert router is running:

      SAPCL 720 Patch Level 017 Timestamp 23.09.14 - 10:00:00 running.

      Alert router active

      It's a system on Client side, so we have no access to the filesystem.

      They work with DB2 V11 and SAP 740 with AIX Kernel 742 Patchlevel 200

      regards

      Kay