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.

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

Was this page helpful? Yes No Submitting... Thank you

Comments