Collectors that use a database sensor require that you create a read-only database user account so that the collector can query for events.
To create a read-only database user account for IBM DB2
To create a local user, at a command prompt, type the following command:
adduser user_name -g users -s /sbin/nologin
To set the password for the user db2test, type the following command:
passwd user_name
To access the database command prompt, type the following command:
db2
To connect to a DB2 alias, at the db2 command prompt, type the following command:
connect to db2_alias
For example, you can type the following command:
connect to SSIM
To grant connect privileges to the user user_name, type the following command:
GRANT CONNECT ON DATABASE TO USER user_name
To grant access to specific tables to the user db2test, type the following commands:
GRANT SELECT ON database_name.table_name TO USER user_name