Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 ANIKET DASGUPTA (ANIKETD5)
Cognizant Technology Solutions

Cognizant Technology Solutions
IN
ANIKETD5 Member since 2014 18 posts
Cognizant Technology Solutions
Posted: Sep 22, 2020
Last activity: Sep 23, 2020
Posted: 22 Sep 2020 6:08 EDT
Last activity: 23 Sep 2020 11:00 EDT
Closed

How to log SQL Statements in Pega log files

Hello,

I wanted to know if it's possible to log SQL statements executed in Pega (for a particular rule) which includes the execution time as well. Please note that I am not looking for DB trace because I don't want it for debugging but for logging actual db query execution time for an actual functionality in production.

I am also not looking for generating alerts or checking AES/PDC.

Is it possible to add some logger to log sql statements? or in some other way?

Thanks in advance,

Aniket

To see attachments, please log in.
Pega Marketing 8.1
Decision Management
Financial Services
Next-Best-Action Analyst

Posted: 5 years ago
Posted: 22 Sep 2020 6:43 EDT
Marc Lasserre (MarcLasserre_GCS)
PEGA
Technical Account Manager
Pegasystems Inc.
FR

Hello, 

Would it be just easiest to work with your DBA in Production to ask him how those requests behave?

To see attachments, please log in.
Posted: 5 years ago
Posted: 23 Sep 2020 11:00 EDT
ANIKET DASGUPTA (ANIKETD5)
Cognizant Technology Solutions

Cognizant Technology Solutions
IN

Hi Marc, Thanks for replying.

That's how we've been doing so far. But there is an ask to have a mechanism to have some sort of reporting/logging that provides the execution time of sql calls during a particular round trip (e.g. during NBA calls in CDH).

To see attachments, please log in.

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