I create situation via TEPS GUI for monitoring TSM (kskagent) as GSMA recommend as below
I need to monitoring Schedule Status with the formular
*IF ( ( *VALUE KSK_SCHEDULE.Schedule_Status *EQ Failed *AND *VALUE KSK_SCHEDULE.Node_Type *EQ 'SERVER' ) *OR ( *VALUE KSK_SCHEDULE.Schedule_Status *EQ Missed *AND *VALUE KSK_SCHEDULE.Node_Type *EQ 'SERVER' ) )
|
but I found the issue situation does not trigger and alert when the condition is true
example
on my schedule workspace have information client backup failed. but not have any alert occur on my TEPS tsm instant
does some one have any suggestion to help me.
Thank you for all answer
For More information
In sk log it's seem like sk agent cannot insert some data on table AGENTLOG (May be it's concern with permission of user tsm instance) as error below
2013-04-30 10:45:31.000000 TSMDerbyDB: Message: An SQL data change is not permitted for a read-only connection, user or database.
2013-04-30 10:45:31.000000 TSMDerbyDB: Error Inserting message into the Database: INSERT INTO AGENTLOG (SERVERNAME, DATETIME, ATTRIBUTEGROUP, MSG) VALUES ('10.219.238.86', '1130430104531000', 'Sche
dule', 'Processing Situation: kbk_schdclt_gskc_std')
2013-04-30 10:45:31.000000 Schedule: Situation Query Executing: SELECT SERVERNAME, SERVERVER, SERVERREL, SCHEDULENAME, NODENAME, SCHEDULESTART, ACTUALSTART, STATUS, RESULT, REASON, DOMAINNAME, NODE
TYPE, EXTRACTTIME from SCHEDULE WHERE EXTRACTTIME>'1130430095122000'
2013-04-30 10:45:31.000000 TSMDerbyDB: Error updating the DERBY database in updateDB
2013-04-30 10:45:31.000000 TSMDerbyDB: Message: An SQL data change is not permitted for a read-only connection, user or database.
2013-04-30 10:45:31.000000 TSMDerbyDB: Error Inserting message into the Database: INSERT INTO AGENTLOG (SERVERNAME, DATETIME, ATTRIBUTEGROUP, MSG) VALUES ('10.219.238.86', '1130430104531000', 'Sche
dule', 'De-Synchronizing DERBY')
2013-04-30 10:45:31.000000 Schedule: De-Synchronizing DERBY
2013-04-30 10:45:31.000000 TSMSchedule: No rows returned from DERBY query
2013-04-30 10:45:31.000000 TSMCustomClient: cp_WaitForRequest
2013-04-30 10:46:31.000000 TSMCustomClient: req.request is: 1
2013-04-30 10:46:31.000000 TSMCustomClient: this is a collectdata request
2013-04-30 10:46:31.000000 TSMCustomClient: Situation (non-historical-request) request found
2013-04-30 10:46:31.000000 TSMCustomClient: Situation name found is:kbk_schdsrv_gskc_std
2013-04-30 10:46:31.000000 TSMCustomClient: Situation name found is:kbk_schdsrv_gskc_std
2013-04-30 10:46:31.000000 TSMSchedule: Entering collectData as a Situation/Non-Historical Request
TSMcpci: Agent trace log will be stored in: /IBM/itm/logs
TSMcpci: Error converting KSK_KEYSTORE variable - going to default of blank
My tsm instance is admin of TSM application
I try to use user DB2 administrator (tsminst1) and user admin of TSM application >> both instance can view data on TEPS but situation monitoring cannot alert
please help me to find the way out. Many Thanks you all