Troubleshooting
Problem
Tracing DCS/WMS SQL Queries (WH_LOG_SQL_CLAUSES)
Symptom
PART: Outbound 6.0 SP1 DCS
COMPONENT: Other
OS: HP-UX -
10.2
DATABASE: Oracle - 7.3.4
WEB SERVER: <None> - <None>
WEB BROWSER:
<None> - <None>
Cause
Resolving The Problem
Tracing DCS/WMS SQL:
--Using sql_clause.log:
? Set the environment
variable WH_LOG_SQL_CLAUSES to 'Y'
? Run the program at shell prompt.
?
Go to $TMPDIR. Find a file sql_clause.log there. This contains a dump of the
sql queries that were done.
[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
PRI47857
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21524007