Collectors that use a database sensor require that you create a read-only database user account so that the collector can query for events.
See Installing collectors that use a database sensor.
To create a read-only database user account for IBM DB2
To create a local user, at a command prompt, type the following command:
To set the password for the user db2test, type the following command:
To access the database command prompt, type the following command:
To connect to a DB2 alias, at the db2 command prompt, type the following command:
To grant connect privileges to the user user_name, type the following command:
To grant access to specific tables to the user db2test, type the following commands: