Insight Monitor question

Dave Petronella

Insight Monitor question
This may be a bit off-topic but has anyone who is using the CA-Insight
Monitor been able to successfully use TIME as part of their IQL routine
criteria. We are trying to have a set of IQL routines that will trigger
CPU-based alerts that are also based on the time of day. We can't seem to
get the IQL to properly recognize the TIME portion of the criteria below.
Any help would be appreciated.




Is they're a way to check the time portion of the EVENT-TIME field in the
CA DB2 Monitor Insight for DB2 IQL below. I have indicated this in blue.

* Display error message for long-running CICS transaction in DEV
*
* declare local DB2 CPU variable for CICS ONLY
*
DECLARE THREAD-STATS TOTAL-DB2-CPU (I8) = TCB-CPU-DB2
+ STORPROC-TCB-CPU
+ TRIG-TOTAL-CPU
+ TRIG-CPU-ENCLAVE;
* + DB2-ZIIP-CPU
* + OTHER-UDF-CPU
*ECLARE global EVENT-TM(T4) = EVENT-TIME(,4,4);
*
*
CANTRXD1: TRACE (LINESIZE=255)
*
<< THREAD-STATS
'DBA9925C - DB2 CPU ' TOTAL-DB2-CPU 'TIME' EVENT-TIME(PF=DATETIME)
CICS-TRANID 'CICS Job Id - ' CICS-JOBID 'Task Id - '
CICS-TASKID (PF=N5 HD='TASK') '- DB2 SYS - 'SUBSYS
>>
WHERE
(THREAD-STATUS = 'ACTIVE' or = 'VTAM')
AND
(CICS-TRANID NE 'XX01' AND NE 'XX02' AND NE 'XX03')
AND
CONN-GROUP='CICS'
AND
(SUBSYS = 'DT11' or = 'DT12' or = 'DT21' or = 'DT22')
AND
(TOTAL-DB2-CPU > 0.1 second)
AND
(EVENT-TIME(,4,4) < '180000' and > 070000) Restrict console message to
time boundaries
INTERVAL= 1 seconds

NEVENTS = 100 /* how many records held in memory before wrap
TITLE = ('THREADS TO BE CANCELLED VIA OPS/MVS')
TERMINAL /* ability to see what was sent to console
CONSOLE
*CONSOLE (x,x,x) /* use this format to use specific wto route cod
;

________________________
David Petronella
Vice President
Data Resource Management / DB2 Database Administration
Pershing LLC, a BNY Mellon company
www.pershing.com
Office: (973) 360-7747
Fax: (973) 360-3121
Email: [login to unmask email]

Go Green. Think before you print.

******************************************************
IMPORTANT: Any information contained in this communication is intended for the use of the named individual or entity. All information contained in this communication is not intended or construed as an offer, solicitation, or a recommendation to purchase any security. Advice, suggestions or views presented in this communication are not necessarily those of Pershing LLC nor do they warrant a complete or accurate statement.

If you are not an intended party to this communication, please notify the sender and delete/destroy any and all copies of this communication. Unintended recipients shall not review, reproduce, disseminate nor disclose any information contained in this communication. Pershing LLC reserves the right to monitor and retain all incoming and outgoing communications as permitted by applicable law.

Email communications may contain viruses or other defects. Pershing LLC does not accept liability nor does it warrant that email communications are virus or defect free.
******************************************************

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Steen Rasmussen

Re: Insight Monitor question
(in response to Dave Petronella)
Dave - being part of the CA team, I urge you to contact support - they're usually very helpful to assist getting the IQL reports customized.

Steen Rasmussen

________________________________

From: IDUG DB2-L on behalf of Dave Petronella
Sent: Wed 12/29/2010 4:15 PM
To: [login to unmask email]
Subject: [DB2-L] Insight Monitor question



This may be a bit off-topic but has anyone who is using the CA-Insight Monitor been able to successfully use TIME as part of their IQL routine criteria. We are trying to have a set of IQL routines that will trigger CPU-based alerts that are also based on the time of day. We can't seem to get the IQL to properly recognize the TIME portion of the criteria below. Any help would be appreciated.


=

Is they're a way to check the time portion of the EVENT-TIME field in the CA DB2 Monitor Insight for DB2 IQL below. I have indicated this in blue.

* Display error message for long-running CICS transaction in DEV
*
* declare local DB2 CPU variable for CICS ONLY
*
DECLARE THREAD-STATS TOTAL-DB2-CPU (I8) = TCB-CPU-DB2
+ STORPROC-TCB-CPU
+ TRIG-TOTAL-CPU
+ TRIG-CPU-ENCLAVE;
* + DB2-ZIIP-CPU
* + OTHER-UDF-CPU
*ECLARE global EVENT-TM(T4) = EVENT-TIME(,4,4);
*
*
CANTRXD1: TRACE (LINESIZE=255)
*
<< THREAD-STATS
'DBA9925C - DB2 CPU ' TOTAL-DB2-CPU 'TIME' EVENT-TIME(PF=DATETIME)
CICS-TRANID 'CICS Job Id - ' CICS-JOBID 'Task Id - '
CICS-TASKID (PF=N5 HD='TASK') '- DB2 SYS - 'SUBSYS
>>
WHERE
(THREAD-STATUS = 'ACTIVE' or = 'VTAM')
AND
(CICS-TRANID NE 'XX01' AND NE 'XX02' AND NE 'XX03')
AND
CONN-GROUP='CICS'
AND
(SUBSYS = 'DT11' or = 'DT12' or = 'DT21' or = 'DT22')
AND
(TOTAL-DB2-CPU > 0.1 second)
AND
(EVENT-TIME(,4,4) < '180000' and > 070000) Restrict console message to time boundaries
INTERVAL= 1 seconds

NEVENTS = 100 /* how many records held in memory before wrap
TITLE = ('THREADS TO BE CANCELLED VIA OPS/MVS')
TERMINAL /* ability to see what was sent to console
CONSOLE
*CONSOLE (x,x,x) /* use this format to use specific wto route cod
;

________________________
David Petronella
Vice President
Data Resource Management / DB2 Database Administration
Pershing LLC, a BNY Mellon company
www.pershing.com
Office: (973) 360-7747
Fax: (973) 360-3121
Email: [login to unmask email]

Go Green. Think before you print.
******************************************************
IMPORTANT: Any information contained in this communication is intended for the use of the named individual or entity. All information contained in this communication is not intended or construed as an offer, solicitation, or a recommendation to purchase any security. Advice, suggestions or views presented in this communication are not necessarily those of Pershing LLC nor do they warrant a complete or accurate statement.

If you are not an intended party to this communication, please notify the sender and delete/destroy any and all copies of this communication. Unintended recipients shall not review, reproduce, disseminate nor disclose any information contained in this communication. Pershing LLC reserves the right to monitor and retain all incoming and outgoing communications as permitted by applicable law.

Email communications may contain viruses or other defects. Pershing LLC does not accept liability nor does it warrant that email communications are virus or defect free.
******************************************************


________________________________


Introducing IBM® DB2® 10 for z/OS < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Colin M Fay

Re: Insight Monitor question
(in response to Steen Rasmussen)
resend

From: Fay, Colin M
Sent: Friday, December 31, 2010 6:55 AM
To: [login to unmask email]
Subject: RE: [DB2-L] Insight Monitor question

(EVENT-TIME(,4,4) < '180000' and > 070000) Restrict console message to time boundaries
I noticed the mismatched quotes on the '180000' vs the 070000 formatting

Intentional?




From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen, Steen
Sent: Wednesday, December 29, 2010 4:43 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Insight Monitor question

Dave - being part of the CA team, I urge you to contact support - they're usually very helpful to assist getting the IQL reports customized.

Steen Rasmussen

________________________________
From: IDUG DB2-L on behalf of Dave Petronella
Sent: Wed 12/29/2010 4:15 PM
To: [login to unmask email]
Subject: [DB2-L] Insight Monitor question

This may be a bit off-topic but has anyone who is using the CA-Insight Monitor been able to successfully use TIME as part of their IQL routine criteria. We are trying to have a set of IQL routines that will trigger CPU-based alerts that are also based on the time of day. We can't seem to get the IQL to properly recognize the TIME portion of the criteria below. Any help would be appreciated.


=

Is they're a way to check the time portion of the EVENT-TIME field in the CA DB2 Monitor Insight for DB2 IQL below. I have indicated this in blue.

* Display error message for long-running CICS transaction in DEV
*
* declare local DB2 CPU variable for CICS ONLY
*
DECLARE THREAD-STATS TOTAL-DB2-CPU (I8) = TCB-CPU-DB2
+ STORPROC-TCB-CPU
+ TRIG-TOTAL-CPU
+ TRIG-CPU-ENCLAVE;
* + DB2-ZIIP-CPU
* + OTHER-UDF-CPU
*ECLARE global EVENT-TM(T4) = EVENT-TIME(,4,4);
*
*
CANTRXD1: TRACE (LINESIZE=255)
*
<< THREAD-STATS
'DBA9925C - DB2 CPU ' TOTAL-DB2-CPU 'TIME' EVENT-TIME(PF=DATETIME)
CICS-TRANID 'CICS Job Id - ' CICS-JOBID 'Task Id - '
CICS-TASKID (PF=N5 HD='TASK') '- DB2 SYS - 'SUBSYS
>>
WHERE
(THREAD-STATUS = 'ACTIVE' or = 'VTAM')
AND
(CICS-TRANID NE 'XX01' AND NE 'XX02' AND NE 'XX03')
AND
CONN-GROUP='CICS'
AND
(SUBSYS = 'DT11' or = 'DT12' or = 'DT21' or = 'DT22')
AND
(TOTAL-DB2-CPU > 0.1 second)
AND
(EVENT-TIME(,4,4) < '180000' and > 070000) Restrict console message to time boundaries
INTERVAL= 1 seconds

NEVENTS = 100 /* how many records held in memory before wrap
TITLE = ('THREADS TO BE CANCELLED VIA OPS/MVS')
TERMINAL /* ability to see what was sent to console
CONSOLE
*CONSOLE (x,x,x) /* use this format to use specific wto route cod
;

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv