Re: Queue Indexing on Distributed Platforms
I believe that the index feature for queues is only available on the mainframe. Tony Anthony G Allison [EMAIL PROTECTED] Sent by: MQSeries List [EMAIL PROTECTED] 08/18/2004 08:12 AM Please respond to MQSeries List [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject Queue Indexing on Distributed Platforms Good morning MQSeries Listers, Is there a method of turning on the index feature for non MVS / OS390 platforms? ie. Sun Solaris? What is the performance impact on the system if this is possible. I know there is substantial performance impacts if this is a high volume message queue Thanks for your input. Anthony Allison Senior Middleware Engineer CSC 1001 G Street Suite 800 WDC, 20001 (202) 824-7938 [EMAIL PROTECTED] This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. This electronic message transmission contains information from a member company of Westfield Group which is privileged, confidential or otherwise the exclusive property of the intended recipient or that member company of Westfield Group. This information is intended for the use of the individual or entity that is the intended recipient. If you are not the designated recipient, please be aware that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this electronic transmission in error, please notify us by telephone at 1.800.243.0210, extension 2153, or by electronic e-mail ([EMAIL PROTECTED]) and promptly destroy the original transmission.
Re: Queue Indexing on Distributed Platforms
Jim, Thanks for a clear and concise answer, this is what I thought but just wanted to make sure. Have a great day! Anthony Allison Senior Middleware Engineer CSC 1001 G Street Suite 800 WDC, 20001 (202) 824-7938 [EMAIL PROTECTED] This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. James Simms wmqjim @JUNO.COM Sent by: MQSeries List MQSERIES 08/18/2004 12:06 PM Please respond to MQSeries List To:[EMAIL PROTECTED] cc: Subject:Re: Queue Indexing on Distributed Platforms Since WMQ/zOS (and whatever other names it has) uses VSAM linear data sets for the queues, it can have an 'external' index set. The distributed platforms use flat files and there is no real index available. However, (trying to remember a pitch from the conference) there is a hash-type table that indexes the queues but only for a limited number of messages (I believe that number is 512). In some bacl k-level release (can't remember which one) I believe that number was about 1000 but has been reduced. If retrieving using msgid or correlid, the perfornance runs out at the 512 number and WMQ goes into a sequential seach pattern. Againn -- this is from somewhat faulty memory from a conference pitch. It would be helpful if one of the developers could jump in on this one with a clear answer. Jim John Scott wrote: I'd always thought that on OS/390 pagesets etc. came with some indexing functionality provided by the operating system. It would seem logical (to me) that MQ makes use of that functionality rather than inventing it's own. Because the storage mechanism on OS/390 is so different, it might be that the indexing can be configured on different fields in the message. On the Windows/Unix platforms, the operating system does not provide such indexing facilities. Basically any data file (text file, html page, word document etc) are flat files like any other and contain a stream of bytes. The MQ software has no OS functionality to use so has to implement its own. Regards John Scott IBM Certified Specialist - MQSeries Argos Ltd -Original Message- From: Wyatt, T.rob [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 15:32 To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms Well, there is this from the manual... This parameter is supported only on z/OS. On other platforms, retrieval optimization might be provided, but it is not controlled by a queue parameter. So it might be there, but if it is you can't touch it. Unfortunately, I don't think this settles the question one way or the other! -- T.Rob -Original Message- From: MQSeries List [mailto:[EMAIL PROTECTED] Behalf Of Robert Broderick Sent: Wednesday, August 18, 2004 10:24 AM To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms R U sure??? I was told that indexing was ONLY available on the OS390. Maybe what you say is true. Maybe this is a pre 5.3 condition. From: David C. Partridge [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms Date: Wed, 18 Aug 2004 14:27:49 +0100 IIRC the queues are always indexed on distributed. Dave _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive ** Check our latest prices and full range at http://www.argos.co.uk The information contained in this message or any of its attachments may be privileged and/or confidential, and is intended exclusively for the addressee. Unauthorised disclosure, copying or distribution of the contents is strictly prohibited. The views expressed may not be official policy, but the personal views of the originator. If you have received this message in error, please advise the sender by using the reply facility in your e-mail software. All messages sent and received by Argos Ltd are monitored for viruses
Queue Indexing on Distributed Platforms
Good morning MQSeries Listers, Is there a method of turning on the index feature for non MVS / OS390 platforms? ie. Sun Solaris? What is the performance impact on the system if this is possible. I know there is substantial performance impacts if this is a high volume message queue Thanks for your input. Anthony Allison Senior Middleware Engineer CSC 1001 G Street Suite 800 WDC, 20001 (202) 824-7938 [EMAIL PROTECTED] This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
AW: Queue Indexing on Distributed Platforms
Hi Anthony, as described inthe MQSC command reference, queue indexing is only available on z/OS. When you use this option, you will get an error message. Regards Hubert -Ursprngliche Nachricht-Von: MQSeries List [mailto:[EMAIL PROTECTED]Im Auftrag von Anthony G AllisonGesendet: Mittwoch, 18. August 2004 14:13An: [EMAIL PROTECTED]Betreff: Queue Indexing on Distributed PlatformsGood morning MQSeries Listers, Is there a method of turning on the index feature for non MVS / OS390 platforms? ie. Sun Solaris? What is the performance impact on the system if this is possible. I know there is substantial performance impacts if this is a high volume message queue Thanks for your input. Anthony Allison Senior Middleware EngineerCSC 1001 G StreetSuite 800WDC, 20001(202) 824-7938[EMAIL PROTECTED]This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
Re: Queue Indexing on Distributed Platforms
IIRCthe queues are always indexed on distributed. Dave
Re: Queue Indexing on Distributed Platforms
R U sure??? I was told that indexing was ONLY available on the OS390. Maybe what you say is true. Maybe this is a pre 5.3 condition. From: David C. Partridge [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms Date: Wed, 18 Aug 2004 14:27:49 +0100 IIRC the queues are always indexed on distributed. Dave _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: Queue Indexing on Distributed Platforms
Well, there is this from the manual... This parameter is supported only on z/OS. On other platforms, retrieval optimization might be provided, but it is not controlled by a queue parameter. So it might be there, but if it is you can't touch it. Unfortunately, I don't think this settles the question one way or the other! -- T.Rob -Original Message- From: MQSeries List [mailto:[EMAIL PROTECTED] Behalf Of Robert Broderick Sent: Wednesday, August 18, 2004 10:24 AM To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms R U sure??? I was told that indexing was ONLY available on the OS390. Maybe what you say is true. Maybe this is a pre 5.3 condition. From: David C. Partridge [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms Date: Wed, 18 Aug 2004 14:27:49 +0100 IIRC the queues are always indexed on distributed. Dave _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: Queue Indexing on Distributed Platforms
Rob As far as I know, based on my (possibly faulty) memory of some discussions with the Hursley folks a couple or three years back, the way the queue file on disk is constructed on distributed means that it is always indexed to some degree, however I defer to any MQ mavens who may know better. On 390, the way queues are stored on the page sets is such that indexing doesn't come free, and so it's configurable (with a cost as the QM starts up). Dave Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: Queue Indexing on Distributed Platforms
In this context, distributed probably only means Windows and mainstream Unix. Dave -Original Message- From: David C. Partridge [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 15:42 To: MQSeries List Subject: RE: Queue Indexing on Distributed Platforms Rob As far as I know, based on my (possibly faulty) memory of some discussions with the Hursley folks a couple or three years back, the way the queue file on disk is constructed on distributed means that it is always indexed to some degree, however I defer to any MQ mavens who may know better. On 390, the way queues are stored on the page sets is such that indexing doesn't come free, and so it's configurable (with a cost as the QM starts up). Dave Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: Queue Indexing on Distributed Platforms
Yes, I was referring to Windows / Mainstream Unix Anthony Allison Senior Middleware Engineer CSC 1001 G Street Suite 800 WDC, 20001 (202) 824-7938 [EMAIL PROTECTED] This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. David C. Partridge David.Partridge @PRIMEUR.COM Sent by: MQSeries List MQSERIES 08/18/2004 10:44 AM Please respond to MQSeries List To:[EMAIL PROTECTED] cc: Subject:Re: Queue Indexing on Distributed Platforms In this context, distributed probably only means Windows and mainstream Unix. Dave -Original Message- From: David C. Partridge [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 15:42 To: MQSeries List Subject: RE: Queue Indexing on Distributed Platforms Rob As far as I know, based on my (possibly faulty) memory of some discussions with the Hursley folks a couple or three years back, the way the queue file on disk is constructed on distributed means that it is always indexed to some degree, however I defer to any MQ mavens who may know better. On 390, the way queues are stored on the page sets is such that indexing doesn't come free, and so it's configurable (with a cost as the QM starts up). Dave Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: Queue Indexing on Distributed Platforms
I'd always thought that on OS/390 pagesets etc. came with some indexing functionality provided by the operating system. It would seem logical (to me) that MQ makes use of that functionality rather than inventing it's own. Because the storage mechanism on OS/390 is so different, it might be that the indexing can be configured on different fields in the message. On the Windows/Unix platforms, the operating system does not provide such indexing facilities. Basically any data file (text file, html page, word document etc) are flat files like any other and contain a stream of bytes. The MQ software has no OS functionality to use so has to implement its own. Regards John Scott IBM Certified Specialist - MQSeries Argos Ltd -Original Message- From: Wyatt, T.rob [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 15:32 To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms Well, there is this from the manual... This parameter is supported only on z/OS. On other platforms, retrieval optimization might be provided, but it is not controlled by a queue parameter. So it might be there, but if it is you can't touch it. Unfortunately, I don't think this settles the question one way or the other! -- T.Rob -Original Message- From: MQSeries List [mailto:[EMAIL PROTECTED] Behalf Of Robert Broderick Sent: Wednesday, August 18, 2004 10:24 AM To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms R U sure??? I was told that indexing was ONLY available on the OS390. Maybe what you say is true. Maybe this is a pre 5.3 condition. From: David C. Partridge [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms Date: Wed, 18 Aug 2004 14:27:49 +0100 IIRC the queues are always indexed on distributed. Dave _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive ** Check our latest prices and full range at http://www.argos.co.uk The information contained in this message or any of its attachments may be privileged and/or confidential, and is intended exclusively for the addressee. Unauthorised disclosure, copying or distribution of the contents is strictly prohibited. The views expressed may not be official policy, but the personal views of the originator. If you have received this message in error, please advise the sender by using the reply facility in your e-mail software. All messages sent and received by Argos Ltd are monitored for viruses, high-risk file extensions, and inappropriate content. Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Re: Queue Indexing on Distributed Platforms
Since WMQ/zOS (and whatever other names it has) uses VSAM linear data sets for the queues, it can have an 'external' index set. The distributed platforms use flat files and there is no real index available. However, (trying to remember a pitch from the conference) there is a hash-type table that indexes the queues but only for a limited number of messages (I believe that number is 512). In some bacl k-level release (can't remember which one) I believe that number was about 1000 but has been reduced. If retrieving using msgid or correlid, the perfornance runs out at the 512 number and WMQ goes into a sequential seach pattern. Againn -- this is from somewhat faulty memory from a conference pitch. It would be helpful if one of the developers could jump in on this one with a clear answer. Jim John Scott wrote: I'd always thought that on OS/390 pagesets etc. came with some indexing functionality provided by the operating system. It would seem logical (to me) that MQ makes use of that functionality rather than inventing it's own. Because the storage mechanism on OS/390 is so different, it might be that the indexing can be configured on different fields in the message. On the Windows/Unix platforms, the operating system does not provide such indexing facilities. Basically any data file (text file, html page, word document etc) are flat files like any other and contain a stream of bytes. The MQ software has no OS functionality to use so has to implement its own. Regards John Scott IBM Certified Specialist - MQSeries Argos Ltd -Original Message- From: Wyatt, T.rob [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 15:32 To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms Well, there is this from the manual... This parameter is supported only on z/OS. On other platforms, retrieval optimization might be provided, but it is not controlled by a queue parameter. So it might be there, but if it is you can't touch it. Unfortunately, I don't think this settles the question one way or the other! -- T.Rob -Original Message- From: MQSeries List [mailto:[EMAIL PROTECTED] Behalf Of Robert Broderick Sent: Wednesday, August 18, 2004 10:24 AM To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms R U sure??? I was told that indexing was ONLY available on the OS390. Maybe what you say is true. Maybe this is a pre 5.3 condition. From: David C. Partridge [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Queue Indexing on Distributed Platforms Date: Wed, 18 Aug 2004 14:27:49 +0100 IIRC the queues are always indexed on distributed. Dave _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive ** Check our latest prices and full range at http://www.argos.co.uk The information contained in this message or any of its attachments may be privileged and/or confidential, and is intended exclusively for the addressee. Unauthorised disclosure, copying or distribution of the contents is strictly prohibited. The views expressed may not be official policy, but the personal views of the originator. If you have received this message in error, please advise the sender by using the reply facility in your e-mail software. All messages sent and received by Argos Ltd are monitored for viruses, high-risk file extensions, and inappropriate content. Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive