Enable client information tracing with the administrative console

Use either of the methods outlined in this task to enable the passing and tracing of client information about a database connection.

Refer to the Implicitly set client information topic to determine which of the two available levels of client information passing and tracing is appropriate for our configuration. Once a level is selected, there are two methods of enabling it:

• Enable either of the WebSphere Application Server trace groups: WAS.clientinfo or WAS.clientinfopluslogging. Enabling either of these trace groups enables client information passing for all data sources of the application server. If client information is only required for a specific data source, consider using the following method.

• Create a data source custom property to enable client information tracing. This method is functionally equivalent to enabling WAS.clientinfo, except that it is enabled only on the specified data source. A data source custom property does not exist to provide the equivalent functionality of the WAS.clientinfopluslogging trace group. If that level of tracing is required, use that trace group setting instead.

Tasks

1. Open the administrative console.

2. If we choose to enable client information passing and tracing using a trace group:

   1. Select Troubleshooting.

   2. Select Log and Trace.

   3. Select the server we want to use.

   4. Select Diagnostic Trace.

   5. Select Change log detail levels.

   6. Select the Configuration or Runtime tab. Changes made to the Configuration are applied after a server restart. Changes made to the Runtime are applied immediately.

   7. In the Trace Specification entry field, type either WAS.clientinfo=all or WAS.clientinfopluslogging=all. To deactivate either trace, replace =all with =off (without spacing between characters) or delete the trace string entry.

3. If we choose to enable client information passing using a data source custom property:

   1. Select Resources.

   2. Select JDBC > Data sources.

   3. Select the datasource on which we want to enable client information tracing.

   4. Select Custom Properties under the Additional Properties section.
   5. Press New....

   6. Enter enableClientInformation in the Name field.

   7. Enter true in the Value field.

   8. Optional: Enter a description in the Description field, if desired.

   9. Select java.lang.Boolean in the Type field.

4. Press OK.

5. Save the changes to the configuration when prompted to do so.

Related:

Unshareable and shareable connections

Passing client information to a database

Implicitly set client information