App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#Applicationintegration
#App Connect
#AppConnect
#Integration
#Automation
 View Only

  • 1.  ACE 12.4 postgres service level trace command

    Posted 06/24/22 07:10 AM
    Hi,
    What is the jvmSystemProperty for tracing a postgres 9.4 database within Integration server on ACE 12.4

    for example oracle db  is trace this way mqsichangeproperties <brokerName> -e <egName> -o ComIbmJVMManager -n jvmSystemProperty -v"-Doracle.jdbc.Trace=true"
    as ibm support does not cover this topic : JDBC trace for IBM App Connect Enterprise and IBM Integration Bus

    ------------------------------
    Thabo Shokgolo
    ------------------------------


  • 2.  RE: ACE 12.4 postgres service level trace command
    Best Answer

    Posted 06/27/22 02:53 PM

    The postgres JDBC driver does not use a Java command argument to enable the trace.  It uses a flag on the JDBC connection URL like:

    jdbc:postgresql://localhost:5432/mydb?loggerLevel=DEBUG
    jdbc:postgresql://localhost:5432/mydb?loggerLevel=TRACE&loggerFile=pgjdbc.log


    ------------------------------
    MATTHEW SEGALL
    ------------------------------



Related Content