Author |
Message
|
giuly020277 |
Posted: Thu Feb 14, 2013 1:42 am Post subject: How to count how many messagges are put on a remote queue |
|
|
 Centurion
Joined: 07 Aug 2007 Posts: 146 Location: Florence,Italy
|
Hello everyone,
i work on zos 1.12. Websphere Mq for zos v. 7.0.1
I'd like to report how many messagges are put (by transaction cics) daily on a remote queue.
How can i do it?
Thank u all |
|
Back to top |
|
 |
giuly020277 |
Posted: Thu Feb 14, 2013 3:18 am Post subject: |
|
|
 Centurion
Joined: 07 Aug 2007 Posts: 146 Location: Florence,Italy
|
Maybe i could know how many messagges are put on the trasmission queue associated with that remote queue. It's possibile to know how many messagges in a day xmit queue have had? |
|
Back to top |
|
 |
mqjeff |
Posted: Thu Feb 14, 2013 3:59 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
I think on zOS there's something called SMS that can answer this.
But I can barely spell zOS, much less get the right inflection on the zed to pronounce it properly. And SMS on zOS is not what I think of when I think of SMS. |
|
Back to top |
|
 |
bruce2359 |
Posted: Thu Feb 14, 2013 5:23 am Post subject: |
|
|
 Poobah
Joined: 05 Jan 2008 Posts: 9469 Location: US: west coast, almost. Otherwise, enroute.
|
mqjeff wrote: |
I think on zOS there's something called SMS that can answer this.
But I can barely spell zOS... |
It's SMF. When configured, SMF statistics and accounting records can be captured for reporting, problem-determination, and performance tuning. _________________ I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
Back to top |
|
 |
giuly020277 |
Posted: Thu Feb 14, 2013 6:20 am Post subject: |
|
|
 Centurion
Joined: 07 Aug 2007 Posts: 146 Location: Florence,Italy
|
Thank u bruce...
I knew about smf recording...but i will no found 116_1 and 116_2 records.
Now i see i have to start a trace to collect these records.
Ciao |
|
Back to top |
|
 |
PeterPotkay |
Posted: Thu Feb 14, 2013 6:31 am Post subject: |
|
|
 Poobah
Joined: 15 May 2001 Posts: 7722
|
I've always thought this was a gap in MQ - that we couldn't get enqueu counts on Remote Q defs.
Time for an RFE....I'll post the link. _________________ Peter Potkay
Keep Calm and MQ On |
|
Back to top |
|
 |
PeterPotkay |
Posted: Thu Feb 14, 2013 7:54 am Post subject: |
|
|
 Poobah
Joined: 15 May 2001 Posts: 7722
|
|
Back to top |
|
 |
bruce2359 |
Posted: Thu Feb 14, 2013 9:00 am Post subject: |
|
|
 Poobah
Joined: 05 Jan 2008 Posts: 9469 Location: US: west coast, almost. Otherwise, enroute.
|
giuly020277 wrote: |
Thank u bruce...
I knew about smf recording...but i will no found 116_1 and 116_2 records.
Now i see i have to start a trace to collect these records.
Ciao |
No, you don't have to start a trace. Refer this to your systems programmers. Ask them to enable the capturing of the appropriate SMF records for WMQ.
Then ask them to make the SMF data available for your analysis and reporting. I suspect that your shop has one or more analysis and reporting tool in place already. _________________ I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
Back to top |
|
 |
bruce2359 |
Posted: Thu Feb 14, 2013 12:10 pm Post subject: Re: How to count how many messagges are put on a remote queu |
|
|
 Poobah
Joined: 05 Jan 2008 Posts: 9469 Location: US: west coast, almost. Otherwise, enroute.
|
giuly020277 wrote: |
I'd like to report how many messagges are put (by transaction cics) daily on a remote queue.
|
A little clarity, please.
Do you mean how many times a message was put to a transmission queue waiting to be sent down the network, and ultimately put to the destination queue?
Or do you mean how many messages were put on the destination queue at the qmgr down the network, but only by a Message Channel Agent? _________________ I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
Back to top |
|
 |
giuly020277 |
Posted: Fri Feb 15, 2013 1:43 am Post subject: |
|
|
 Centurion
Joined: 07 Aug 2007 Posts: 146 Location: Florence,Italy
|
...if I set SMFACCT=YES and SMFSTAT=YES in CSQ6SYSP i collect record 115_1 , 115_2 and 116.
But i need 116_1 and 116_2 .
So..reading a redbook i find that starting trace(acctg) class(3) ifcid(0025) i got them. Infact now i can see how many messagges are put on a remote queue ( see table mqs_accnt_queue on tivoli decision support ). |
|
Back to top |
|
 |
bruce2359 |
Posted: Fri Feb 15, 2013 8:25 am Post subject: |
|
|
 Poobah
Joined: 05 Jan 2008 Posts: 9469 Location: US: west coast, almost. Otherwise, enroute.
|
Exactly and precisely what trace did you start? How did you start it? Do you mean a GTF trace?
Capturing SMF records is not a trace. _________________ I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
Back to top |
|
 |
elkinsc |
Posted: Sun Feb 17, 2013 6:01 am Post subject: To capture queue level information |
|
|
 Centurion
Joined: 29 Dec 2004 Posts: 138 Location: Indy
|
To capture the queue level information associated with a task, you do need to start the class 3 accounting trace.
+cpf START TRACE(ACCTG) DEST(SMF) CLASS(3)
That will generate a set of task records for each transaction, which may be overkill for the information you are trying to gather.
Take a look at the RESET QSTATS command. This may get you the information you need with less overhead. One caution, if you have a monitoring product like Omegamon (and others), it may issue a RESET QSTATS regularly. The RESET does just what it says - it resets the counters. So if there are two applications issuing the RESET command, each will get the counts from some of the activity.
Please see:
http://publib.boulder.ibm.com/infocenter/wmqv7/v7r1/topic/com.ibm.mq.doc/sc12830_.htm |
|
Back to top |
|
 |
giuly020277 |
Posted: Tue Feb 19, 2013 12:42 am Post subject: |
|
|
 Centurion
Joined: 07 Aug 2007 Posts: 146 Location: Florence,Italy
|
After starting trace i have smf records about account of my queue.
I want to use Tivoli decision Support to report how many messagges flow trhough my remote queue.
Which field tell me that?
I have to count : MqPUT calls + MQput1 calls?
The field i found on that table ( mqs_accnt_queue_t) are :
DATE DATE
TIME TIME
PERIOD_NAME CHAR
MVS_SYSTEM_ID CHAR
MQSERIES_SUB_ID CHAR
CONNECTION_NAME CHAR
ORIG_PRIM_AUTHID CHAR
RRS_CONN_NETW_ID CHAR
MMOVER_CHAN_NAME CHAR
MMOVER_LCONN_NAME CHAR
PRIMARY_AUTHID CHAR
CORRELATOR_ID CHAR
MQOPEN_QUEUE_NAME CHAR
QUEUE_BASE_NAME CHAR
TASK_CONNECTED CHAR
QUEUE_TYPE FLOAT
QUEUE_QSGDISP FLOAT
MQOPEN_ELAPS_TIME FLOAT
MQOPEN_CPU_TIME FLOAT
MQOPEN_CALLS FLOAT
MQCLOS_ELAPS_TIME FLOAT
MQCLOS_CPU_TIME FLOAT
MQCLOS_CALLS FLOAT
MQGET_ELAPS_TIME FLOAT
MQGET_CPU_TIME FLOAT
MQGET_CALLS FLOAT
MQGET_BROWSE_ANY FLOAT
MQGET_BROWSE_SPEC FLOAT
MQGET_DESTRU_ANY FLOAT
MQGET_DESTRU_SPEC FLOAT
MQGET_UNACCOUNTAB FLOAT
MQGET_WRLOG_WTIME FLOAT
MQGET_WRLOG_REQS FLOAT
MQGET_RDPGS_WTIME FLOAT
MQGET_RDPGS_REQS FLOAT
MQGET_SUSP_WTIME FLOAT
MQGET_SUSPENDS FLOAT
MQGET_PAGES_SKIP FLOAT
MQGET_MSGS_SKIP FLOAT
MQGET_EX_MSGS_PRC FLOAT
MQPUT_ELAPS_TIME FLOAT
MQPUT_CPU_TIME FLOAT
MQPUT_CALLS FLOAT
MQPUT_WRLOG_WTIME FLOAT
MQPUT_WRLOG_REQS FLOAT
MQPUT_SUSP_WTIME FLOAT
MQPUT_SUSPENDS FLOAT
MQPUT_PGSSUSP_TME FLOAT
MQPUT_PGSET_REQS FLOAT
MQPUT1_ELAPS_TIME FLOAT
MQPUT1_CPU_TIME FLOAT
MQPUT1_CALLS FLOAT
MQPUT1_WRLOG_WTME FLOAT
MQPUT1_WRLOG_REQS FLOAT
MQPUT1_SUSP_WTIME FLOAT
MQPUT1_SUSPENDS FLOAT
MQPUT1_PGSUSP_TME FLOAT
MQPUT1_PGSET_REQS FLOAT
MQINQ_ELAPS_TIME FLOAT
MQINQ_CPU_TIME FLOAT
MQINQ_CALLS FLOAT
MQSET_ELAPS_TIME FLOAT
MQSET_CPU_TIME FLOAT
MQSET_CALLS FLOAT
MQSET_WRLOG_WTME FLOAT
MQSET_WRLOG_REQS FLOAT
MQPUT1_BYTES_WRIT FLOAT
MQGET_BYTES_READ FLOAT
MQPUT_SUCCESSFUL FLOAT
MQGET_SUCCESSFUL FLOAT
GENERATED_MSGS FLOAT
MQGET_MSG_SIZ_MAX FLOAT
MQGET_MSG_SIZ_MIN FLOAT
MQPUT_MSG_SIZ_MAX FLOAT
MQPUT_MSG_SIZ_MIN FLOAT
MSG_LATENCY_MAX FLOAT
MSG_LATENCY_MIN FLOAT
MSG_LATENCY_TOT FLOAT
QUEUE_CUR_HANDLES FLOAT
QUEUE_CALLS_TOT FLOAT
MQGET_MSG_PERSIS FLOAT
MQPUT_MSG_PERSIS FLOAT
MQPUT1_MSG_PERSIS FLOAT
QUEUE_DEPTH_MAX FLOAT
MQGET_DESTRUCTIVE FLOAT
MQGET_FORCE_WTIME FLOAT
MQGET_FORCE_WRITE FLOAT
MQPUT_GET_WAITING FLOAT
MQPUT_FORCE_WTIME FLOAT
MQPUT_FORCE_WRITE FLOAT
MQPUT1_GET_WAITING FLOAT
MQPUT1_FORCE_WTIME FLOAT
MQPUT1_FORCE_WRITE FLOAT
MQSET_FORCE_WTIME FLOAT
MQSET_FORCE_WRITE FLOAT
what do u think about it?
Thank u all |
|
Back to top |
|
 |
bruce2359 |
Posted: Tue Feb 19, 2013 4:21 am Post subject: |
|
|
 Poobah
Joined: 05 Jan 2008 Posts: 9469 Location: US: west coast, almost. Otherwise, enroute.
|
SMF records, and their contents, are documented. Search google. Search ibm.com. _________________ I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
Back to top |
|
 |
elkinsc |
Posted: Tue Feb 19, 2013 8:46 am Post subject: SMF layout |
|
|
 Centurion
Joined: 29 Dec 2004 Posts: 138 Location: Indy
|
The queue record layout can be found in hlq.SCSQMACS(CSQDWQ). The field of interest is called VALIDPUT. I don't see anything in the list provided that matches, but my eyes are old and weary. |
|
Back to top |
|
 |
|