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"}}]
Was this topic helpful?
Document Information
Modified date:
30 August 2019
UID
swg21674600