Question
Merkle Inc
GB
Last activity: 4 Oct 2018 13:54 EDT
How can we get the SQL query from BIX Extract.
How can we get the SQL query from BIX Extract. we looking for this to fine tune the performance.
***Updated by Moderator: Marissa to update categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems
IN
You can get the query by enabling debug logging on the class - com.pega.pegarules.data.internal.access.ExtractImpl
Merkle Inc
GB
Thankyou, will give it a try and get back if i still have an issue =)
CSRA
US
is the logging to be enabled in bix.xml file and if yes can I get the syntax of enabling this SQL logging
Pegasystems Inc.
US
No, you should enable the logging in prlogging.xml file the way how you enable for other classes.
CSRA
US
We have below config in prlog4j2.xml. Still its not printing the INSERT statements for extraction.
We have below config in prlog4j2.xml. Still its not printing the INSERT statements for extraction.
<Loggers>
<asyncRoot>
<AppenderRef ref="CONSOLE"/>
<AppenderRef ref="PEGA"/>
<AppenderRef ref="ALERT" level="ALERT"/>
<AppenderRef ref="ALERTSECURITY" level="ALERT"/>
</asyncRoot>
<Logger name="com.pega.pegarules.session.internal.mgmt.SecurityEventLogger" additivity="false" level="DEBUG">
<AppenderRef ref="SECURITYEVENT"/>
</Logger>
<Logger name="com.pega.pegarules.data.internal.access.ExtractImpl" additivity="false" level="DEBUG">
<AppenderRef ref="BIX"/>
</Logger>
<Logger name="com.pega.pegarules.data.internal.access.ExtractParameters" additivity="false" level="DEBUG">
<AppenderRef ref="BIX"/>
</Logger>
<Logger name="com.pega.pegarules.data.internal.access.DatabaseUtilsCommonImpl" additivity="false" level="DEBUG">
<AppenderRef ref="BIX"/>
</Logger>
<Logger name="com.hazelcast" additivity="false" level="info">
<AppenderRef ref="CLUSTER"/>
</Logger>
<Logger name="org.apache.ignite" additivity="false" level="info">
<AppenderRef ref="CLUSTER"/>
</Logger>
</Loggers>