Re: Monitor a file and put to Q
We had a similar requirement in our AS/400 applications to send any changed/deleted/added records from certain files as an MQ message. We use the DB2/400 database triggers as the mechanism to initiate the process. Because of the issues involved with database triggers, we wrote a Generic Database Trigger process that is file driven and offers more flexibility than using the DB2/400 db trigger directly. All the application programmer needs to do is turn on the database trigger(s) for the desired files, add a record to a Trigger Control File that contains information about the program to call, and write a simple program to Put the MQ message. I would have liked them to use a single generic program to PUT the entire record out as a message, but the different applications had different requirements and wanted to control it themselves, so they write the programs that PUT the messages. I've attached the documentation that we give to the application programmers that describes how to use the Generic Database Trigger process. If you are interested in the source for the RPGLE program, let me know. It contains only the db trigger handling process, not the MQ PUT process. Lynn -Original Message-From: MQSeries List [mailto:[EMAIL PROTECTED]On Behalf Of eai grpSent: Thursday, May 29, 2003 7:06 PMTo: [EMAIL PROTECTED]Subject: Re: Monitor a file and put to Q oh I wish we could ask them to do that, but why would the applications even want to adapt. So from what you all suggest , there is nothing already available and we should write one. Tim Armstrong <[EMAIL PROTECTED]> wrote: Can you modify the application to generate the MQ message at the time itwrites to the file? Much simpler if you can.RegardsTim Aeai grp<[EMAIL PROTECTED] To: [EMAIL PROTECTED]> cc:Sent by: MQSeries Subject: Monitor a file and put to QList<[EMAIL PROTECTED]N.AC.AT>30/05/2003 06:52Please respond toMQSeries ListHi All,I have a requirement , where in an application writes to an AS/400 file andI need a tool/software?adapter that monitors this file and writes thismodified line into an MQSeries Queue.Is there something already availableor If I should write one, pls gimme a few tips if I need to Poll or trigger(Performance Issues) etc.Pls SuggestThank In AdvanceDo you Yahoo!?Free online calendar with sync to Outlook(TM).Instructions for managin g your mailing list subscription are provided inthe Listserv General Users Guide available at http://www.lsoft.comArchive: http://vm.akh-wien.ac.at/MQSeries.archive Do you Yahoo!?Free online calendar with sync to Outlook(TM). IFDBTRG_GenericDBTrigger.doc Description: MS-Word document
Re: Monitor a file and put to Q
Do you have Tivoli in your shop. There is a LOG File agent that Tivoli has. It will monitor a file looking for specific stuff you tell it to look for. Now the problem may be the action it takes when it gets a hit. I no it will send up a SNMP alert. If it can do additional things you will have to investagate. I would suspect that if it is robust there are additional options. Like starting a control procedure which could execute one of the supplied samples to write a message to a queue. bobbee From: eai grp <[EMAIL PROTECTED]> Reply-To: MQSeries List <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Monitor a file and put to Q Date: Thu, 29 May 2003 13:52:24 -0700 Hi All, I have a requirement , where in an application writes to an AS/400 file and I need a tool/software?adapter that monitors this file and writes this modified line into an MQSeries Queue.Is there something already available or If I should write one, pls gimme a few tips if I need to Poll or trigger (Performance Issues) etc. Pls Suggest Thank In Advance - Do you Yahoo!? Free online calendar with sync to Outlook(TM). _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail 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: Monitor a file and put to Q
oh I wish we could ask them to do that, but why would the applications even want to adapt. So from what you all suggest , there is nothing already available and we should write one. Tim Armstrong <[EMAIL PROTECTED]> wrote: Can you modify the application to generate the MQ message at the time itwrites to the file? Much simpler if you can.RegardsTim Aeai grp<[EMAIL PROTECTED] [EMAIL PROTECTED]> cc:Sent by: MQSeries Subject: Monitor a file and put to QList<[EMAIL PROTECTED]N.AC.AT>30/05/2003 06:52Please respond toMQSeries ListHi All,I have a requirement , where in an application writes to an AS/400 file andI need a tool/software?adapter that monitors this file and writes thismodified line into an MQSeries Queue.Is there something already availableor If I should write one, pls gimme a few tips if I need to Poll or trigger(Performance Issues) etc.Pls SuggestThank In AdvanceDo you Yahoo!?Free online calendar with sync to Outlook(TM).Instructions for managin g your mailing list subscription are provided inthe Listserv General Users Guide available at http://www.lsoft.comArchive: http://vm.akh-wien.ac.at/MQSeries.archive Do you Yahoo!? Free online calendar with sync to Outlook(TM).
Re: Monitor a file and put to Q
Hi eaigrp, you can write a DB2/400 stored procedure that MQPUT1 a message with the modifies record. a good starting point will be the MQ samples shipped with the product, see QMQM/QRPGSRC or whatever language who choose. HTH, Luc-Michel. > > Hi All, > > I have a requirement , where in an application writes to an AS/400 file and I need a > tool/software?adapter that monitors this file and writes this modified line into an > MQSeries Queue.Is there something already available or If I should write one, pls gi > mme a few tips if I need to Poll or trigger (Performance Issues) etc. > Pls Suggest > > Thank In Advance > > > > > > - > Do you Yahoo!? > Free online calendar with sync to Outlook(TM). -- Luc-Michel Demey - Freelance EAI Consultant Paris / France Tel. : +33 6 08 755 655 http://consulting.demey.org/ - lmd at demey dot org 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: Monitor a file and put to Q
Hi If you talk about an AS/400 file - what do you really mean ? Does your application write to a database file (physical file) or to a file in the integrated file system ? As far as I know, there is nothing available - except the standard MQSeries samples (C, Cobol, RPG). For the first case you can setup a database trigger (after update / after insert ) that gets the changed data and puts it in a queue. How to code ? - depends mainly on change frequency. If you expect a high change rate, you should think about a service program that maintains the connection to the queue manager and the queue(s) and that will then wait for data from your database trigger. I'm not very sure about transaction scope if you code MQ calls directly into a database trigger program - the trigger itself should be part of the database transaction. Joerg Wende Consult. IT Specialist / Business Integration IBM SWG Technical Sales Central (Mitte) |-+> | | eai grp | | | <[EMAIL PROTECTED]| | | >| | | Sent by: MQSeries| | | List | | | <[EMAIL PROTECTED]| | | N.AC.AT> | | || | || | | 29.05.2003 22:52 | | | Please respond to| | | MQSeries List| | || |-+> >| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Monitor a file and put to Q | | | | | >| Hi All, I have a requirement , where in an application writes to an AS/400 file and I need a tool/software?adapter that monitors this file and writes this modified line into an MQSeries Queue.Is there something already available or If I should write one, pls gimme a few tips if I need to Poll or trigger (Performance Issues) etc. Pls Suggest Thank In Advance Do you Yahoo!? Free online calendar with sync to Outlook(TM). 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: Monitor a file and put to Q
Can you modify the application to generate the MQ message at the time it writes to the file? Much simpler if you can. Regards Tim A eai grp <[EMAIL PROTECTED]To: [EMAIL PROTECTED] >cc: Sent by: MQSeriesSubject: Monitor a file and put to Q List <[EMAIL PROTECTED] N.AC.AT> 30/05/2003 06:52 Please respond to MQSeries List Hi All, I have a requirement , where in an application writes to an AS/400 file and I need a tool/software?adapter that monitors this file and writes this modified line into an MQSeries Queue.Is there something already available or If I should write one, pls gimme a few tips if I need to Poll or trigger (Performance Issues) etc. Pls Suggest Thank In Advance Do you Yahoo!? Free online calendar with sync to Outlook(TM). 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
Monitor a file and put to Q
Hi All, I have a requirement , where in an application writes to an AS/400 file and I need a tool/software?adapter that monitors this file and writes this modified line into an MQSeries Queue.Is there something already available or If I should write one, pls gimme a few tips if I need to Poll or trigger (Performance Issues) etc.Pls Suggest Thank In Advance Do you Yahoo!? Free online calendar with sync to Outlook(TM).