Sorry, no. Perhaps Morag H. would care to comment. -- Rebecca -----Original Message----- From: Bahman Nejad [mailto:Bahman.Nejad@;UBOC.COM] Sent: Tuesday, October 29, 2002 4:30 PM To: [EMAIL PROTECTED] Subject: Re: SYSTEM.CHANNEL.SYNCQ
Thanks Rebecca, I'll go through your suggested path and delete the messages that belong to non-existing channels. But, while I am not adding any new channel, I see this queue is growing. Any idea why? "Bullock, Rebecca (CSC)" <[EMAIL PROTECTED]>@AKH-Wien.AC.AT> on 10/28/2002 02:32:24 PM Please respond to MQSeries List <[EMAIL PROTECTED]> Sent by: MQSeries List <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: SYSTEM.CHANNEL.SYNCQ Ok, here's an idea. You need to keep these messages if they pertain to an existing channel. And you can get a list of channels easily enough using CSQUTIL. So -- write something that does the following: 1) Print the SYNCQ messages using the sample browse program (the Cobol program with the impossible to remember name CSQ4????). Put the output into a dataset (generally, the DDname is SYSOUT, but it will depend upon your Cobol customization parms; for example, we write to SYSOUX here). Note: I'd suggest modifying the program slightly to print out the msgid, too; you can use this below to delete the messages. This is file A 2) Run CSQUTIL to get a list of the current channels, again writing the output to a dataset. This is file B 3) Now write a quick&dirty to pick up the columns from file A where the channel names resides and the columns from file B where the channel names reside. Now do a match/merge and write out the channel names in file A that don't reside in file B. Sounds like the perfect opportunity for a simple SAS program to me. Depending on the version of SAS you are using, you can use it to delete the unnecessary messages (V6 included a SAS/MQ interface as part of the base product; it wasn't pretty, but it did work). Or delete them manually once you have the list of which channels you don't need. For testing -- Dump the queue to a flat file and reload it to a new queue where it won't matter if you wipe the wrong messages! -- Rebecca -----Original Message----- From: Bahman Nejad [mailto:Bahman.Nejad@;UBOC.COM] Sent: Monday, October 28, 2002 11:16 AM To: [EMAIL PROTECTED] Subject: SYSTEM.CHANNEL.SYNCQ The number of messages in our SYSTEM.CHANNEL.SYNCQ is growing and I need to purge its un-needed messages before it causes any problem for us. I have been unable to find a way to determine which messages are needed which messages are not. Does anyone out there have any experience with this issue? We are running MQ for OS/390 V2.1. Thanks **************************************************************************** ** This communication (including any attachments) may contain privileged or confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this communication and/or shred the materials and any attachments and are hereby notified that any disclosure, copying, or distribution of this communication, or the taking of any action based on it, is strictly prohibited. Thank you. 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 ************************************************************************** This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited. Thank you for your compliance. 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 **************************************************************************** ** This communication (including any attachments) may contain privileged or confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this communication and/or shred the materials and any attachments and are hereby notified that any disclosure, copying, or distribution of this communication, or the taking of any action based on it, is strictly prohibited. Thank you. 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 ************************************************************************** This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited. Thank you for your compliance. 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