IBM BPM Performance Data Warehouse Logging

Follow

Log into Websphere Admin Console

Troubleshooting-> Logs and trace -> server1 -> Diagnostic trace -> Configuration

1 - Change Filename field to create a new log called something like TWTrace.log in suitable location

2 - Change trace output format to Advanced

3 - Optionally change the maximum file size and the number of rotated files.

Apply Changes

4 - Click Change Log Detail Levels

Expand WLE category to get to WLE.wle_perf which relates to Performance Data Warehouse

Click category to get popup menu then select 'finest' which should result in the group info change shown

Review trace log

You should then see messages around the RepresentationManager like this from tw_perf

44707:[9/16/11 13:13:42:125 GMT-06:00] 00000385 wle_perf      1 com.lombardisoftware.server.tracking.queue.RepresentationManagerQueue queue queue(com.lombardisoftware.server.ejb.tracking.RepresentationManagerMessage@69b569b5)

44708:[9/16/11 13:13:42:125 GMT-06:00] 00000385 wle_perf      1 com.lombardisoftware.server.tracking.queue.RepresentationManagerQueue queue queue() - message sent

44711:[9/16/11 13:13:42:156 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.ejb.tracking.RepresentationManagerServicesCore processPendingActions processPendingActions() - enter

44712:[9/16/11 13:13:42:156 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.ejb.tracking.RepresentationManagerServicesCore getTablesWithPendingStatus getTablesWithPendingStatus() - enter

44713:[9/16/11 13:13:42:156 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.ejb.tracking.RepresentationManagerServicesCore getTablesWithPendingStatus getTablesWithPendingStatus() - sql:

44719:[9/16/11 13:13:42:156 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.ejb.tracking.RepresentationManagerServicesCore getTablesWithPendingStatus getTablesWithPendingStatus() - found 0 tables with pending status

44721:[9/16/11 13:13:42:171 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager createActions createActions() - entered

44723:[9/16/11 13:13:42:187 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager findUsedTableNames findUsedTableNames(...) sql is

44733:[9/16/11 13:13:42:312 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager findUsedTableNames findUsedTableNames: [AEMPREQUISITION121297892720600, LSW_COLUMN, LSW_DATA_TRANSFER_ERRORS, LSW_LOAD_TRACE, LSW_OPTIMIZER_DATA, LSW_PRI_KEY, LSW_SNAPSHOT, LSW_SYSTEM, LSW_SYSTEM_SCHEMA, LSW_TABLE, LSW_TASK, LSW_TIMING_INTERVAL, LSW_TIMING_INTERVAL_BOUND, LSW_TIMING_INTERVAL_VALUE, LSW_TRACKED_FIELD, LSW_TRACKED_FIELD_USE, LSW_TRACKING_GROUP, LSW_TRACKING_POINT, LSW_TRACKING_POINT_VALUE, LSW_USER_MAPPINGS, LSW_USR_XREF, LSW_VIEW, PROCESSFLOWS, PS_WLSTORE, SIB000, SIB001, SIB002, SIBCLASSMAP, SIBKEYS, SIBLISTING, SIBOWNER, SIBOWNERO, SIBXACTS, SLASTATUS, SLATHRESHOLDTRAVERSALS, SNAPSHOTS, TASKS, TG_AEMPREQUISITION121297892720, TG_PROCESSFLOWS, TG_SLASTATUS, TG_SLATHRESHOLDTRAVERSALS, TIMINGINTERVALS, TIMINGINTERVALVALUE, TRACKEDFIELDS, TRACKEDFIELDUSE, TRACKINGGROUPS, TRACKINGPOINTS, TRACKINGPOINTVALUE]

...

45096:[9/16/11 13:13:42:578 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeActions Executing update schema commands

45097:[9/16/11 13:13:42:578 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeCommands Invoking executeCommand(command = DROP VIEW PMX750PCDW.SNAPSHOTS, isDdl=true)

45098:[9/16/11 13:13:42:578 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.NonTransactionalDdlRepresentationManager execute Executing DDL command declare

45103:[9/16/11 13:13:42:593 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeCommands Invoking executeCommand(command = DROP VIEW PMX750PCDW.TASKS, isDdl=true)

45104:[9/16/11 13:13:42:593 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.NonTransactionalDdlRepresentationManager execute Executing DDL command declare

45109:[9/16/11 13:13:42:609 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeCommands Invoking executeCommand(command = DROP VIEW PMX750PCDW.TIMINGINTERVALS, isDdl=true)

45110:[9/16/11 13:13:42:609 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.NonTransactionalDdlRepresentationManager execute Executing DDL command declare

45115:[9/16/11 13:13:42:640 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeCommands Invoking executeCommand(command = DROP VIEW PMX750PCDW.TIMINGINTERVALVALUE, isDdl=true)

45116:[9/16/11 13:13:42:640 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.NonTransactionalDdlRepresentationManager execute Executing DDL command declare

...

45612:[9/16/11 13:13:42:968 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeActions Executing update schema commands

45613:[9/16/11 13:13:42:968 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeActions Executing update data commands

45614:[9/16/11 13:13:42:968 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeActions Executing drop commands

45615:[9/16/11 13:13:42:968 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeActions Executing rename commands

45616:[9/16/11 13:13:42:968 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeActions Executing update metadata commands

...

44362:[9/16/11 13:13:41:296 GMT-06:00] 0000002f wle_perf      1   CWLLG1244I: Performance Server is beginning to load the tracking definition.

44366:[9/16/11 13:13:41:328 GMT-06:00] 0000002f wle_perf      1   CWLLG1245I: Performance Server definitions are queued for update.

44367:[9/16/11 13:13:41:359 GMT-06:00] 00000385 wle_perf      1   CWLLG1246I: Performance Server is updating the performance model.

44709:[9/16/11 13:13:42:125 GMT-06:00] 00000385 wle_perf      1   CWLLG1247I: Performance Server updated the performance model successfully.

and if appropriate CREATE TABLE and CREATE VIEW

[9/16/11 13:13:42:437 GMT-06:00] 00000386 wle_perf      1 com.lombardisoftware.server.tracking.representationmanager.RepresentationManager executeCommands Invoking executeCommand(command =

CREATE VIEW PMX750PCDW.PROCESSFLOWS

AS

SELECT

TG.BPD_ID AS BPD_ID,

TG.BPD_INSTANCE_ID AS BPD_INSTANCE_ID,

TG.LOCAL_SNAPSHOT_ID AS LOCAL_SNAPSHOT_ID,

TG.SEQUENCE_FLOW_ID AS SEQUENCE_FLOW_ID,

TG.SOURCE_EUID AS SOURCE_EUID,

TG.STEP_NUMBER AS STEP_NUMBER,

TG.TRACKING_GROUP_ID,

TG.TRACKING_POINT_ID,

TG.TASK_ID,

TG.FUNCTIONAL_TASK_ID,

TG.TIME_STAMP,

S.NAME AS SNAPSHOT,

S.SHORT_NAME AS ACRONYM

 

 

Save changes to configuration

Have more questions? Submit a request

Comments

Powered by Zendesk