User account requirements

You can configure PATROL for IBM DB2, by using four monitor types, DB2 Local connection setup, DB2 JDBC connection setup, DB2 Remote UNIX connection setup, and DB2 Remote Windows connection setup.

Each configuration type provides information about the DB2 users and Java user that is required to configure the KM.

• Configuring using DB2 Local connection setup
• Configuring using DB2 JDBC connection setup
• Configuring using DB2 Remote UNIX connection setup
• Configuring using DB2 Remote Windows connection setup

Frequently Asked Questions

How to create DB2 user assigned to SYSMON group?

1. Create an OS group (Example: dbmongrp)
2. Create an OS user (Example: dbbmc) and associate the ID as part of the OS group
3. Update the SYSMON_GROUP DBM CFG with the group name
   db2 UPDATE DBM CFG USING SYSMON_GROUP dbmongrp ;
4. Restart the DB2 instance that you changed its DB2 cfg
   db2stop force
   db2start

How to grant DATAACCESS privilege to DB2 user?

1. Invoke the DB2 command 
   "db2 GRANT DATAACCESS ON DATABASE TO GROUP <sysmon group>"
2. Restart the DB2 instance that you changed its DB2 cfg
   db2stop force
   db2start

Which data will not be collected if I am using a DB2 user with only SYSMON authority (without grant DATAACCESS)?

The KM will collect most of the data except for the data that is related to the following query:
select DBPARTITIONNUM,TBSP_NAME, sum(FS_TOTAL_SIZE) - sum(FS_USED_SIZE) as FILE_SYSTEM_FREE_SPACE_COLUMN from (select distinct(FS_ID), DBPARTITIONNUM, TBSP_NAME, FS_TOTAL_SIZE, FS_USED_SIZE from TABLE(MON_GET_CONTAINER('',-1)) where (ACCESSIBLE=1)) FREESPACE group by DBPARTITIONNUM,TBSP_NAME