IBM Support

How to exclude database exceptions in IBM InfoSphere Guardium

Question & Answer


Question

My Guardium appliance database gets filled with SQL errors returned by the database. How do I prevent this from happening? We have installed a selective policy.

Answer

Guardium logs all database exceptions by default. To reduce the exceptions logged:

  1. Create a group of exceptions that you want to avoid logging
  2. Add an EXCEPTIONS rule to the policy
    1. Add description, Category, Classification abd Severity as needed
    2. Specify the group name for Error Code
    3. Select SQL_ERROR for Excpt. Type
    4. Select SKIP LOGGING as the rule action
    5. Add additional filters such as Server IP etc. as necessary
  3. Restart inspection engines


[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"8.0.1;8.1;8.2;9.0;9.1","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21668579