Collect troubleshooting data for Performance Data Warehouse problems in IBM Business Process Manager (BPM)

Technote (troubleshooting)


Problem(Abstract)

You are having a Performance Data Warehouse problem with the IBM Business Process Manager products. For example, you might be experiencing a problem when you are sending or updating the tracking definitions. You would like to know what documentation you must collect (MustGather) so that the IBM Business Process Manager Support team can diagnose your problem. If you gather this documentation before contacting support it will expedite the troubleshooting process, and save you time.

Diagnosing the problem

Collect the troubleshooting information for Performance Data Warehouse problems in IBM Business Process Manager. Gathering this information before calling IBM support helps in understanding the problem and saves time when analyzing the data.

Setting the trace string


Set the trace string to ​*=info:WLE.wle_perf=finest:WLE.wle_perf_load=finest on the server on which the Performance Data Warehouse runs. In a golden topology, this location is the Support cluster, by default.

Note: Enabling trace might slow down your system. This delay can lead to transaction time-outs and errors.

To set the tracing and generate a new set of logs and traces, complete the following steps for the servers or clusters that show the issue:

  1. In the Integrated Solutions Console, under ​Troubleshooting​ ​>​ ​Log and Trace​, select the server for which you want to change the settings. ​

  2. Click Change Log Detail Levels​.

  3. Select the ​configuration tab to set the tracing. This change takes effect after the next server restarts and a completely new set of log files can be collected. Optionally, select the runtime​ tab to dynamically set the tracing.

  4. Enter the trace string and click OK.

  5. If you selected the configuration tab, stop the server.

  6. Archive and delete the current logs, traces, and ffdc from the following directories:
    • <install​​_​​root>​​/​​profiles/<profile​​_​​name>​​/​​logs​​/<​​server​​_​​name>
    • <install​​_​​root>​​/​​profiles/<profile​​_​​name>​​/​​logs​​/ffdc

  7. Start the server and check the trace.log file to make sure that the correct tracing is set.

  8. Reproduce the problem and note down the timestamp. Check the trace.log file to ensure that the time of the issue is covered in the file and gather the complete server log files and ffdc directory.

  9. Delete the trace string from the Log Detail Level for your server.


Note: Ensure that you have set the maximum trace file size (recommendation: 20MB) as well as the number of historical trace files (recommendation: 20) to an appropriate value. You can find those values at Servers > Application Servers > server_name > Diagnostic Trace Service.

General diagnostic information


Collect the general MustGather information as described in Collect troubleshooting data for the IBM Business Process Manager products.

In addition, provide the contents of the following tables:

  • From the Process Server database:
    • LSW_PERF_DATA_TRANSFER
  • From the Performance Data Warehouse database:
    • LSW_DATA_TRANSFER_ERRORS
    • LSW_TABLE
    • LSW_COLUMN

Take a screen shot that shows all tracking group tables in the Performance Data Warehouse database (these are the ones that begin with 'TG_').

Is auto-tracking enabled for your applications?


What to do next

  1. Review the log files and traces at the time of the problem to try to determine the source of the problem.

  2. Use IBM Support Assistant to search for known problems in the product documentation, forums, and technotes.

  3. If you cannot find related problems or cannot solve the problem, send the information you have collected to IBM by following the instructions in Exchanging Information with IBM Technical Support.

Related information

How reporting in PDW works
PDW database architecture
Managing PDWs
A simplified Chinese translation is available

Cross reference information
Segment Product Component Platform Version Edition
Business Integration IBM Business Process Manager Express Performance Data Warehouse Linux, Windows 8.5, 8.0.1, 8.0, 7.5.1, 7.5
Business Integration IBM Business Process Manager Standard Performance Data Warehouse AIX, Linux, Solaris, Windows 8.5, 8.0.1, 8.0, 7.5.1, 7.5
Business Integration IBM BPM Advanced Pattern on Red Hat Enterprise Linux Server Performance Data Warehouse Linux Red Hat - xSeries 8.0.1, 8.0
Business Integration IBM Business Process Manager Advanced Pattern on AIX Performance Data Warehouse AIX 8.0.1

Product Alias/Synonym

BPM

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Business Process Manager Advanced
Performance Data Warehouse

Software version:

7.5, 7.5.1, 8.0, 8.0.1, 8.5

Operating system(s):

AIX, Linux, Solaris, Windows

Reference #:

1609319

Modified date:

2014-01-29

Translate my page

Machine Translation

Content navigation