Question

1
Replies
167
Views
 Arjan Maus (ArjanM04)
Achmea

Achmea
NL
ArjanM04 Member since 2014 44 posts
Achmea
Posted: December 4, 2017
Last activity: December 18, 2017
Posted: 4 Dec 2017 6:44 EST
Last activity: 18 Dec 2017 2:52 EST
Closed
Solved

spprsysreservequeueitemb-stored-procedure-taking-more-time

Hi all,

We are getting messages within our PGA Rules Alert log files that above mentioned query is getting slower.

I stumbled upon below URL, but it states that this is applicable to ORACLE.

Is this also usefull in DB2?

Best, regards,

Arjan Maus

https://pdn.pega.com/support-articles/spprsysreservequeueitemb-stored-procedure-taking-more-time

***Edited by moderator, Maryrita: moved to Product Support from PegaBuzz***

Data Integration System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 3 years ago
Posted: 5 Dec 2017 3:22 EST
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Technical Lead
Pegasystems Inc.
IN

Hi Arjan,


Default threshold is 500ms I think for sql operation.


We have seen that this threshold generally overshoots by meager values(500ms to 100ms) range.

If such is the case you may ignore it or get in touch of DBA for further analysis.


The post that you have referred to mentions the tuning specific to stored proc in Oracle and same may be applicable at your end.


Open the stored proc and apply it if you find Stored proc with similar code as that of mentioned in that post.


Thanks,

Ujjwal