IBM Support

PolicyLogger SQL logging

Troubleshooting


Problem

Enabling the PolicyLogger to output SQL statements produced by Policies

Symptom

SQL capture or action not occurring as expected

Resolving The Problem

One can enable the PolicyLogger to output the SQL statements being used by the Policies, but it is also advantageous to also split this output on a per Policy basis by selecting:

    Log What: [ ] All SQL statements

and:

    Append Policy Name to Log File Name

For example:

And, of course, one would also have to enable:

    Service Log: [ ] Write to file

This will produce a log file in the directory (Impact 5):

    $NCHOME/impact/log


or (Impact 6):

    $NCHOME/impact/logs

of the format:

    [ImpactServerName]_policylogger_[PolicyName].log(.n)

Where [ImpactServerName] is the name of the ImpactServer (for example: NCI) and [PolicyName] is the name of the Policy producing this output (for example: My_Enrichment_Policy) and (.n) are the numbered roll-over log files (between 1 and 10 by default).

[{"Product":{"code":"SSSHYH","label":"Tivoli Netcool\/Impact"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Netcool\/Impact","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"}],"Version":"6.1;6.1.1;7.1.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
30 August 2019

UID

swg21674600