How to Identify Query/Queries in Patricular Time

[former_member618864]

Hi All,

We are facing performance issues on ECC EHP6 running on DB2 10.1 Database. From last few days we are continously ecountering huge number of dumps " DBIF_RSQL_ERROR". As, per dump analysis I able to understand some sql statments are too long/complex/expensive, due to this system is unable to allocate heap memorry. We don't have sufficient hardware to increase heap memory any more.. I able to see huge number of dumps are generating around 10:00--11:00 my System time..

My questions are:

1)  How would i able to identify queries/query running on SAP System from 10:00--11:00?

2)  After identifying query, how would we able to identify which user is trigeering it?

Thanks

Regars,

Raj

[former_member618864 · Accepted solution]

Hi,

Thanks all for your tremendous support and quick turn around.. As, i stated in first message problem is with the STMM Heap memory in db2 cfg parameters we have already set value to auto.. Even though it is taking 8192 .

SQL statement heap (4KB)                     (STMTHEAP) = AUTOMATIC(8192)

Which is not sufficient in our case, we plan to increase instance memroy. Thanks.

Regards,

Raj