CLPPlus traces and record logging

CLPPlus provides mechanisms for file traces and record logging. CLPPlus supports logging or traces from the CLPPlus client layer and JDBC driver layer.

The IBM Data Server Driver for JDBC and SQLJ and IBM Data Server Driver for ODBC and CLI offer comprehensive tracing facilities. These facilities have been extended to CLPPlus. Trace facilities generate text log files whenever an application accesses a specified driver (CLPPLus Client layer or JDBC Driver layer) using the SET command. These log files provide detailed information about the CLPPlus Client and JDBC:
  • functions called by an application
  • function contents; including input and output parameters passed to and received from
  • function return codes and any error or warning messages generated.
To configure the CLPPlus trace facilities, issue the SET command from a CLPPlus command prompt. To enable client layer or driver layer traces, set the LOGMODE parameter:
CLPPlus> SET LOGMODE logmode-value
where logmode-value indicates whether to perform tracing and for which layer. The default value is NONE, which indicates no tracing is done. Other valid values are CLPPLUS, which traces the client layer, JCC, which traces the JDBC layer, and BOTH, which traces both the client and JDBC layers.
To perform more detailed JDBC tracing, set logmode-value to JCC or BOTH, and specify the JCCLOGMODE parameter:
SET LOGMODE JCC
SET JCCLOGMODE jcclogmode_value
where jcclogmode_value indicates the features to be traced and logged. For more information about valid jcclogmode_value settings, see SET CLPPlus command.