Setup requirements in a Windows environment for DB2 UDB EE and EEE

Following are the setup requirements for DB2 UDB EE and DB2 UDB EEE in Windows environment:

• To monitor a DB2 database on a Windows computer, permission should be granted to execute db2ilist.exe which is located in the DB2UDBInstallationDirectory\SQLLIB\bin directory. Depending upon the installation of various components of PATROL 7 or PATROL 3, permission should be granted as follows:
  • If all PATROL 7 components including PATROL Agent and DB2 KM are installed on same Windows computer, then the PATROL Console Server user must have permission to execute db2ilist.exe.
    
    If PATROL Console Server is installed on one Windows computer and PATROL Agent and DB2 KM on other Windows computer, then the user with which managed host was added from the console must have permission to execute db2ilist.exe.
  • For PATROL 3 console, whether DB2 KM is monitored locally or remotely, the user with which the hosts are added must have permission to execute db2ilist.exe.
• The parameters under all application classes in the DB2_DB container or the DB2EEE_DB container will appear offline. To make them online and to collect data, you need to do one of the following for each database being monitored:
  • Create a connection to the database using the following command:
    
    db2 connect to databaseName
  • Activate the database using the following command:
    
    db2 activate database databaseName
• To monitor tablespaces, log on as the instance owner and set the bufferpool monitor switch, DFT_MON_BUFPOOL to ON by entering the following command:
  db2 update dbm cfg using DFT_MON_BUFPOOL ON