DBACOCKPIT SQL Statements list is wrong on DB2 for i

[Former Member]

Hi,
I have a question concerning SAP on DB2 for IBM i-Series (V7R2). On a customer system with performance problems I looked into DBACOCKPIT -> Performance -> SQL Statements and found very old data from other systems, probably garbage from system copies. Restart of  the system and the DB does not clean up this mess, it seems permanent. How can I clean this up?

Thx for any hint.

Best regards

Harry

[Former Member]

Hi Harry,

Have you reviewed SAP Notes 1622665 - IBM i: SAP Database Performance Collector 1634283 - IBM i: Changes to Show Data of SAP Database Perf. Collector Regards, Ronan.

[Former Member]

Hi Ronan,

thx for this information, sounds very interesting. My problem with the old SQL statements was solved meanwhile, unfortunately I have no information (yet) how it was done.

Best regards

    Harry

[Sriram2009]

Hi Harry.

I am note sure, on OS/400 have to clear the Sql package and then check the DBACockpit

Regards

SS