No historical statements in st04 Statement Cache

[KayKa]

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

[thomas_vogt]

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

[KayKa]

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