-
Title
DB2 - DB2PartitionDataProcessor fails - SQLCODE -551 SQLSTATE 42501 -
Description
Using the new Foglight DB2 Cartridge version = 5.5.8_840, the following error occurs when an agent is created. Foglight id is id is part of db2supp which has the permissions of SYSCTRL and SYSADM.
Cartridge for DB2 5.5.8.x
ECHO <DB_DB2/5.5.8.840/DB_DB2/DB2-HOSTNAME-INSTANCENAME-agent> ERROR [DB2-HOSTNAME-INSTANCENAME-highPriorityPool-1] com.quest.qsi.fason.core.collection.processor.InstanceProcessor - Failed to run DB2PartitionDataProcessor processor of DB2_Startup collection.
java.lang.RuntimeException: Failed to execute collection [DB2_Startup], reason=DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=AFOGLIGHT;EXECUTE;SYSPROC.DB_PARTITIONS, DRIVER=4.12.55- Profile:DB2Profile{host='HOSTNAME', port=63935, databaseName='XXXXXXXX', username='USERNAME', password=xxxxxxx''} Query: "SELECT partition_number, host_name, port_number FROM TABLE(DB_PARTITIONS()) AS T"Cartridge for DB2 5.6.10.x
ECHO <DB_DB2/5.6.10.2/DB_DB2/DB2-INSTANCE-agent> ERROR [DB2-INSTANCE-lowPriorityPool-13378-[DB2_Database_Partition_Activity][]] com.quest.qsi.fason.core.collection.processor.InstanceProcessor - Failed to run DB2PartitionActivityProcessor processor of DB2_Database_Partition_Activity collection.com.quest.qsi.fason.core.collection.processor.Exceptions.IntentionalDisconnectExceptionCaused by: com.quest.qsi.fason.core.collection.processor.Exceptions.IntentionalDisconnectException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=DB2MON2;EXECUTE;SYSPROC.MON_GET_SERVICE_SUBCLASS, DRIVER=4.12.98- Profile:DB2Profile{host='HOSTNAME', port='50001', databaseName='MYDB', username='db2mon', password='xxxxxxx', socketTimeout (sec)='900, authenticationType='DEFAULT'} Query: "select current server as dbname, member, sum(rqsts_completed_total) as total_rqsts, sum(TOTAL_RQST_TIME) as total_rqst_time, sum(total_wait_time) as total_wait_time, sum(TOTAL_CPU_TIME) / 1000.00 as total_cpu_time, sum(total_disp_run_queue_time) as total_cpu_wait, sum(fcm_recv_volume) as fcm_recv_volume, sum(fcm_send_volume) as fcm_send_volume, sum(t.TCPIP_RECV_VOLUME)/1024.00 as tcpip_recv_volume_kb, sum(t.TCPIP_SEND_VOLUME)/1024.00 as tcpip_send_volume_kb FROM TABLE (MON_GET_SERVICE_SUBCLASS(cast(NULL as bigint),cast(NULL as bigint),cast(? as INT))) AS t GROUP BY current server, member" -
Cause
Foglight specific monitoring account has Insufficient Privlidges to query the instance. -
Resolution
Update the required monitoring Grants by re-validating the Database(s) and supplying an account with SYSADM privs to update the Foglight permissions on the instance.
-
Additional Information
SQLCODE -551 SQLSTATE 42501 corresponds to does not have the privilege to perform operation on object. Authorization ID auth-id attempted to perform operation on object object-name without having been granted the proper authority to do so.