IBM Support

Guardium report has question marks in the Full SQL field

Troubleshooting


Problem

IBM Infosphere Guardium captures a prepared statement run on an Informix server twice, once when it is validated and once when it is executed. The validation has no values, so it will appear in reports with ? in place of the missing values. This is working as designed. You can filter out the validation SQL from your reports if desired.

Symptom

Report shows the same SQL twice, once with ? in place of values, once with the correct values.

Environment

Any Guardium collector will see this behavior with Informix servers running prepared statements.

Resolving The Problem

Guardium is working as designed.

To filter out the validation pass, add a condition to the report as follows.

where FullSQL NOT LIKE '%?%'

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Guardium Database Activity Monitor","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.1;9.0;8.2","Edition":"All Editions","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21695041

Page Feedback