Troubleshooting
Problem
You are running a report to show FULL SQL, but "?" is shows in place of values. For example: INSERT INTO TAB1 VALUES (?,?,?,?)
Cause
When using JDBC, in order to properly log Oracle bind variable traffic, you must enable the Inspection Engine parameter Log Records Affected.
Resolving The Problem
Log into the GUI. go to Administration Console > Inspection Engines and enable the following parameter:
Log Records Affected
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z0000001euvAAA","label":"INSPECTION ENGINE"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"and future releases;11.5.0"}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21664261