Storing MQRFH in Oracle
Hi, Has anyone stored a MQRFH in an Oracle database, and retrieved and re-parsed it, using WMQI's database and compute nodes. We have managed to store (and retrieve and re-parse) the MessageBody and elements of the MQRFH, but when we try the store, retrieve and reparse sequence on the MQRFH, it does not work. Or has anyone retrieved and re-processed a msg (including headers) that has been stored via the Warehouse Node? details are below v. grateful for any guidence. owen The RFH is in the following form (nb. the format can't be changed): RFH 0001 0052 MQSTR OPT_APP_GRP SWIFT_MSGS OPT_MSG_TYPE SW500_SwIC540 Our code is: to insert into database:- INSERT INTO Database.MSG_AUDIT_TEST(MSGID, ERROR_CODE, MSG, MQRFH, MQRFH_R) VALUES ( Body.FIN.SWBH.Sequence_Number, 77, BITSTREAM (Body), --defined as CLOB BITSTREAM (Root.MQRFH), defined as CLOB BITSTREAM (Root.MQRFH)); defined as RAW to extract:- SET OutputRoot.Properties = InputRoot.Properties; SET OutputRoot.MQMD = InputRoot.MQMD; SET OutputRoot.MQRFH = InputRoot.MQRFH; SET OutputRoot.Properties.MessageSet = 'DTI7DA007K001'; SET OutputRoot.Properties.MessageType = ''; SET OutputRoot.Properties.MessageFormat= 'SWIFT'; -- -- -- SUB MSG -- DATABASE UPDATE SET OutputLocalEnvironment.Msg = CAST ( THE (SELECT ITEM A.MSG FROM Database.MSG_AUDIT_TEST AS A WHERE A.MSGID = '123003') AS CHAR CCSID InputRoot.MQMD.CodedCharSetId Encoding InputRoot.MQMD.Encoding); DECLARE MyBitStream CHAR; SET MyBitStream = OutputLocalEnvironment.Msg; DECLARE MyEncoding INT; SET MyEncoding = 273; DECLARE MyCCSID INT; SET MyCCSID = 437; DECLARE MyDomain CHAR; SET MyDomain = 'MRM'; DECLARE MyMessageSet CHAR; SET MyMessageSet = 'DTI7DA007K001'; DECLARE MyMessageType CHAR; SET MyMessageType = ''; DECLARE MyMessageFormat CHAR; SET MyMessageFormat = 'SWIFT'; CREATE LASTCHILD OF OutputRoot domain MyDomain parse (MyBitStream, MyEncoding, MyCCSID, MyMessageSet, MyMessageType, MyMessageFormat ); --- above this line works. DECLARE ref REFERENCE TO OutputRoot.MRM; SET OutputLocalEnvironment.MQRFH = CAST ( THE (SELECT ITEM A.MQRFH_R FROM Database.MSG_AUDIT_TEST AS A WHERE A.MSGID = '123003') AS CHAR CCSID InputRoot.MQMD.CodedCharSetId Encoding InputRoot.MQMD.Encoding); SET MyBitStream = OutputLocalEnvironment.MQRFH; SET MyEncoding = 273; SET MyCCSID = 437; SET MyDomain = 'MQRFH'; CREATE PREVIOUSSIBLING OF ref domain MyDomain parse (MyBitStream, MyEncoding, MyCCSID ); This email is for the intended recipient only and is confidential. If you are not the intended recipient, please inform the sender immediately and delete this email and any copies, (including attachments), from your system. You should not read, copy or make any use of this email if you have received it in error. You should take whatever measures you deem to be appropriate to ensure that this email is virus free. CRESTCo Ltd does not give any representation, guarantee or warranty (whether expressed or implied) that this email has been securely transmitted or is accurate, timely or complete and excludes all liability in connection with this email or for any statements which are clearly the senders own and do not represent the views of CRESTCo Ltd. CRESTCo Ltd reserves the right to monitor the use and content of all emails. 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
News
U.S. to Sharply Cut Number of High-Tech Visas http://story.news.yahoo.com/news?tmpl=storyu=/nm/20030922/us_nm/life_usa_immigration_dc_4 _ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa 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
Euro symbol and WMQI
I have an xml which contain the euro symbol, EUR, and I can´t parse the xml. I created a message flow with MQInput and trace node and don´t get the euro symbol in my trace file. I have WMQI 2.1 CSD2 and MQ5.2 CSD4. Any clue? Thanks, 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: News
But Patrick Duffy, Human Resources Attorney for Intel Corporation, said finding the best-educated engineering talent from around the world was critical to his company's future. Maybe Intel should do a better job at educating Americans!!! Send their workers to school at the same time they do their normal jobs! Heck, hire me, send me back to school, and I will be twice as dedicated, determined, creative, and loyal knowing a company is willing to educate me in an area needed to keep the company ahead of the market! I already have most of those talents, just don't have the engineering that Intel probably is looking for yet! Chris |-+- | | Robert Broderick| | | [EMAIL PROTECTED]| | | OTMAIL.COM | | | Sent by: MQSeries| | | List | | | [EMAIL PROTECTED]| | | .AC.AT | | | | | | | | | 09/23/2003 05:11 | | | AM| | | Please respond to | | | MQSeries List | | | | |-+- --| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: News | | | --| U.S. to Sharply Cut Number of High-Tech Visas http://story.news.yahoo.com/news?tmpl=storyu=/nm/20030922/us_nm/life_usa_immigration_dc_4 _ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa 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: Euro symbol and WMQI
Manuel, I have an xml which contain the euro symbol, EUR, and I can´t parse the xml. I created a message flow with MQInput and trace node and don´t get the euro symbol in my trace file. I have WMQI 2.1 CSD2 and MQ5.2 CSD4. Any clue? What platform and codepage are you using? If I had to guess I'd say it's one that does not include the euro. Regards, Christopher Frank Sr. I/T Specialist - IBM Software Group IBM Certified Solutions Expert - Websphere MQ MQ Integrator Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008 e-mail: [EMAIL PROTECTED] 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
MQ Series Windows Client MS Excel
Has anyone used a MS Excel VBA Macro to save a spreadsheet onto a queue? It would seem quite a simple thing to do, but I've no idea where to start! I can't find anything on the IBM Support pack's website and nothing in the recent archives can anyone here help? Regards, Richard The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information, or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Although this e-mail and any attachments are believed to be free of any virus, or other defect which might affect any computer or system into which they are received and opened, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by MG for any loss or damage from receipt or use thereof. Please note that all e-mail messages are subject to interception for lawful business purposes. 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: Euro symbol and WMQI
What platform are you using and what code page is configured for the queue manager. We have successfully managed to use the Euro as long as we used the correct code page. We were on Windows and changed our default code page of 850 to 858 and it worked ok. You just need to make sure that all the code pages in your system are configured to be able to support the Euro, this may be a bigger issue, it was for us. We couldn't go to 300+ end points and change the code pages without doing extensive testing, in the end we avoided using the Symbol. Hope this helps. Rodríguez Alvarez-Querol, Manuel Carlos [EMAIL PROTECTED] Sent by: MQSeries List [EMAIL PROTECTED] 23-Sep-2003 12:09 Please respond to MQSeries List [EMAIL PROTECTED] To:MQSERIES cc: Subject:Euro symbol and WMQI I have an xml which contain the euro symbol, EUR, and I can´t parse the xml. I created a message flow with MQInput and trace node and don´t get the euro symbol in my trace file. I have WMQI 2.1 CSD2 and MQ5.2 CSD4. Any clue? Thanks, 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
triggering question for type every
I can't find my notes for this scenario, so if it seems like deja vu all over again, sorry about that. The question is if trigtype=every is used and the triggered application ends before it attempts any MQ operations, does MQ generate another TM for the application message that has yet to be processed? In other words, would a triggering loop occur? 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: triggering question for type every
No loop. You wont get retriggered unless another message lands, or you turn trigger control on and off, or the init queue is disabled/ enabled, or the QM is bounced. -Original Message- From: Rick Tsujimoto [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 11:07 AM To: [EMAIL PROTECTED] Subject: triggering question for type every I can't find my notes for this scenario, so if it seems like deja vu all over again, sorry about that. The question is if trigtype=every is used and the triggered application ends before it attempts any MQ operations, does MQ generate another TM for the application message that has yet to be processed? In other words, would a triggering loop occur? 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 attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies. 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
WMQI v2.1 CSD 5 - Transactional Rollback
Fubar! I need your help in answering a simple question about transactional rollback in WMQI v2.1 CSD 5. Does transactional rollback occur when the MQInput node's failure terminal is wired, but the catch terminal is not? Chris 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: WMQI v2.1 CSD 5 - Transactional Rollback
Chris, Does transactional rollback occur when the MQInput node's failure terminal is wired, but the catch terminal is not? If by rollback you mean will control pass down the failure path, the answer is Yes. Regards, Christopher Frank Sr. I/T Specialist - IBM Software Group IBM Certified Solutions Expert - Websphere MQ MQ Integrator Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008 e-mail: [EMAIL PROTECTED] 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: MQ Series Windows Client MS Excel
There's a mqax example in C:\Program Files\IBM\WebSphere MQ\Tools\mqax\Samples\excel. It should do what your are looking for. -Original Message- From: Richard Bellis [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 9:27 AM To: [EMAIL PROTECTED] Subject: MQ Series Windows Client MS Excel Has anyone used a MS Excel VBA Macro to save a spreadsheet onto a queue? It would seem quite a simple thing to do, but I've no idea where to start! I can't find anything on the IBM Support pack's website and nothing in the recent archives can anyone here help? Regards, Richard The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information, or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Although this e-mail and any attachments are believed to be free of any virus, or other defect which might affect any computer or system into which they are received and opened, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by MG for any loss or damage from receipt or use thereof. Please note that all e-mail messages are subject to interception for lawful business purposes. 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: Losing Message Sequence Number Sync
NO!!! Only one IP address. That's the whole point of the F5 Big IP. The sending Queue Manager (supposedly) knows nothing about the two receivers. -Original Message- From: Chan, Ian M [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 8:59 PM To: [EMAIL PROTECTED] Subject: Re: Losing Message Sequence Number Sync I don't know about the F5 BigIP. However, are the 2 unix boxes running different IP addresses? Regards, Ian 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
WMQI/MQSeries Job Opportunity - NORTHERN VIRGINIA
Title: Message Hi All: I just wanted to remind you that I have an opportunity available for anyone who is interested - mid-level and senior level position(s)!Looking for a Senior MQSI (WMQI) Systems Engineer to support a modernization project in Northern VA to support the Department of Homeland Security!The senior level person must have 8-10 years of exp including 5 years of related IT/middleware experience and the mid-level person must have 5 years of work experience. All candidates should have the following experience (+/-) a year.At least two-four years experience developing WMQI/MQ applicationsProficient at defining MQ Queues, channels, clustersAt least four years experience developing middleware applications/integration services with mainstream eAI toolsExperience integrating EDI (e.g., X.12, UN/EDIFACT) for business-to-business applications desirableExperience integrating mainstream relational database (e.g., Oracle, IBM DB2, Microsoft SQLServer)ALL candidates must also have at least a Bachelor's degree in related field or equivalent experience. Also candidate must be willing to have a background check as well as be able to obtain a clearance with no delay. ONLY US CITIZENS AND US PERMANENT RESIDENTS can apply to this opportunity.PLEASE SEND RESUMES TO [EMAIL PROTECTED]THANK YOU! image001.gif
Re: News
Well, I'm gonna chip in my $0.02 (and then hopefully I'll shut up). I can safely speak from both sides of the fence... I came over (well, actually I was bought over) to the US in late 1990 from the UK, to work on an IBM project for the State Of California. I was interviewed and recruited in England and landed in Sacramento with an H-1 visa in hand. The project was an OS/2-based system. There was a bunch of other Brits also recruited and we were subcontracted to IBM though an agency. I later found out we we're being paid significantly less that the home grown talent. No surprises there. I am now a fully fledged permanent resident, only a few steps away from US citizenship. Over the recent few years I have had both the good fortune (in most cases) and bad fortune (in a few, rare, cases) to work with others who are now in the situation I was in. Whilst the H-1/H-1B workers are, by and large, intelligent and hard working, almost without exception they are also (and most importantly) - CHEAP. If any executive says anything else (s)he is only telling a small part of the story. The NUMBER ONE reason that high tech execs want to maintain a high visa limit is to have available a larger pool of CHEAP labour. In my opinion, the reduction in the limit of visas will not limit the trend of high tech projects to move off-shore, but it may make it somewhat less cost-effective and may somewhat slow things down. But, let's face it, businesses exist to MAKE MONEY. They do this by maximising the return on investments. As long as GOOD off-shore workers are available at a reasonable rate of pay, local talent will barely get a look-see. Anyway... enough rambling. Please do not adjust your set... normal transmissions will be resumed shortly. Regards, Antony Boggis. -- What Patrick Duffy *really meant* to say was: But Patrick Duffy, Human Resources Attorney for Intel Corporation, said finding the best-educated, CHEAP, engineering talent from around the world was critical to his company's future. 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: Stop Trigger Monitor
I agree with Peter. That way triggering can continue to work for other queues. -Original Message- From: Potkay, Peter M (PLC, IT) [SMTP:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 8:41 AM To: [EMAIL PROTECTED] Subject: Re: Stop Trigger Monitor 1) disable and enable the gets on the initiation queue. GET(DISABLED)GET(ENABLED) If i use this method where do the messages accumulate? on the local or initq? On the local queue. When the gets are enabled will the trigger montior start to submit the batch jobs again? Depends on what happened to the TM when you disabled the init queue. If it ended, you will need to restart it. If it went into a retry mode, you should be good to go. 2) turn on and off the trigger set option on the local queue. I would do it this way. -Original Message- From: Brent Ireland [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 10:50 AM To: [EMAIL PROTECTED] Subject: Stop Trigger Monitor Hello all, I would like to be able to stop the arrival of a message on a queue from triggering a batch jcl to be submitted. i have set up a local queue with the following trigger definition: Trigger Definition Trigger type . . . . . . . : F F=First,E=Every,D=Depth,N=None Trigger set . . . . . . : Y Y=Yes,N=No Trigger message priority : 0 0 - 9 Trigger depth . . . . . : 1 1 - 9 Trigger data . . . . . . : Process name . . . . . . : TRIGGER.PROCESS Initiation queue . . . . : TRIGGER.INITIATION.QUEUE I have a batch trigger monitor program waiting for a message to arrive on the initiation queue. When a message arrives it submits a batch job. What i would like to do is stop the trigger process then runs some batch jobs and then start the trigger process again. I read about a few possible options: 1) disable and enable the gets on the initiation queue. GET(DISABLED) GET(ENABLED) if i use this method where do the messages accumulate? on the local or initq? when the gets are enabled will the trigger montior start to submit the batch jobs again? 2) turn on and off the trigger set option on the local queue. Could someone please suggest the preferred method? Thank you in advance. Brent Ireland CAE Inc. 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 attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies. 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: WMQI v2.1 CSD 5 - Commit for message flow question
We handle our DB errors with Try/Catch nodes. Our time out is set for 53 seconds, so our processing takes on a different business nature than yours. The process has the option of not having to reprocess or return an error in the event of a failure. The design / architecture inherently handles no responses. This is a financial transaction system and messages lost in the great expanse between the front-end and back again are handled quite elegantly. So messages where DB or other physical errors are incurred are sent to an ERROR and ALERT queue for investigations related to problem resolution rather than transaction reprocessing. bobbee From: Christopher D. Fryett [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: WMQI v2.1 CSD 5 - Commit for message flow question Date: Sun, 21 Sep 2003 10:42:37 -0500 Yes, the stored procedure sends back a return code and message associated with a return code. The standard SQLCODE and SQLSTATE are not being passed back though, so I lose out on retrieving the actual error. Due to this reason we have designed it in a way that if an error occurs within the stored proc we throw an ESQL user exception. Or have a filter node look at the response in an environment variable and then return false if an error occurs within. That error path would then handle capturing certain aspects of the error and store it off in a queue/table. From talking with others it seems or is that in order to truly obtain a transactional rollback the message has to return to the MQInput node. The failure terminals of all nodes, and Try/Code terminal/node also can not be wired to achieve this. If they are wired WMQI assumes the failure/catch path of the message flow will handle the error and no transactional rollback will occur. So, this kills the overall concept of capturing the error and storing it off in a queue/table for later manual review if necessary. The other possible solution I have is to allow the backout from the MQInput node to resolve the problem by putting the message to the backout queue which could be monitored by one of the monitoring tools currently available inhouse. If a message shows up on the queue, force an alert, and either manually or automatically process it. The final option is to put the 2 or more SQL stored procedures in one (actually that one would call the others), and then have it resolve the possible failures of the individual stored proc calls. Finally, just have the compute node or database node do what the stored procedures are doing, but that added further work and time that may not be available. I guess I forgot that in order to get a true transactional rollback all things have to return back to the MQInput Node where no further path is wired to prevent this. I always thought it just had to return to the MQInput Node, and then I could wire the failure node to capture or act upon the rollback. Guess not. It sure would be nice to directly call ROLLBACK or COMMIT in the compute node! Still learning, Chris -Original Message- From: MQSeries List [mailto:[EMAIL PROTECTED] On Behalf Of Robert Broderick Sent: Friday, September 19, 2003 3:15 PM To: [EMAIL PROTECTED] Subject: Re: WMQI v2.1 CSD 5 - Commit for message flow question Is there a way for the stored procedure to communicate back to the node. From: Christopher Fryett [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: WMQI v2.1 CSD 5 - Commit for message flow question Date: Fri, 19 Sep 2003 14:10:02 -0500 The compute node only has a Transactional Mode for Automatic/Commit. There is a checkbox for throwing an exception for a Database error,but in my case I wouldn't get it directly because the stored procedure is wrapping the SQL calls. So, the stored procedure could succeed even though in it an insert failed. To the compute node the call to the stored procedure succeeded so no exception would be created. Now, if the call in the compute node failed because it couldn't access the stored procedure due to permissions than a database exception would occur and the failed terminal wiring would be activated. Otherwise it would go back to the beginning of the flow, i.e. MQInput Node. Arg!!! Thanks, Chris |-+- | | Robert Broderick| | | [EMAIL PROTECTED]| | | OTMAIL.COM | | | Sent by: MQSeries| | | List | | | [EMAIL PROTECTED]| | | .AC.AT | | | | | | | | | 09/19/2003 01:23 | | | PM| | | Please respond to | | | MQSeries List | | | | |-+-
Re: WMQI v2.1 CSD 5 - Transactional Rollback
No, I mean that a transactional rollback will occur first, i.e. any inserts will be removed from a database, and then the failure terminal will kick in. Thank you, Chris |-+ | | Christopher | | | Frank | | | [EMAIL PROTECTED]| | | COM | | | Sent by: | | | MQSeries List | | | [EMAIL PROTECTED]| | | n.AC.AT | | || | || | | 09/23/2003 11:48 | | | AM | | | Please respond to| | | MQSeries List | | || |-+ --| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: WMQI v2.1 CSD 5 - Transactional Rollback | | | --| Chris, Does transactional rollback occur when the MQInput node's failure terminal is wired, but the catch terminal is not? If by rollback you mean will control pass down the failure path, the answer is Yes. Regards, Christopher Frank Sr. I/T Specialist - IBM Software Group IBM Certified Solutions Expert - Websphere MQ MQ Integrator Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008 e-mail: [EMAIL PROTECTED] 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
API Exerciser - MQ 1st Steps - Client Mode
I find the API Exerciser really handy sometime to test out some of the less used API options, as I find it has 100% of the MQ options available to choose. However, sometimes I need to run a test as a client to see how an MQ client would behave. Is there any way to make it run as an MQClient? If no, is there a free support pac that would provide this functionality (it would have to have 100% of the possible MQ API options like the exerciser does.) Peter Potkay MQSeries Specialist The Hartford Financial Services [EMAIL PROTECTED] x77906 IBM MQSeries Certified This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies. 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: WMQI v2.1 CSD 5 - Transactional Rollback
Chris, No, I mean that a transactional rollback will occur first, i.e. any inserts will be removed from a database, and then the failure terminal will kick in. In WMQI the scope of a transaction is the message flow. That would include actions taken on any failure paths. Can I ask what action(s) are you taking on the failure path that cannot be performed before the rollback occurs? It is possible to have the failure path actions outside of the transaction, but they will still be executed before the transactional rollback occurs. Regards, Christopher Frank Sr. I/T Specialist - IBM Software Group IBM Certified Solutions Expert - Websphere MQ MQ Integrator Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008 e-mail: [EMAIL PROTECTED] 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: WMQI 2.1 Database Connection Pool
Jas, The broker acquires connections by threadID and ODBC Data Source Name (DSN). So, if multiple nodes in a flow use the same DSN then they will share the same connection. Regards, Gary -- Gary J. Ward WebSphere MQ Architect Information Design, Inc. A Premier IBM Business Partner Hi All we have designed a message flow in WMQI v2.1 consisting of 10 compute nodes and each node needs a database connection for database operation . My question here is that would the broker maintain 10 connections with the database or it would maintain some kind of the Pool from where it gets and releases the connection once the database operation is complete . Thanks Jas 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: WMQI 2.1 Database Connection Pool
Jas, The connections are by thread (flow), not by node. So if you run Additional Instances *I believe* you'll have extra connections. But if you only run one instance, it's one connection per ODBC DSN. Regards, Gary Gary, Thanks for the reply , Compute nodes in all our flows use the same ODBC DSN , does that mean that all the nodes will be using the same database connection ? I hope not and as you mentioned the ThreadID should be playing a role here . Does the broker create a new thread for each flow ? -Jas 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
PUT date time stamp
Hi If there any way to change the PUT date/timp stamp from GMT to EST? Brent Ireland CAE Inc. Global Information Technology Dept J8 Supply Chain Programmers Group Tel : (514) 341-6780 Ext. 2745 Télécopieur : (514) 734-5605 Courriel : [EMAIL PROTECTED] 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: PUT date time stamp
Subtract 5 hours...4 after sometime in Oct (tee hee hee) From: Brent Ireland [EMAIL PROTECTED] Reply-To: MQSeries List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: PUT date time stamp Date: Tue, 23 Sep 2003 18:18:08 -0400 Hi If there any way to change the PUT date/timp stamp from GMT to EST? Brent Ireland CAE Inc. Global Information Technology Dept J8 Supply Chain Programmers Group Tel : (514) 341-6780 Ext. 2745 Tilicopieur : (514) 734-5605 Courriel : [EMAIL PROTECTED] 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 _ Instant message in style with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com 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
