Managing default accounts
You must set up a default account for each DB2 instance that you monitor. The default account controls access to the DB2 instance and determines the authorizations to perform tasks. You also have the option to set up default accounts for accessing KM menus that affect updating, creating, deleting, starting, and stopping DB2 resources, such as the database manager, databases, tablespaces, tables, and applications. For more information about default accounts, see Setting-up-default-accounts-for-EE-and-EEE.
- From the SETUP menu, select KM Commands > Configuration> Configure Default Accounts.
- select from the following options:
To configure a default account user, select the applicable instance. If the applicable instance does not exist, add the instance name, and then select the correct DB2 UDB version. Next, select Monitoring User Information, Menu Commands User Information, or both, and then type the appropriate default account user IDs and passwords.
- To remove a default account user, select the applicable instance. If the applicable instance does not exist, add the instance name, and then select the correct DB2 UDB version. Next, select Monitoring User Information, Menu Commands User Information, or both, and then select the Remove option.
SYSMAINT authority to monitor the DB2 KM
PATROL for DB2 UDB enables users with the SYSMAINT authority to monitor the DB2 KM. Previously, only users with SYSADM or SYSCTRL authority could monitor the DB2 KM. Using SYSMAINT authority, the parameters works correctly and you can monitor database, however, the following table lists the KM commands that will not work with the SYSMAINT authority:
Menu commands that will not work with the SYSMAINT authority
Instance | Menu command |
|---|---|
DB2 UDB EE | DB2 > KM Commands >Database Administration> Directory Mgmt >Database > Catalog Database |
DB2 > KM Commands > Database Administration > Directory Mgmt > Database > Catalog DCS Database | |
DB2 > KM Commands > Database Administration > Directory Mgmt > Database > Catalog Global Database | |
DB2 > KM Commands > Database Administration > Directory Mgmt > Database > Uncatalog Database | |
DB2 > KM Commands > Database Administration > Directory Mgmt > Database > Uncatalog DCS Database | |
DB2 > KM Commands > Database Administration > Directory Mgmt > Node> Catalog Local Node | |
DB2 > KM Commands > Database Administration > Directory Mgmt > Node > Catalog TCP/IP Node | |
DB2 > KM Commands > Database Administration > Directory Mgmt > Node > Catalog APPC Node | |
DB2 > KM Commands > Database Administration > Directory Mgmt > Node > Uncatalog Node | |
DB2 > KM Commands > Database Administration > Database Mgmt > Create Database | |
DB2 > KM Commands > Database Administration > Database Mgmt > Drop Database | |
DB2 > KM Commands > Database Administration > Database Mgmt > Migrate Database | |
DB2 > KM Commands > Database Administration > Configuration Mgmt > Update DBM Configuration | |
DB2 > KM Commands > Database Administration > Configuration Mgmt > Reset DBM Configuration | |
DB2_DB > KM Commands > Database Administration > Table Mgmt > Load Data | |
DB2 UDB EE | DB2_DB > KM Commands > Database Administration > Tablespace Mgmt > Create Tablespace |
DB2_DB > KM Commands > Database Administration > Bufferpool Mgmt > Create Bufferpool | |
DB2_DB > KM Commands > Database Administration > Bufferpool Mgmt > Drop Bufferpool | |
DB2_DB > KM Commands > Database Administration > Bufferpool Mgmt > Alter Bufferpool | |
DB2DB_LOCK > KM Commands > Deadlock Detection > Monitor Deadlocks | |
DB2DB_LOCK > KM Commands > Deadlock Detection > Pause Deadlock Detection | |
DB2DB_LOCK > KM Commands > Deadlock Detection > Resume Deadlock Detection | |
DB2DB_LOCK > KM Commands > Deadlock Detection > Stop Deadlock Detection | |
DB2_SQL_VIEWER > KM Commands > Create SQL Viewer | |
DB2_SQL_VIEWER > KM Commands > Drop SQL Viewer | |
DB2 UDB EEE | DB2EEE > KM Command > Database Administrator > Applications Mgmt > Set Run Time Degree |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Database > Catalog Database | |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Database > Catalog DCS Database | |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Database > Catalog Global Database | |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Database > Uncatalog Database | |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Database > Uncatalog DCS Database | |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Node > Catalog Local Node | |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Node > Catalog TCP/IP Node | |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Node > Catalog APPC Node | |
DB2EEE > KM Command > Database Administrator > Directory Mgmt > Node > Uncatalog Node | |
DB2EEE > KM Command > Database Administrator > Database Mgmt > Create Database | |
DB2EEE > KM Command > Database Administrator > Database Mgmt > Drop Database | |
DB2EEE > KM Command > Database Administrator > Configuration Mgmt > Update DBM Configuration | |
DB2 UDB EEE | DB2EEE > KM Command > Database Administrator > Configuration Mgmt > Reset DBM Configuration |
DB2EEE > KM Command > DB2 Node Administrator > Drop Node Verify | |
DB2EEE > KM Command > DB2 Node Administrator > Start DBM to Add Node | |
DB2EEE > KM Command > DB2 Node Administrator > Stop DBM to Drop Node | |
DB2EEE_DB > KM Command > Database Administrator > Tablespace Mgmt > Create Tablespace | |
DB2EEE_DB > KM Command > Database Administrator > Bufferpool Mgmt > Create Bufferpool | |
DB2EEE_DB > KM Command > Database Administrator > Bufferpool Mgmt > Alter Bufferpool | |
DB2EEE_DB > KM Command > Database Administrator > Bufferpool Mgmt > Drop Bufferpool | |
DB2EEE_DB > KM Command > Database Node Administrator > Nodesgroups > Create Nodegroup | |
DB2EEE_DB > KM Command > Database Node Administrator > Nodesgroups > Alter Nodegroup | |
DB2EEE_DB > KM Command > Database Node Administrator > Nodesgroups > Drop Nodegroup | |
DB2EEE_DB > KM Command > Database Node Administrator > Nodesgroups > Redistribute Nodegroup | |
DB2EEE_DB > KM Command > Deadlock Detection > Monitor DeadLocks | |
DB2EEE_DB > KM Command > Deadlock Detection > Pause DeadLock Detection | |
DB2EEE_DB > KM Command > Deadlock Detection > Resume DeadLock Detection | |
DB2EEE_DB > KM Command > Deadlock Detection > Stop DeadLock Detection | |
DB2EEE_SQL_VIEWER > KM Command > Create SQL Viewer | |
DB2EEE_SQL_VIEWER > KM Command > Drop SQL Viewer | |
DB2EEE_NODE > KM Command > Database Administration > Node Mgmt > Add Node to Databases | |
DB2EEE_NODE > KM Command > Database Administration > Node Mgmt > Drop Node Verify | |
DB2 UDB EEE | DB2EEE_NODE > KM Command > Database Administration > Database Mgmt > Create Database at Node |
DB2EEE_NODE > KM Command > Database Administration > Database Mgmt > Drop Database at Node |