Troubleshooting
Problem
You have a report that fails and you want to know what queries are being run. The DBA may want to review this. For example, for object privileges granted with the GRANT option, you need to know the detailed query in order to evaluate and respond to the assessment.
Diagnosing The Problem
The report will have a test reference ID. Save this ID.
In Guardium, the tests are stored in the SQLBASED_ASSESSMENT_DEFINITION table. The SQL_STMT field will have the logic for the test.
Resolving The Problem
You need to either use a database vendor tool to examine the queries while the assessment is running or to contact IBM Support. These queries are stored in the proprietary database and cannot be viewed without root access to the appliance.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21984442