MQ XA transaction using DB2..getting 2372

2002-06-24 Thread Amit Gupta
Hi, I am using MQ 5.2 , DB2 7.1 on WinNT platform. I am trying to do XA transaction involving DB2. I have added the required entries in the resources tab of MQ queue manager. But I am getting the following error when I am trying to do MyQueueManager.begin() MQJE001: Completion Code 1, Reason

Retrieving a row of data from an external database?

2002-06-24 Thread Tina J.Kelly
Memo from Tina J Kelly of PricewaterhouseCoopers Start of message text Hi! I'm working with MQSI v2.0.2 and I'm trying to read several values from a database and set a variable to the return. In the manual it shows how to retrieve several values from a

Re: MQ vs Connect Direct

2002-06-24 Thread Ronald Weinger
Only if you want to list all the bells and whistles. I was referring to concept, not implementation details. Richard Tsujimoto [EMAIL PROTECTED]@AKH-Wien.AC.AT on 06/21/2002 04:15:52 PM Please respond to MQSeries List [EMAIL PROTECTED] Sent by:MQSeries List [EMAIL PROTECTED] To:

Re: Retrieving a row of data from an external database?

2002-06-24 Thread Ghosh, Shiladitya
Hi Tina, Tell you what..I faced the same problem and I got a workaround with it..what I did was take the result in an array and then assign a variable to the first element of the array in my loop.I am not aware about how effecient this is..but I'm still in the If-it-wrks-it'll-do phase in my

Re: IMS trigger

2002-06-24 Thread Ronald Weinger
Couln't check that since we didn't have one - a good indication that the trigger monitor is not set up. The IMS people we have have little MQ experience, and the MQ people have little IMS experience. If we do not use the IMS MQ header, IMS will run the transaction specified in the

Re: Retrieving a row of data from an external database?

2002-06-24 Thread Tina J.Kelly
Memo from Tina J Kelly of PricewaterhouseCoopers Start of message text Thanks very much for the reply, don't think I tried that. Will give it a go! Thanks, Tina. - End of message text This e-mail is sent by

Re: MQException 2030( MQRC_MSG_TOO_BIG_FOR_Q)

2002-06-24 Thread Chris A. Dahl
Lara, You will also have to set the maximum message size on your channel definitions on both sides. Give that a try and see if you get further. Regards, Chris Lara M magicinson@yaho To: [EMAIL PROTECTED] o.com

Re: Retrieving a row of data from an external database?

2002-06-24 Thread Tina J.Kelly
Memo from Tina J Kelly of PricewaterhouseCoopers Start of message text Hi Shiladitya, Could you possibly send a couple of lines of code to show how you did this. I've looked back at my notes and found that I couldn't create an array variable to accept

Re: Retrieving a row of data from an external database?

2002-06-24 Thread Raul Acevedo
SET OutputRoot.XML.Message = THE(SELECT T.column1, T.column2 FROM Database.table1 AS T); Your values will be in OutputRoot.XML.Message.column1 and OutputRoot.XML.Message.column2 Raul L. Acevedo IT Architect IBM Global Services 818-539-3203 Office (TL 396-3203) Glendale, CA 818-599-6626 Mobile

Re: Non threaded listener on Windows

2002-06-24 Thread Pavel Tolkachev
Paul, Can you please advice on the solution of this problem by defining more channels (e.g. one per a queue or application) and running them all as threads in one or several listener process(es)? Do you see any possible problem with it? As I wrote before many users beleive the DLQ would

Re: Retrieving a row of data from an external database?

2002-06-24 Thread Ghosh, Shiladitya
Hi Tina.. Declare sArray[] char; Declare temp char; WHILE Set sArray[2] = SELECT T.column1, T.column2 FROM Database.table1 AS T.. temp = sArray[0]; END WHILE; Yes we were using XML...of course the limitation is that we need to

Re: Non threaded listener on Windows

2002-06-24 Thread Rick Tsujimoto
I assumed a DLQ was available. Paul Clarke paulg_clarke@UTo: [EMAIL PROTECTED] K.IBM.COM cc: Sent by: Subject: Re: Non threaded listener on Windows

MS62: MQSeries - Linear log clean-up script

2002-06-24 Thread Bill Seng
Greetings, I downloaded the MS62: MQSeries - Linear log clean-up script SupportPac and found a comment regarding recovery log information being in the registry as of v5.1. The perl script only addresses using the qm.ini file - not the registry. Is anyone aware of any updates made to MS62 to

Re: QMGR names when using MQSI

2002-06-24 Thread Steve Sacho
While I appreciate the need to have QM naming convention reflect the underlying platform, I think it makes more sense to keep QM names the same for dev test and prod environments. This is for 2 basic reasons: 1] Many MQ admins rely on script generators such as SupportPac MS03 to save/clone an MQ

Re: IMS trigger

2002-06-24 Thread Miller, Dennis
The IMS bridge initiates the IMS transaction named in the beginning of the message. You need OTMA for the bridge, but not triggering. Note that the bridge transitions from the queue level to the message level, thus the embedded transaction name can be observed and used to initiate the desired IMS

SYSTEM.DEAD.LETTER.QUEUE on NT

2002-06-24 Thread Ryan Parmenter
We are running MQ 5.2 on NT. We are working on a dead letter handler that carry out specific functions (send e-mail, page, etc.) based on the message that arrives in the DLQ. Are there specific message attributes that my application can obtain to determine which queue the message was

NNSY Question

2002-06-24 Thread Hornby, Derek
When using NNSY 5.6 Rules and Formats under MQSI V2.1 on Solaris, I have the following problem.. The example is this: if I put messages in an input queue, every time an input message has a different message type, the reading of the queue gets delayed (sometimes up to 2 minutes) -- then ,

Re: SYSTEM.DEAD.LETTER.QUEUE on NT

2002-06-24 Thread Nii-Boi Kotei
I think the dead letter header (DLH) part of the message on the dead letter queue contains the information you are looking for; name of the intended queue... Nii-Boi Kotei Ryan Parmenter [EMAIL PROTECTED]@AKH-WIEN.AC.AT on 06/24/2002 03:07:35 PM Please respond to MQSeries List [EMAIL

Re: SYSTEM.DEAD.LETTER.QUEUE on NT

2002-06-24 Thread Stefan Sievert
Ryan, not sure if I totally understand the question, but I'll give it a try. Are there specific message attributes that my application can obtain to determine which queue the message was intended for? For example, if a message was supposed to go into Q1, but ended up in the DLQ, I may want to

MQGET with wait in CICS

2002-06-24 Thread Dye, Janet E
We have noticed that when a CICS program does a MQGET with wait, that during the time interval that the task is waiting, that it is using a lot of CPU resources. When I do a MQGET with wait in a batch environment, it does not appear to be using any resources during the wait. Has anyone else

Re: Clustering and changing qmgrs.

2002-06-24 Thread Conklin, William
John, Thanks John, let me clarify something. When the process is complete there will not be duplicate names. The current production system will be replaced with a new production system with the same name. The only difference is connection name. Thanks Bill C. -Original Message- From:

Re: MQGET with wait in CICS

2002-06-24 Thread Stefan Sievert
Janet, are you sure that the GET with wait in your application program is not implemented with a logic like this: while MQRC = 2033 (no msg avail.) MQGET nowait end This would explain the CPU hunger. I'd check the application to verify that the GMO_WAIT option with a reasonable WaitInterval

Compiling on Linux with g++

2002-06-24 Thread Donald Skidmore
I am trying to compile my c++ app on Redhat Linux 7.2 g++ version 2.96. The compiles work fine but linking the libraries fail. I am trying to use the client libraries. I am trying to use libraries imqb23gl.so, imqb23gl.so and imqic.so.It is not finding entries for CMqQFile and CMqsFormat. These