Skip to main content
Contact a Moderator

Question

1
Replies
172
Views
 Arjan Maus (ArjanM04)
Achmea

Achmea
NL
ArjanM04 Member since 2014 48 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://collaborate.pega.com/question/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: 4 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

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice