|   | 
	 
  
    | 
RSS Feed - WebSphere MQ Support
 | 
RSS Feed - Message Broker Support
 |   
 
  
	     | 
	 | 
   
 
  
	|  MP1B reports different result | 
	« View previous topic :: View next topic »  | 
   
  
  	
	  
		
		
		  | Author | 
		  Message
		 |  
		
		  | RaMZee | 
		  
		    
			  
				 Posted: Mon Sep 26, 2016 4:08 am    Post subject: MP1B reports different result | 
				     | 
			   
			 
		   | 
		 
		
		   Newbie
 
 Joined: 26 Sep 2016 Posts: 2
  
  | 
		  
		    
			  
				We take the report with MP1B MQ product. But we saw that there was a difference in the reports. The PUTS Count is not equal to the number of total in two different reports. The same problem applies to GET Count. Could be why the difference?
 
 
IBM WebSphere MQ for z/OS V8.0.0
 
MP1B version 8
 
 
  
 
Thanks.
 
 
 
//* new Feb 2015                                       
 
//QALL     DD DSN=&&OUTDSN01,                          
 
//         DISP=(,PASS),UNIT=SYSDA,SPACE=(CYL,(10,20)),
 
//         DCB=(LRECL=250,RECFM=FB,BLKSIZE=0)          
 
//PUTSCSVS  DD DSN=&&OUTDSN18,                           
 
//          DISP=(,PASS),UNIT=SYSDA,SPACE=(CYL,(10,20)), 
 
//          DCB=(LRECL=250,RECFM=FB,BLKSIZE=0)           
 
//GETSCSVS  DD DSN=&&OUTDSN20,                            
 
//          DISP=(,PASS),UNIT=SYSDA,SPACE=(CYL,(10,20)),  
 
//          DCB=(LRECL=250,RECFM=FB,BLKSIZE=0)            
 
 
 
 
        QALL              
 
---------------------------
 
0 Open name                                  UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Queue type:QLocal                          UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 CF structure name      STR01               UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Get count                        174       UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Get avg elapsed time             297 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Get avg CPU time                  26 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Get valid destructive              6       UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Put count                          6       UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Put avg elapsed time             134 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Put avg CPU time                  33 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Total Queue elapsed time       55932 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Total Queue CPU used            5376 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
 
 
 
 
 
          
 
         PUTSCSVS                                                               
 
---------------------------                                                     
 
Queue                                                         Puts            Put1s         TotBytes         MaxMsgSz         MinMsgSz    
 
UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1                           3                0             1179              393              393   
 
 
 
                 
 
         GETSCSVS                                                               
 
---------------------------                                                     
 
Queue                                                    TotalGets        ValidGets         TotBytes         MaxMsgSz         MinMsgSz
 
UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1                          87                3             1179              393              393 | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | bruce2359 | 
		  
		    
			  
				 Posted: Mon Sep 26, 2016 10:07 am    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		    Poobah
 
 Joined: 05 Jan 2008 Posts: 9486 Location: US: west coast, almost. Otherwise, enroute. 
  | 
		  
		    
			  
				Moved to Mainframe forum. _________________ 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: Mon Sep 26, 2016 10:31 am    Post subject: Re: MP1B reports different result | 
				     | 
			   
			 
		   | 
		 
		
		    Poobah
 
 Joined: 05 Jan 2008 Posts: 9486 Location: US: west coast, almost. Otherwise, enroute. 
  | 
		  
		    
			  
				
   
	| RaMZee wrote: | 
   
  
	We take the report with MP1B MQ product. But we saw that there was a difference in the reports. 
 
 
The PUTS Count is not equal to the number of total in two different reports.  | 
   
 
 
Put counts are not equal to what Number of total?  In which two different reports?
 
 
   
	| RaMZee wrote: | 
   
  
	| The same problem applies to GET Count. Could be why the difference? | 
   
 
 
Which two different reports?
 
 
Please be precise.
 
 
And, have you read the Interpreting accounting & statistics for WebSphere MQ for z/OS V7 .pdf document included in the MP1B download?  Do you understand MQ statistics and accounting data? _________________ 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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | RaMZee | 
		  
		    
			  
				 Posted: Mon Sep 26, 2016 10:37 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		   Newbie
 
 Joined: 26 Sep 2016 Posts: 2
  
  | 
		  
		    
			  
				Hello,
 
 
Explain again.
 
 
We start the following JCL.
 
 
 
********************************* Top of Data **********************************
 
//SMFMQ   JOB (ACCOUNT),'MQSTAT',MSGCLASS=X,CLASS=A,                            
 
//         REGION=0M                                                            
 
//STEP1    EXEC PGM=MQSMF,REGION=0M               
 
//* change userid.MP1B.LOAD to your load library  
 
//* SMFIN to the dataset with your SMF data in it 
 
//STEPLIB  DD DISP=SHR,DSN=MQ.UTIL.MP1B.LOAD      
 
//SMFIN    DD DISP=SHR,DSN=S000.SMFDUMP.TD90.DUN  
 
//         DD DISP=SHR,DSN=S000.SMFDUMP.TD91.DUN  
 
//SYSIN    DD *                                   
 
//* new Feb 2015                                       
 
//QALL     DD DSN=&&OUTDSN01,                          
 
//         DISP=(,PASS),UNIT=SYSDA,SPACE=(CYL,(10,20)),
 
//         DCB=(LRECL=250,RECFM=FB,BLKSIZE=0)          
 
//PSIDQIO  DD DSN=&&OUTDSN02,                          
 
//         DISP=(,PASS),UNIT=SYSDA,SPACE=(CYL,(10,20)),
 
//         DCB=(LRECL=250,RECFM=FB,BLKSIZE=0)          
 
//*                                                    
 
//PUTSCSVS  DD DSN=&&OUTDSN18,                            
 
//          DISP=(,PASS),UNIT=SYSDA,SPACE=(CYL,(10,20)),  
 
//          DCB=(LRECL=250,RECFM=FB,BLKSIZE=0)            
 
//*GETSCSV  DD SYSOUT=*,DCB=(LRECL=250)                   
 
//GETSCSVS  DD DSN=&&OUTDSN20,                            
 
//          DISP=(,PASS),UNIT=SYSDA,SPACE=(CYL,(10,20)),  
 
//          DCB=(LRECL=250,RECFM=FB,BLKSIZE=0)            
 
//*********************************************************************     
 
//MQSTAT   EXEC PGM=IKJEFT01,PARM='%MQSTAT'                                 
 
//SYSEXEC  DD DISP=SHR,DSN=MQ.UTIL.MP1B.SRC                                 
 
//INFIL2   DD DSN=&&OUTDSN01,DISP=(OLD,DELETE)
 
//INFIL18  DD DSN=&&OUTDSN02,DISP=(OLD,DELETE)
 
//INFIL20  DD DSN=&&OUTDSN18,DISP=(OLD,DELETE)
 
//INFIL24  DD DSN=&&OUTDSN20,DISP=(OLD,DELETE)
 
/*   
 
 
 
 
QALL output GET COUNT =58   	NOT EQUAL 		GETSCSVS output TOTALGETs=29
 
 
QALL output PUT COUNT =2   	NOT EQUAL 		PUTSCSVS output TOTALGETs=1
 
 
 
WHY the same isn't it? GETSCSVS GET COUNT why half?
 
 
  
 
Output:
 
 
        QALL              
 
---------------------------
 
0 Open name                                  UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Queue type:QLocal                          UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 CF structure name      STR02               UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Get count                         58       UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Get avg elapsed time            1114 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Get avg CPU time                   6 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Get valid destructive              2       UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Put count                          2       UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Put avg elapsed time           12155 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Put avg CPU time                  48 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Total Queue elapsed time      199640 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
0 Total Queue CPU used            1545 uS    UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1
 
 
 
 
          
 
         PUTSCSVS                                                               
 
---------------------------                                                     
 
Queue                                                         Puts            
 
UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1                           1            
 
 
                 
 
         GETSCSVS                                                               
 
---------------------------                                                     
 
Queue                                                    TotalGets       
 
UYG.CMS.GNRL.ONL.HOST.ESB.INQUIRY.RQ.1                          29  | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | elkinsc | 
		  
		    
			  
				 Posted: Fri Oct 07, 2016 10:13 am    Post subject: MP1B issues | 
				     | 
			   
			 
		   | 
		 
		
		    Centurion
 
 Joined: 29 Dec 2004 Posts: 138 Location: Indy 
  | 
		  
		    
			  
				Greetings!
 
 
1) Have you verified that the different reports you are looking at are using the same criteria ?  Some reports are for individual tasks, some are summing up per interval, or all from the same task.  That should be documented, but possibly isn't. 
 
 
2) Have you looked at the raw data in the dump format (CSQ4SMFD program) to check the values in MP1B?  If you are seeing differences, then please report the to the author.  
 
 
3) Finally if the numbers are not adding up and you need the information quickly, check out the MQSMFCSV formatter on github:
 
https://github.com/ibm-messaging/mq-smf-csv
 
 
And some help with SQL against a database built from that data: 
 
http://www.lynsmq4zos.com/ | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | gbaddeley | 
		  
		    
			  
				 Posted: Sun Oct 09, 2016 5:34 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		    Jedi Knight
 
 Joined: 25 Mar 2003 Posts: 2538 Location: Melbourne, Australia 
  | 
		  
		    
			  
				GET count includes calls to MQGET when there is no message available? _________________ Glenn | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | elkinsc | 
		  
		    
			  
				 Posted: Wed Oct 12, 2016 4:20 am    Post subject: Do you have PI53551 applied? | 
				     | 
			   
			 
		   | 
		 
		
		    Centurion
 
 Joined: 29 Dec 2004 Posts: 138 Location: Indy 
  | 
		  
		    
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | 
		    
		   | 
		 
	   
	 | 
   
 
  
	     | 
	 | 
	Page 1 of 1 | 
   
 
 
 
  
  	
	  
		
		  
 
  | 
		  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
  | 
  		 
	   
	 | 
   
 
  	 | 
	  |