Troubleshooting
Problem
Db2audit output shows several unexpected SYSTOOLS.HMON_ATM_INFO related data. An example is below: SELECT STATS_LOCK, REORG_LOCK FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? AND CREATE_TIME = ? FOR UPDATE
Cause
The creation of these Health Monitor entries as part of the db2audit output can't be hindered. When policies apply to a user that itself has a particular authority (f.i. SYSADM) as the db2hmon EDU is running under this user, then the SYSTOOLS.HMON_ATM_INFO data will be reported as part of the audit log events.
Resolving The Problem
Related Information
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21668926