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

 Karthik Kummera (Karthik K)
Pegasystems Inc.
Senior Demo Engineer, Support
Pegasystems Inc.
IN
Karthik K Member since 2016 36 posts
Pegasystems Inc.
Posted: Mar 11, 2018
Last activity: Mar 12, 2018
Posted: 11 Mar 2018 8:45 EDT
Last activity: 12 Mar 2018 9:37 EDT
Closed

How to capture the sql query generated while optimizing a property ?

Hi,

We need to optimize a property. As to move this change to production environment, we need to execute the sql query in Prod Environment, that got generated in Dev Environment while optimizing it. Could you please help, how to capture the sql query ?

To see attachments, please log in.
System Administration

Posted: 6 years ago
Posted: 11 Mar 2018 9:48 EDT
Gaurav Sharma (gasharma)
DXC
Principal Consultant
DXC
AU

Hi Karthik,

You should use column populator utility provided by pega which will be present in the shipped product in the scripts folder. Use the below link for reference on how to use the following.
https://docs-previous.pega.com/database-management/how-use-column-populator-utility-prpc-6x-pega-719
https://community.pega.com/sites/default/files/help_v731/procomhelpmain.htm
 

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