IBM DB2: Unable to monitor tablespace (Error:DB2 SQL Error: SQLCODE=-1092)

IBM DB2: Unable to monitor tablespace (Error:DB2 SQL Error: SQLCODE=-1092)

Problem:

Error: DB2 SQL Error: SQLCODE=-1092 shown in the 'Monitor Information' section in the 'Overview' tab of the DB2 monitor page.

Why do you see this error?

You require a DB2 user with System monitor authority (SYSMON) to monitor the tablespace details in IBM DB2 from Applications Manager. If this privilege is not available, then you will see the error given above.

Solution:

To fix the error, you will have to create an OS group and provide SYSMON authority to the Application Manager's DB2 user by following the steps mentioned below.

In Operating System
  1. Create a OS group in the operating system (ex: apmgrp) and assign Applications Manager DB2 OS user to that group.

In DB2 database
  1. Configure the OS group that was created earlier (apmgrp) to obtain SYSMON permission in the database and then restart the DB2. Subsequently, you will have to provide DATAACCESS privilege or access to the SYSIBMADM functions and SYSPROC procedures and restart the DB2 again. You can do the same using the following commands:
  1. db2 UPDATE DBM CFG USING SYSMON_GROUP <group_name>
  2. db2stop
  3. db2start
  4. db2 GRANT DATAACCESS ON DATABASE TO GROUP <group_name>
  5. db2stop
  6. db2start
ex:
  1. db2 UPDATE DBM CFG USING SYSMON_GROUP apmgrp
  2. db2stop
  3. db2start
  4. db2 GRANT DATAACCESS ON DATABASE TO GROUP apmgrp
  5. db2stop
  6. db2start

                  New to ADSelfService Plus?

                    • Related Articles

                    • DNS Monitor - Troubleshooting

                      Common DNS Monitor Errors and Troubleshooting Guide 1. Host Not Found Description: The DNS server was unable to locate the requested lookup address. Possible Causes: This may happen if the hostname is incorrect, the domain does not exist, or there is ...
                    • Mail Server Monitor - Troubleshooting

                      Common Mail Server Monitor Errors and Troubleshooting Guide 1. Unknown Host Error Description: This error occurs when the mail client cannot resolve the hostname of the mail server to an IP address. The issue typically arises from DNS resolution ...
                    • Self monitor Applications Manager using Real User Monitoring

                      We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...
                    • Troubleshooting MS SQL Monitor Addition Problems

                      1. Ensure that the SQL Server is running and accessible. Try connecting to the SQL Server instance via SQL Server Management Studio or DBVisualizer using the same credentials. This step helps diagnose connection issues, ensuring that both the server ...
                    • Troubleshooting URL Monitor

                      When configuring a URL monitor in Applications Manager, you might encounter several errors related to accessibility, configuration, or server-side issues. Below are common errors along with step-by-step troubleshooting instructions to help you ...