Previous Topic: Reduce the Number of Database CallsNext Topic: Specify the Translation Options


Specify the Log Options

The Log Options tab displays the attributes associated with the log for all data sources. It also contains the name of the file, the PROCESS ID, and the type of trace that is appended to the data set name. For example, if the log file name were set to a value of “winxp.log” in the Log File Name field and the Client Trace check box for ODBC were selected. The actual file name would be “winxp.xxxxxxxx.odbc.log, where xxxxxxxx is the process ID.

Follow these steps:

  1. Select the Log Options tab on the CA Datacom/DB ODBC Setup screen.

    The Log Options dialog appears.

  2. Check the box next to the type of Trace you want.

    The types of traces available include:

    ODBC

    Traces all of the similar in format ODBC API calls to the Microsoft ODBC trace in format layout.

    WDBSQLE

    Shows the operations of steps necessary to format and prepare a request from the code in CADCDB32 or CADCDB64 as each step in the process to prepare an ODBC or JDBC request to be shipped to the mainframe server.

    CCI-TCP/IP

    Traces only the CCI or TCP/IP interface calls. It does not provide CCI tracing but rather the information that is used to build CCI and TCP/IP requests.

    JDBC

    Traces only the JDBC API calls. If a more robust trace is desired for JDBC, there are trace facility options embedded in JDBC code that allow for additional tracing. This is only valid if NOJIN=false is set. Otherwise this option is ignored.

    Network Statistics

    Provides statistics for each round trip to the mainframe.

    Network Timing Trace

    Provides timing for each round trip to the mainframe.

  3. Click OK to finish and return to the previous screen.

More information:

Configure the JDBC Proxy on a Windows Platform