Francois Van der Merwe1/South Africa/IBM is out of the office.

[Francois Van der Merwe1]

I will be out of the office starting January 1, 2003 and will not return
until January 7, 2003.

I'm on leave at the moment.  For urgent business, please leave a message on
0825569467

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

Seek comment on MQ Certification

[K K]

Dear MQers,
Have you attended MQ certification?   Do you find it useful?  
Which of them are most useful?  How to prepare for it?  Is it possible 
to prepare without attending IBM classes?
K K

Re: Version 5.2 end of service

[Rick Tsujimoto]

Peter,

I recently bought 2 CU's for V5.2 and I was able to ask for the V5.3 media
for free.  If support was not included, or if I let my support period
lapse, I wouldn't be able to ask for the V5.3 media.  I'm sure with sales,
there are many ways to wangle what you want.





  Peter Heggie
cc:
  Sent by: Subject: Re: Version 5.2 end of service
  MQSeries List
  


  12/31/2002 12:25
  PM
  Please respond
  to MQSeries List





I question that also.. is it that when you buy WMQ capacity units, say with
a two year term, that you buy the right to get free upgrades (new versions)
for two years, but that service/support is an entirely different matter?
That you must purchase a support contract like Passport Advantage or
SupportLine to get support from IBM. And that this support is only in
effect while the version of WMQ is not yet at end of service?




From: Prithwiraj Basu <[EMAIL PROTECTED]> on 12/31/2002 12:00 PM

Please respond to MQSeries List <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:

Subject:  Re: Version 5.2 end of service

Can someone educate me about the meaning of this?  Does that mean if my
company have apps using MQ 5.2, we have to upgrade or we don't get any IBM
support in the eventuality of a problem?  What are the exact ramifications?

Thanks.

Prits

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

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

Network Domain Userid

[Narasimha reddy.V]

Hi all
In windows NT I have added a user id in my network domain to the Administrators group & mqm group on my machine. But with this user id I can only start & stop the Qmanagers. I cannot see the Qs or other objects. I get the following error AMQ4036 (insufficient authority) 
Any idea what the problem could be ??? 
With RegardsReddy
 Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

Re: Version 5.2 end of service

[Jeff A Tressler]

Not only must you pay for support, but no more support fixes (CSD)
will be released.

Jeff Tressler

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: end of service for MQ 5.2

[john gilmore]

Prithwiraj,   It means what it says.  IBM support will not be available after 2003 December 31.  This is routine for all IBM software.  You must assess whether or not you think you will need this support.  If you think you will, you should migrate to Websphere MQ before the end of 2003.  If not, you can perhaps delay this migration for a time but not indefinitely.     Whatever you decide you must plan to move to new releases periodically. John GilmoreSystemCraft LLCThe opinions expressed above are mine alone. In particular, they are not necessarily shared by my company or its clients.

Re: Version 5.2 end of service

[Rick Tsujimoto]

You'll have to upgrade if you want to receive support.  Also, it'll cost
you.  Typically, support is free for the first year when you purchase the
capacity units for a given machine.  After that, you either pay for annual
support, or you live without it.




  Prithwiraj Basu
  cc:
  Sent by: Subject: Re: Version 5.2 end of service
  MQSeries List
  


  12/31/2002 12:00
  PM
  Please respond
  to MQSeries List





Can someone educate me about the meaning of this?  Does that mean if my
company have apps using MQ 5.2, we have to upgrade or we don't get any IBM
support in the eventuality of a problem?  What are the exact ramifications?

Thanks.

Prits

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: Version 5.2 end of service

[Peter Heggie]

I question that also.. is it that when you buy WMQ capacity units, say with
a two year term, that you buy the right to get free upgrades (new versions)
for two years, but that service/support is an entirely different matter?
That you must purchase a support contract like Passport Advantage or
SupportLine to get support from IBM. And that this support is only in
effect while the version of WMQ is not yet at end of service?




From: Prithwiraj Basu <[EMAIL PROTECTED]> on 12/31/2002 12:00 PM

Please respond to MQSeries List <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:

Subject:  Re: Version 5.2 end of service

Can someone educate me about the meaning of this?  Does that mean if my
company have apps using MQ 5.2, we have to upgrade or we don't get any IBM
support in the eventuality of a problem?  What are the exact ramifications?

Thanks.

Prits

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: Version 5.2 end of service

[Prithwiraj Basu]

Can someone educate me about the meaning of this?  Does that mean if my
company have apps using MQ 5.2, we have to upgrade or we don't get any IBM
support in the eventuality of a problem?  What are the exact ramifications?

Thanks.

Prits

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: ebcdic to ascii conversion in MQseries

[Beinert, William]

There is no built-in facility to convert message on PUT.

MQ will do it for you either:
When the receiving application GETs the message (if MQGMO_CONVERT is specified on the 
GET)
or
In the channel (which can be wasteful if the message hops through several queue 
managers on the way to it's destination).

Bill

-Original Message-
From: Manish Sharma [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 10:43 AM
To: [EMAIL PROTECTED]
Subject: Re: ebcdic to ascii conversion in MQseries


I would like to know if there is any way of converting it while message is
PUT from IBM to ASCII or any format which does not give junk on solaris.



-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of Gutekunst,
Brant
Sent: Tuesday, December 31, 2002 5:43 PM
To: [EMAIL PROTECTED]
Subject: Re: ebcdic to ascii conversion in MQseries



I'd like to add that the preferred method is to do the conversion on the
get, rather than on the channel.



In either case, you also need to make sure that the Format of the message is
MQFMT_STRING.



-Original Message-
From: John Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 5:23 AM
To: [EMAIL PROTECTED]
Subject: Re: ebcdic to ascii conversion in MQseries



Have a look at the MQGMO_CONVERT option for the get message options when you
read the message. This will convert from the mainframe charset to the
Solaris charset for you.



If you can't change the program that gets the messages, you can change the
channel definition between mainframe and Solaris to do the convertion on the
messages that get transferred. You'll find this on the CONVERT option of a
channel definition, something like:



ALTER CHL(MFQM.TO.SOLARISQM) CONVERT(YES)

Regards
John Scott
Senior Middleware Technical Specialist
Argos Ltd

-Original Message-
From: Manish Sharma [mailto:[EMAIL PROTECTED]]
Sent: 31 December 2002 10:14
To: [EMAIL PROTECTED]
Subject: ebcdic to ascii conversion in MQseries

Hi,

We have a setup wherein we communicate between two applications using

MQseries 5.1 installed on sunsolaris and MQSeries on mainframes. When any

message is written from mainframes and read from Unix local queue we get
junk characters.

I have heard that some X format to ASCII conversion is required on message.

It would be very helpful if someone can let us know.

1> What is this X format.

2> Do we have to do this conversion programatically or just set the property

in a queue.

3> Any other methods by which i can achieve this.



-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of Rosangela
Andrade
Sent: Tuesday, December 31, 2002 2:27 PM
To: [EMAIL PROTECTED]
Subject: Trigger

I have a program that of the one get browse in the DLQ and later records
another line with in syncponit. However when cics falls, in the following
day it comes back to record the same messages of the DLQ in the other line.
Please, as I make this not to happen

Tia



Rosangela






  _


Busca Yahoo!  
O melhor lugar para encontrar tudo o que vocj procura na Internet



**

Click here to visit the Argos home page http://www.argos.co.uk

The information contained in this message or any of its attachments may be
privileged and confidential, and is intended exclusively for the addressee.
The views expressed may not be official policy, but the personal views of
the originator.
If you are not the intended addressee, any disclosure, reproduction,
distribution, dissemination or use of this communication is not authorised.
If you have received this message in error, please advise the sender by
using your reply facility in youe e-mail software.
All messages sent and received by Argos Ltd are monitored for virus, high
risk file extensions, and inappropriate content. As a result users should be
aware that mail maybe accessed.

**


CONFIDENTIALITY NOTICE: This E-Mail transmission may contain confidential or
legally privileged information that is intended only for the individual(s)or
entity(ies) named in the E-Mail address. If you are not the intended
recipient, you are hereby notified that any disclosure, copying,
distribution, or reliance upon the contents of this E-Mail is strictly
prohibited. If you have received this E-Mail transmission in error, please
reply to the sender so that arrangements can be made for proper delivery,
after which please delete the message from your inbox. 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

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: Version 5.2 end of service

[Bruce Olsen]

You can find the end of service dates by platform at
http://www-3.ibm.com/software/ts/mqseries/support/summary/. 5.2 and 5.2.1
both go off support 31 Dec 2003. There is probably no reason for you to go
to 5.3 (which is WebSphere MQ) if you only use limited functionality.

-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of Deiter
Scott
Sent: Tuesday, December 31, 2002 11.24
To: [EMAIL PROTECTED]
Subject: Version 5.2 end of service


Been looking at the IBM web site.
Found a page that over used the word generally.
What is the end of service date for 5.2?
Does 5.2.1 buy any more time ?
We are not getting rid of mq.  We use a limited bit of the function
available.
Is there any advantage to get websphere mq ?

>FromScott Deiter
Hanover Direct, Inc.
Tech services
(717) 633-3298
[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

Re: Transaction coordination with 5.3 and Oracle on AIX 5.1

[Gutekunst, Brant]

Still not working.  I tried running an application program in the
debugger, assuming that it would cause the QMgr to attempt to connect to
the database.  Then with some calculated breakpoints and jumps I forced
it to retry after getting errors.  I still get ORA-3113 every time I
issue a MQSTART.  


-Original Message-
From: Robert Broderick [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 31, 2002 10:43 AM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1

s our problem too. So we had the flow rollback the message and try
again. We
played with the testing and tried to determine which codes were thrown
because the database was taken away and whci ones were stale states.
There
are two error codes for the connection handle that we found. One sez
there
is no handle, the other one sez that the one it has is not valid any
more
(DB went down). It's fun!!

So you got it working???


 
bobbee






>From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>Date: Tue, 31 Dec 2002 10:27:09 -0500
>
>We have seen occasional 3113 errors in application programs.  If my
>memory serves me correctly, they generally happened on the MQCMIT.
They
>were certainly transitory.  This time, I consistently get the error
when
>calling xa_open.  This appears to be the first call to the DB.
>
>
>-Original Message-
>From: Robert Broderick [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, December 31, 2002 9:40 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>
>We have an WMQI flow plumed to do an insert to a dqatabase under XA
>coord.
>When an exception is hit we interrogate the return code from ORACLE and
>in
>some instances reprocess the message because the error is more of an XA
>state problem because of the XA coordination. One of these codes is
>'3113'.
>
>   bobbee
>
>
>
>
>
>
> >From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
> >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
> >Date: Tue, 31 Dec 2002 07:58:17 -0500
> >
> >I'm sure that the XAResourceManager stanza is correct.  We copied the
> >database from another system, and I cut and pasted the stanza from a
> >working qm.ini.  (rev 5.2)  Also, If I add +SQLNET=whatever to the
> >XAOpenString, I can access the database successfully.
> >
> >I'm not positive about the switch file.  It compiled cleanly, i.e.,
>with
> >no errors, but we are dealing with a new version of the compiler
here.
> >
> >It looks like we are getting through to the Oracle XA interface which
>is
> >returning ORA-3113.  So I THINK the switch file is OK.
> >
> >-Original Message-
> >From: Robert Broderick [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, December 31, 2002 7:48 AM
> >To: [EMAIL PROTECTED]
> >Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
> >
> >Are you sure your compile of the SWITCH file worked. I had problems
>with
> >the
> >makefile that was supplied. What does your XA_Resource stanza look
>like.
> >The
> >first one is there because we are using WMQI but when we were setting
>up
> >XA
> >with MQ alone it looked like the commented out one:
> >
> >XAResourceManager:
> >## Test DB XA control for ARIBA machine
> >Name=Oracle8 retbolt1.ARDB
> >SwitchFile=/opt/wmqi/merant/lib/UKor8dtc16.so
> >
>
>XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+se
>s
> >tm=0+threads=TRUE+DB=retbolt1.ARDB
> >XACloseString=
> >ThreadOfControl=THREAD
> >## ARIBA database XA control
> >#Name=Oracle8 retbolt1.ARDB
> >#SwitchFile=/opt/mqm/samp/xatm/oraswit
> >#
>
>XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+se
>s
> >tm=0+threads=TRUE+DB=retbolt1.ARDB
> >#XACloseString=
> >
> >
> >
> >
> >
> >
> > >From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
> > >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: Re: Transaction coordination with 5.3 and Oracle on AIX
5.1
> > >Date: Mon, 30 Dec 2002 14:26:10 -0500
> > >
> > >Yes.  I can access the DB via SQLPLUS using the user and password
in
> >the
> > >qm.ini file.
> > >
> > >-Original Message-
> > >From: Robert Broderick [mailto:[EMAIL PROTECTED]]
> > >Sent: Monday, December 30, 2002 2:21 PM
> > >To: [EMAIL PROTECTED]
> > >Subject: Re: Transaction coordination with 5.3 and Oracle on AIX
5.1
> > >
> > >Can you connect to the Oracle DB using SQLPLUS from the same
machine.
>I
> > >am
> > >wondering if your tnsnames.ora file is correct. and you have the
link
> > >(either in your /usr/lib directory or in the prog) set to point to
>then
> > >ORACLE client library file
> > >
> > >bobbee
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > >From: "Gutekunst, Brant" <[EMAIL PROTECT

Version 5.2 end of service

[Deiter Scott]

Been looking at the IBM web site.
Found a page that over used the word generally.
What is the end of service date for 5.2?
Does 5.2.1 buy any more time ?
We are not getting rid of mq.  We use a limited bit of the function
available.
Is there any advantage to get websphere mq ?

>FromScott Deiter
Hanover Direct, Inc.
Tech services
(717) 633-3298
[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: MO71 Beta testers required

[Kinlen, Dan]

So would I.

-Original Message-
From: Arlen Williams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 9:27 AM
To: [EMAIL PROTECTED]
Subject: Re: MO71 Beta testers required


I would like to test the latest.

Arlen Williams

-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of Paul
Clarke
Sent: Monday, December 23, 2002 1:08 PM
To: [EMAIL PROTECTED]
Subject: MO71 Beta testers required


Merry Christmas everybody.

Yet again I am looking for beta testers of my MO71 supportpac. If you were
kind enough to offer to test the last version then I will assume you would
like the new one unless you tell me different.

The features of the new one include :-

Multiple network views
Network view supports clusters,processes & namelists
Save selections on list refresh
No automatic object refresh preference option
Margin and overlap settings saved across invocations
Allow option for no main windows in taskbar
Existing window icon displayed on command menu
Export allowed for (nearly) all dialogs in text mode
Colour Scheme support
List titles buttons/Ruled lists (prettier that's all)
Main icon goes red if any QM in error (switchable)
MQSC window logs the file chosen from file(?)
New colour setting for selected items in a list window
New action to reset status of a location/all locations
Add locale selection to preferences dialog - codepage support
highlight selected QM links in network view

Plus one or two bug fixes which we don't like to talk about.

Many thanks to all of you who suggested many of these enhancements.

Have a great 2003,

P.

Paul G Clarke
WebSphere MQ Development
IBM Hursley

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

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: ESQL Oracle Date Conversion

[Suntosh Murthy]

Just use a passthru('UPDATE table
SET column =TO_DATE(?,'''MMDD'''), YourDate);

I have forgotten exactly how many escape characters you need for oracle.

- Suntosh

-Original Message-
From: Miller, Dennis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 10:33 AM
To: [EMAIL PROTECTED]
Subject: Re: ESQL Oracle Date Conversion


Don't know if there is anything special about doing it from a compute node or how many 
bytes it occupies, but the SQL syntax to 
insert  a standard Oracle date from a string is:

UPDATE table
SET column =TO_DATE(yourdate,'MMDD');



> -Original Message-
> From: Robert Broderick [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 12:29 PM
> To:   [EMAIL PROTECTED]
> Subject:   ESQL Oracle Date Conversion
> 
> I want to convert an incoming date of MMDD to an Oracle 7 character
> standard date format. How do I do this in a Database Insert statement in a
> compute node.
> 
>   Bobbee
> 
> 
> 
> 
> 
> _
> STOP MORE SPAM with the new MSN 8 and get 3 months FREE*.
> http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
> http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_stopmorespam_3mf
> 
> 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

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: ebcdic to ascii conversion in MQseries

[Manish Sharma]

I would like to know if there is any way of converting it while message is
PUT from IBM to ASCII or any format which does not give junk on solaris.



-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of Gutekunst,
Brant
Sent: Tuesday, December 31, 2002 5:43 PM
To: [EMAIL PROTECTED]
Subject: Re: ebcdic to ascii conversion in MQseries



I'd like to add that the preferred method is to do the conversion on the
get, rather than on the channel.



In either case, you also need to make sure that the Format of the message is
MQFMT_STRING.



-Original Message-
From: John Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 5:23 AM
To: [EMAIL PROTECTED]
Subject: Re: ebcdic to ascii conversion in MQseries



Have a look at the MQGMO_CONVERT option for the get message options when you
read the message. This will convert from the mainframe charset to the
Solaris charset for you.



If you can't change the program that gets the messages, you can change the
channel definition between mainframe and Solaris to do the convertion on the
messages that get transferred. You'll find this on the CONVERT option of a
channel definition, something like:



ALTER CHL(MFQM.TO.SOLARISQM) CONVERT(YES)

Regards
John Scott
Senior Middleware Technical Specialist
Argos Ltd

-Original Message-
From: Manish Sharma [mailto:[EMAIL PROTECTED]]
Sent: 31 December 2002 10:14
To: [EMAIL PROTECTED]
Subject: ebcdic to ascii conversion in MQseries

Hi,

We have a setup wherein we communicate between two applications using

MQseries 5.1 installed on sunsolaris and MQSeries on mainframes. When any

message is written from mainframes and read from Unix local queue we get
junk characters.

I have heard that some X format to ASCII conversion is required on message.

It would be very helpful if someone can let us know.

1> What is this X format.

2> Do we have to do this conversion programatically or just set the property

in a queue.

3> Any other methods by which i can achieve this.



-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of Rosangela
Andrade
Sent: Tuesday, December 31, 2002 2:27 PM
To: [EMAIL PROTECTED]
Subject: Trigger

I have a program that of the one get browse in the DLQ and later records
another line with in syncponit. However when cics falls, in the following
day it comes back to record the same messages of the DLQ in the other line.
Please, as I make this not to happen

Tia



Rosangela






  _


Busca Yahoo!  
O melhor lugar para encontrar tudo o que vocj procura na Internet



**

Click here to visit the Argos home page http://www.argos.co.uk

The information contained in this message or any of its attachments may be
privileged and confidential, and is intended exclusively for the addressee.
The views expressed may not be official policy, but the personal views of
the originator.
If you are not the intended addressee, any disclosure, reproduction,
distribution, dissemination or use of this communication is not authorised.
If you have received this message in error, please advise the sender by
using your reply facility in youe e-mail software.
All messages sent and received by Argos Ltd are monitored for virus, high
risk file extensions, and inappropriate content. As a result users should be
aware that mail maybe accessed.

**


CONFIDENTIALITY NOTICE: This E-Mail transmission may contain confidential or
legally privileged information that is intended only for the individual(s)or
entity(ies) named in the E-Mail address. If you are not the intended
recipient, you are hereby notified that any disclosure, copying,
distribution, or reliance upon the contents of this E-Mail is strictly
prohibited. If you have received this E-Mail transmission in error, please
reply to the sender so that arrangements can be made for proper delivery,
after which please delete the message from your inbox. 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

Re: Trigger

[Miller, Dennis]

Rosangela,
Meaning no disrespect, I think you will need to phrase your question in better 
English. Or perhaps someone can help you in your native language. 

> -Original Message-
> From: Rosangela Andrade [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, December 31, 2002 12:57 AM
> To:   [EMAIL PROTECTED]
> Subject:   Trigger
> 
> I have a program that of the one get browse in the DLQ and later records another 
>line with in syncponit. However when cics falls, in the following day it comes back 
>to record the same messages of the DLQ in the other line. Please, as I make this not 
>to happen 
> 
> Tia
> 
>  
> 
> Rosangela
> 
>  
> 
> 
> 
>   _  
> 
> Busca Yahoo!  
> O melhor lugar para encontrar tudo o que vocj procura na Internet

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: Transaction coordination with 5.3 and Oracle on AIX 5.1

[Robert Broderick]

s our problem too. So we had the flow rollback the message and try again. We
played with the testing and tried to determine which codes were thrown
because the database was taken away and whci ones were stale states. There
are two error codes for the connection handle that we found. One sez there
is no handle, the other one sez that the one it has is not valid any more
(DB went down). It's fun!!

So you got it working???


 bobbee







From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
Reply-To: MQSeries List <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
Date: Tue, 31 Dec 2002 10:27:09 -0500

We have seen occasional 3113 errors in application programs.  If my
memory serves me correctly, they generally happened on the MQCMIT.  They
were certainly transitory.  This time, I consistently get the error when
calling xa_open.  This appears to be the first call to the DB.


-Original Message-
From: Robert Broderick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 9:40 AM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1

We have an WMQI flow plumed to do an insert to a dqatabase under XA
coord.
When an exception is hit we interrogate the return code from ORACLE and
in
some instances reprocess the message because the error is more of an XA
state problem because of the XA coordination. One of these codes is
'3113'.

  bobbee






>From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>Date: Tue, 31 Dec 2002 07:58:17 -0500
>
>I'm sure that the XAResourceManager stanza is correct.  We copied the
>database from another system, and I cut and pasted the stanza from a
>working qm.ini.  (rev 5.2)  Also, If I add +SQLNET=whatever to the
>XAOpenString, I can access the database successfully.
>
>I'm not positive about the switch file.  It compiled cleanly, i.e.,
with
>no errors, but we are dealing with a new version of the compiler here.
>
>It looks like we are getting through to the Oracle XA interface which
is
>returning ORA-3113.  So I THINK the switch file is OK.
>
>-Original Message-
>From: Robert Broderick [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, December 31, 2002 7:48 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>
>Are you sure your compile of the SWITCH file worked. I had problems
with
>the
>makefile that was supplied. What does your XA_Resource stanza look
like.
>The
>first one is there because we are using WMQI but when we were setting
up
>XA
>with MQ alone it looked like the commented out one:
>
>XAResourceManager:
>## Test DB XA control for ARIBA machine
>Name=Oracle8 retbolt1.ARDB
>SwitchFile=/opt/wmqi/merant/lib/UKor8dtc16.so
>
>XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+se
s
>tm=0+threads=TRUE+DB=retbolt1.ARDB
>XACloseString=
>ThreadOfControl=THREAD
>## ARIBA database XA control
>#Name=Oracle8 retbolt1.ARDB
>#SwitchFile=/opt/mqm/samp/xatm/oraswit
>#
>XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+se
s
>tm=0+threads=TRUE+DB=retbolt1.ARDB
>#XACloseString=
>
>
>
>
>
>
> >From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
> >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
> >Date: Mon, 30 Dec 2002 14:26:10 -0500
> >
> >Yes.  I can access the DB via SQLPLUS using the user and password in
>the
> >qm.ini file.
> >
> >-Original Message-
> >From: Robert Broderick [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, December 30, 2002 2:21 PM
> >To: [EMAIL PROTECTED]
> >Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
> >
> >Can you connect to the Oracle DB using SQLPLUS from the same machine.
I
> >am
> >wondering if your tnsnames.ora file is correct. and you have the link
> >(either in your /usr/lib directory or in the prog) set to point to
then
> >ORACLE client library file
> >
> >bobbee
> >
> >
> >
> >
> >
> >
> >
> > >From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
> > >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: Transaction coordination with 5.3 and Oracle on AIX 5.1
> > >Date: Mon, 30 Dec 2002 11:20:30 -0500
> > >
> > >I'm having problems making XA work with MQ 5.3 and Oracle 8.1.7 on
>AIX
> > >5.1.
> > >
> > >I created the switch file, added the XAResourceManager stanza to
>qm.ini
> > >and granted the appropriate database privileges.
> > >
> > >
> > >
> > >When I start the QMgr, I get the following in the log:
> > >
> > >AMQ7604: The XA resource manager 'isgamt06' was not available when
> > >called for
> > >
> > >xa_open. The queue manager is continuing withou

Moving /var/mqm/log

[Jeff A Tressler]

We currently have our MQSeries logs on a disk array. The file
system has mapped /var/mqm/log to a logical disk partition
on the disk array.

This disk array is getting full and a new disk array has been
purchased. The plan calls for moving the MQSeries logs to
the new disk array.

Is there any problem with this?

Details:
   HP-UX 11.0
   MQSeries 5.1
   Moving from EMC to XP512 disk array

I have this feeling that moving the logs will cause some kind
of internal pointers to get mixed up causing the logs to no
longer work and causing the queue managers to fail. I do
not know where I got this impression but it is a strong feeling.

At the very least, I believe we need to stop all queue managers
so logging completes before the move. Any other suggestions.

Jeff Tressler

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: ESQL Oracle Date Conversion

[Miller, Dennis]

Don't know if there is anything special about doing it from a compute node or how many 
bytes it occupies, but the SQL syntax to 
insert  a standard Oracle date from a string is:

UPDATE table
SET column =TO_DATE(yourdate,'MMDD');



> -Original Message-
> From: Robert Broderick [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 12:29 PM
> To:   [EMAIL PROTECTED]
> Subject:   ESQL Oracle Date Conversion
> 
> I want to convert an incoming date of MMDD to an Oracle 7 character
> standard date format. How do I do this in a Database Insert statement in a
> compute node.
> 
>   Bobbee
> 
> 
> 
> 
> 
> _
> STOP MORE SPAM with the new MSN 8 and get 3 months FREE*.
> http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
> http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_stopmorespam_3mf
> 
> 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: Transaction coordination with 5.3 and Oracle on AIX 5.1

[Gutekunst, Brant]

We have seen occasional 3113 errors in application programs.  If my
memory serves me correctly, they generally happened on the MQCMIT.  They
were certainly transitory.  This time, I consistently get the error when
calling xa_open.  This appears to be the first call to the DB.


-Original Message-
From: Robert Broderick [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 31, 2002 9:40 AM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1

We have an WMQI flow plumed to do an insert to a dqatabase under XA
coord.
When an exception is hit we interrogate the return code from ORACLE and
in
some instances reprocess the message because the error is more of an XA
state problem because of the XA coordination. One of these codes is
'3113'.

  bobbee






>From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>Date: Tue, 31 Dec 2002 07:58:17 -0500
>
>I'm sure that the XAResourceManager stanza is correct.  We copied the
>database from another system, and I cut and pasted the stanza from a
>working qm.ini.  (rev 5.2)  Also, If I add +SQLNET=whatever to the
>XAOpenString, I can access the database successfully.
>
>I'm not positive about the switch file.  It compiled cleanly, i.e.,
with
>no errors, but we are dealing with a new version of the compiler here.
>
>It looks like we are getting through to the Oracle XA interface which
is
>returning ORA-3113.  So I THINK the switch file is OK.
>
>-Original Message-
>From: Robert Broderick [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, December 31, 2002 7:48 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>
>Are you sure your compile of the SWITCH file worked. I had problems
with
>the
>makefile that was supplied. What does your XA_Resource stanza look
like.
>The
>first one is there because we are using WMQI but when we were setting
up
>XA
>with MQ alone it looked like the commented out one:
>
>XAResourceManager:
>## Test DB XA control for ARIBA machine
>Name=Oracle8 retbolt1.ARDB
>SwitchFile=/opt/wmqi/merant/lib/UKor8dtc16.so
>
>XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+se
s
>tm=0+threads=TRUE+DB=retbolt1.ARDB
>XACloseString=
>ThreadOfControl=THREAD
>## ARIBA database XA control
>#Name=Oracle8 retbolt1.ARDB
>#SwitchFile=/opt/mqm/samp/xatm/oraswit
>#
>XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+se
s
>tm=0+threads=TRUE+DB=retbolt1.ARDB
>#XACloseString=
>
>
>
>
>
>
> >From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
> >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
> >Date: Mon, 30 Dec 2002 14:26:10 -0500
> >
> >Yes.  I can access the DB via SQLPLUS using the user and password in
>the
> >qm.ini file.
> >
> >-Original Message-
> >From: Robert Broderick [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, December 30, 2002 2:21 PM
> >To: [EMAIL PROTECTED]
> >Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
> >
> >Can you connect to the Oracle DB using SQLPLUS from the same machine.
I
> >am
> >wondering if your tnsnames.ora file is correct. and you have the link
> >(either in your /usr/lib directory or in the prog) set to point to
then
> >ORACLE client library file
> >
> >bobbee
> >
> >
> >
> >
> >
> >
> >
> > >From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
> > >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: Transaction coordination with 5.3 and Oracle on AIX 5.1
> > >Date: Mon, 30 Dec 2002 11:20:30 -0500
> > >
> > >I'm having problems making XA work with MQ 5.3 and Oracle 8.1.7 on
>AIX
> > >5.1.
> > >
> > >I created the switch file, added the XAResourceManager stanza to
>qm.ini
> > >and granted the appropriate database privileges.
> > >
> > >
> > >
> > >When I start the QMgr, I get the following in the log:
> > >
> > >AMQ7604: The XA resource manager 'isgamt06' was not available when
> > >called for
> > >
> > >xa_open. The queue manager is continuing without this resource
>manager.
> > >
> > >EXPLANATION:
> > >
> > >The XA resource manager 'isgamt06' has indicated that it is not
> > >available, by
> > >
> > >returning XAER_RMERR on an xa_open request or XAER_RMFAIL when
called
> > >for
> > >
> > >something else. Normally this indicates that the resource manager
has
> > >been shut
> > >
> > >down. In this case the resource manager cannot participate in any
new
> > >
> > >transactions. Any in-flight transactions in which it was involved
>will
> > >be
> > >
> > >backed out, and any transactions in which it is in-doubt will only
be
> > >resolved
> > >
> > >when contact with the resource manager is re-established. A further
> > >message
> > >
> > >will be issued when the queu

Re: MO71 Beta testers required

[Arlen Williams]

I would like to test the latest.

Arlen Williams

-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of Paul
Clarke
Sent: Monday, December 23, 2002 1:08 PM
To: [EMAIL PROTECTED]
Subject: MO71 Beta testers required


Merry Christmas everybody.

Yet again I am looking for beta testers of my MO71 supportpac. If you were
kind enough to offer to test the last version then I will assume you would
like the new one unless you tell me different.

The features of the new one include :-

Multiple network views
Network view supports clusters,processes & namelists
Save selections on list refresh
No automatic object refresh preference option
Margin and overlap settings saved across invocations
Allow option for no main windows in taskbar
Existing window icon displayed on command menu
Export allowed for (nearly) all dialogs in text mode
Colour Scheme support
List titles buttons/Ruled lists (prettier that's all)
Main icon goes red if any QM in error (switchable)
MQSC window logs the file chosen from file(?)
New colour setting for selected items in a list window
New action to reset status of a location/all locations
Add locale selection to preferences dialog - codepage support
highlight selected QM links in network view

Plus one or two bug fixes which we don't like to talk about.

Many thanks to all of you who suggested many of these enhancements.

Have a great 2003,

P.

Paul G Clarke
WebSphere MQ Development
IBM Hursley

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: Transaction coordination with 5.3 and Oracle on AIX 5.1

[Robert Broderick]

We have an WMQI flow plumed to do an insert to a dqatabase under XA coord.
When an exception is hit we interrogate the return code from ORACLE and in
some instances reprocess the message because the error is more of an XA
state problem because of the XA coordination. One of these codes is '3113'.

 bobbee







From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
Reply-To: MQSeries List <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
Date: Tue, 31 Dec 2002 07:58:17 -0500

I'm sure that the XAResourceManager stanza is correct.  We copied the
database from another system, and I cut and pasted the stanza from a
working qm.ini.  (rev 5.2)  Also, If I add +SQLNET=whatever to the
XAOpenString, I can access the database successfully.

I'm not positive about the switch file.  It compiled cleanly, i.e., with
no errors, but we are dealing with a new version of the compiler here.

It looks like we are getting through to the Oracle XA interface which is
returning ORA-3113.  So I THINK the switch file is OK.

-Original Message-
From: Robert Broderick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 7:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1

Are you sure your compile of the SWITCH file worked. I had problems with
the
makefile that was supplied. What does your XA_Resource stanza look like.
The
first one is there because we are using WMQI but when we were setting up
XA
with MQ alone it looked like the commented out one:

XAResourceManager:
## Test DB XA control for ARIBA machine
   Name=Oracle8 retbolt1.ARDB
   SwitchFile=/opt/wmqi/merant/lib/UKor8dtc16.so

XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+ses
tm=0+threads=TRUE+DB=retbolt1.ARDB
   XACloseString=
   ThreadOfControl=THREAD
## ARIBA database XA control
#Name=Oracle8 retbolt1.ARDB
#SwitchFile=/opt/mqm/samp/xatm/oraswit
#
XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+ses
tm=0+threads=TRUE+DB=retbolt1.ARDB
#XACloseString=






>From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>Date: Mon, 30 Dec 2002 14:26:10 -0500
>
>Yes.  I can access the DB via SQLPLUS using the user and password in
the
>qm.ini file.
>
>-Original Message-
>From: Robert Broderick [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 30, 2002 2:21 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>
>Can you connect to the Oracle DB using SQLPLUS from the same machine. I
>am
>wondering if your tnsnames.ora file is correct. and you have the link
>(either in your /usr/lib directory or in the prog) set to point to then
>ORACLE client library file
>
>bobbee
>
>
>
>
>
>
>
> >From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
> >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Transaction coordination with 5.3 and Oracle on AIX 5.1
> >Date: Mon, 30 Dec 2002 11:20:30 -0500
> >
> >I'm having problems making XA work with MQ 5.3 and Oracle 8.1.7 on
AIX
> >5.1.
> >
> >I created the switch file, added the XAResourceManager stanza to
qm.ini
> >and granted the appropriate database privileges.
> >
> >
> >
> >When I start the QMgr, I get the following in the log:
> >
> >AMQ7604: The XA resource manager 'isgamt06' was not available when
> >called for
> >
> >xa_open. The queue manager is continuing without this resource
manager.
> >
> >EXPLANATION:
> >
> >The XA resource manager 'isgamt06' has indicated that it is not
> >available, by
> >
> >returning XAER_RMERR on an xa_open request or XAER_RMFAIL when called
> >for
> >
> >something else. Normally this indicates that the resource manager has
> >been shut
> >
> >down. In this case the resource manager cannot participate in any new
> >
> >transactions. Any in-flight transactions in which it was involved
will
> >be
> >
> >backed out, and any transactions in which it is in-doubt will only be
> >resolved
> >
> >when contact with the resource manager is re-established. A further
> >message
> >
> >will be issued when the queue manager has been able to do this. If
the
> >problem
> >
> >occurred on an xa_open request, and the resource manager should be
> >available,
> >
> >then there may be a configuration problem.
> >
> >ACTION:
> >
> >Try to establish the reason why the resource manager is unavailable.
It
> >may be
> >
> >that an invalid XAOpenString has been defined for the resource
manager
> >in the
> >
> >'qm.ini' configuration file. If this is the case, stop and then
restart
> >the
> >
> >queue manager so that any change will be picked up. Alternatively,
the
> >queue
> >
> >manager may be reaching a resource constraint with this resource
> >manager. For
> >
> >example, the resource manager may not be able to

Re: WMQI: ACL Problems

[Manish Sharma]

can u plz tell me how do we do that ?

-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of Robert
Broderick
Sent: Tuesday, December 31, 2002 6:23 PM
To: [EMAIL PROTECTED]
Subject: Re: WMQI: ACL Problems


Or have your triggered application do a CICS Start with a USERID






>From: Neil Casey <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: WMQI: ACL Problems
>Date: Tue, 31 Dec 2002 15:47:42 +1100
>
>Hi,
>
>The MQ triggered transaction will run with the userid belonging to the CKTI
>trigger monitor which started it.
>
>This usually runs with the CICS Region or CICS default userid, or else a
>PLT userid.
>
>The IBM trigger monitor does not propagate userids from the message to the
>transaction. There are various reasons for this, such as that CICS
>transactions have a userid for the life of the transaction, not the unit of
>work, and most CICS triggered transactions run trigger(first) and do
>multiple messages in a single transaction, with multiple units of work.
>This just breaks down completely if you try to get security information
>from the MQ message.
>
>So you will probably find that your own userid has access to the plan, but
>the CICS userid doesn't. If you use CKQC to stop and restart the trigger
>monitor, your security problem may go away (temporarily of course). In the
>longer term, you will need to grant the CICS region or CICS PLT userid
>access to execute your plan.
>
>Regards...   Neil Casey.
>
>
>|-+>
>| |   Manish Sharma|
>| |   | |   ATNI.COM>|
>| |   Sent by: MQSeries|
>| |   List |
>| |   | |   n.AC.AT> |
>| ||
>| ||
>| |   31/12/2002 14:49 |
>| |   Please respond to|
>| |   manish.rsharma   |
>| ||
>|-+>
>
>
>---
---|
>   |
>   |
>   |   To:   [EMAIL PROTECTED]
>   |
>   |   cc:
>   |
>   |   Subject:  Re: WMQI: ACL Problems
>   |
>
>
>---
---|
>
>
>
>
>I m using plans.  Both plans are authorized in db2.  The access problem
>arises only when it is mq triggered.  if I manually trigger the same
>transaction it works fine .
>
>-Original Message-
>From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of
>Brigido, Peter
>Sent: Tuesday, December 31, 2002 8:41 AM
>To: [EMAIL PROTECTED]
>Subject: Re: WMQI: ACL Problems
>
>
>are both programs bound to the same package or do you just use plans,
>whatever are both programs
>plan/package authorized in db2?
>
>-Original Message-
>From: Manish Sharma [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 30, 2002 9:49 AM
>To: [EMAIL PROTECTED]
>Subject: Re: WMQI: ACL Problems
>
>
>Hi,
>
> I am working on IBM-3090.  I have a MQ triggered program in
>COBOL-CICS.  This program gets the data from the queue and xctls to another
>CICS program which accesses DB2 database.  The problem is that I cannot
>access DB2 in this second program.  I am getting an sqlcode of -922.  If I
>trigger the program which reads from the queue directly through CICS it
>runs
>fine and gets the database access.  Can anybody give any clue what may be
>the reason ?
>
>Manish Sharma
>___
>Patni Computer Systems Limited
>Mumbai - 400 096
>Tel: 91 22 8291454 ext. 5537
>Fax: 91 22 8291778
>
>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
>
>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


_
MSN 8 with e-mail virus protection service: 3 months FREE*.
http://join.msn.com/?page=features/virus&xAPID=42&PS=47575&PI=7324&DI=7474&S
U=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_elim

Re: Hi

[Peter Heggie]

the lucky guy is a little closer to the date line..
Happy New Year everyone




From: Robert Broderick <[EMAIL PROTECTED]> on 12/31/2002 07:27 AM

Please respond to MQSeries List <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:

Subject:  Re: Hi

Looks like ole Shailesh Kuma started celebrating New Years a little
early






>From: Shailesh Kumar U <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Hi
>Date: Tue, 31 Dec 2002 13:48:36 +0530
>
>Hi MqSeries bonds,
>
> How are you all? I am missing u so much.
> As of Now I do not have any questions.
> See u later
>
>By
>Regards
>Shailesh Kumar


_
MSN 8 limited-time offer: Join now and get 3 months FREE*.
http://join.msn.com/?page=dept/dialup&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_newmsn8ishere_3mf

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: Transaction coordination with 5.3 and Oracle on AIX 5.1

[Gutekunst, Brant]

I'm sure that the XAResourceManager stanza is correct.  We copied the
database from another system, and I cut and pasted the stanza from a
working qm.ini.  (rev 5.2)  Also, If I add +SQLNET=whatever to the
XAOpenString, I can access the database successfully.

I'm not positive about the switch file.  It compiled cleanly, i.e., with
no errors, but we are dealing with a new version of the compiler here.

It looks like we are getting through to the Oracle XA interface which is
returning ORA-3113.  So I THINK the switch file is OK.  

-Original Message-
From: Robert Broderick [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 31, 2002 7:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1

Are you sure your compile of the SWITCH file worked. I had problems with
the
makefile that was supplied. What does your XA_Resource stanza look like.
The
first one is there because we are using WMQI but when we were setting up
XA
with MQ alone it looked like the commented out one:

XAResourceManager:
## Test DB XA control for ARIBA machine
   Name=Oracle8 retbolt1.ARDB
   SwitchFile=/opt/wmqi/merant/lib/UKor8dtc16.so

XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+ses
tm=0+threads=TRUE+DB=retbolt1.ARDB
   XACloseString=
   ThreadOfControl=THREAD
## ARIBA database XA control
#Name=Oracle8 retbolt1.ARDB
#SwitchFile=/opt/mqm/samp/xatm/oraswit
#
XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+ses
tm=0+threads=TRUE+DB=retbolt1.ARDB
#XACloseString=






>From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>Date: Mon, 30 Dec 2002 14:26:10 -0500
>
>Yes.  I can access the DB via SQLPLUS using the user and password in
the
>qm.ini file.
>
>-Original Message-
>From: Robert Broderick [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 30, 2002 2:21 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>
>Can you connect to the Oracle DB using SQLPLUS from the same machine. I
>am
>wondering if your tnsnames.ora file is correct. and you have the link
>(either in your /usr/lib directory or in the prog) set to point to then
>ORACLE client library file
>
>bobbee
>
>
>
>
>
>
>
> >From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
> >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Transaction coordination with 5.3 and Oracle on AIX 5.1
> >Date: Mon, 30 Dec 2002 11:20:30 -0500
> >
> >I'm having problems making XA work with MQ 5.3 and Oracle 8.1.7 on
AIX
> >5.1.
> >
> >I created the switch file, added the XAResourceManager stanza to
qm.ini
> >and granted the appropriate database privileges.
> >
> >
> >
> >When I start the QMgr, I get the following in the log:
> >
> >AMQ7604: The XA resource manager 'isgamt06' was not available when
> >called for
> >
> >xa_open. The queue manager is continuing without this resource
manager.
> >
> >EXPLANATION:
> >
> >The XA resource manager 'isgamt06' has indicated that it is not
> >available, by
> >
> >returning XAER_RMERR on an xa_open request or XAER_RMFAIL when called
> >for
> >
> >something else. Normally this indicates that the resource manager has
> >been shut
> >
> >down. In this case the resource manager cannot participate in any new
> >
> >transactions. Any in-flight transactions in which it was involved
will
> >be
> >
> >backed out, and any transactions in which it is in-doubt will only be
> >resolved
> >
> >when contact with the resource manager is re-established. A further
> >message
> >
> >will be issued when the queue manager has been able to do this. If
the
> >problem
> >
> >occurred on an xa_open request, and the resource manager should be
> >available,
> >
> >then there may be a configuration problem.
> >
> >ACTION:
> >
> >Try to establish the reason why the resource manager is unavailable.
It
> >may be
> >
> >that an invalid XAOpenString has been defined for the resource
manager
> >in the
> >
> >'qm.ini' configuration file. If this is the case, stop and then
restart
> >the
> >
> >queue manager so that any change will be picked up. Alternatively,
the
> >queue
> >
> >manager may be reaching a resource constraint with this resource
> >manager. For
> >
> >example, the resource manager may not be able to accommodate all of
the
> >queue
> >
> >manager processes being connected at one time, you may need to alter
>one
> >of its
> >
> >tuning parameters.
> >
> >
> >
> >I also get a trace file containing:
> >
> >ORACLE XA: Version 8.1.7.0.0. RM name = 'Oracle_XA'.
> >
> >110226.158670.1:
> >
> >ORA-03113: end-of-file on communication channel
> >
> >110226.158670.1:
> >
> >xaolgn: XAER_RMERR; logon failed. ORA-3113.
> >
> >
> >
> >I tried using the DbgFl parameter and got this additional information
>in
> >the trace file:
> >
> >xaoopen: return -3
> >
> >
> >
> >Cu

Re: WMQI: ACL Problems

[Robert Broderick]

Or have your triggered application do a CICS Start with a USERID







From: Neil Casey <[EMAIL PROTECTED]>
Reply-To: MQSeries List <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: WMQI: ACL Problems
Date: Tue, 31 Dec 2002 15:47:42 +1100

Hi,

The MQ triggered transaction will run with the userid belonging to the CKTI
trigger monitor which started it.

This usually runs with the CICS Region or CICS default userid, or else a
PLT userid.

The IBM trigger monitor does not propagate userids from the message to the
transaction. There are various reasons for this, such as that CICS
transactions have a userid for the life of the transaction, not the unit of
work, and most CICS triggered transactions run trigger(first) and do
multiple messages in a single transaction, with multiple units of work.
This just breaks down completely if you try to get security information
from the MQ message.

So you will probably find that your own userid has access to the plan, but
the CICS userid doesn't. If you use CKQC to stop and restart the trigger
monitor, your security problem may go away (temporarily of course). In the
longer term, you will need to grant the CICS region or CICS PLT userid
access to execute your plan.

Regards...   Neil Casey.


|-+>
| |   Manish Sharma|
| |   |
| |   Sent by: MQSeries|
| |   List |
| ||
| ||
| ||
| |   31/12/2002 14:49 |
| |   Please respond to|
| |   manish.rsharma   |
| ||
|-+>

>--|
  |
  |
  |   To:   [EMAIL PROTECTED]
  |
  |   cc:
  |
  |   Subject:  Re: WMQI: ACL Problems
  |

>--|




I m using plans.  Both plans are authorized in db2.  The access problem
arises only when it is mq triggered.  if I manually trigger the same
transaction it works fine .

-Original Message-
From: MQSeries List [mailto:[EMAIL PROTECTED]]On Behalf Of
Brigido, Peter
Sent: Tuesday, December 31, 2002 8:41 AM
To: [EMAIL PROTECTED]
Subject: Re: WMQI: ACL Problems


are both programs bound to the same package or do you just use plans,
whatever are both programs
plan/package authorized in db2?

-Original Message-
From: Manish Sharma [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 9:49 AM
To: [EMAIL PROTECTED]
Subject: Re: WMQI: ACL Problems


Hi,

I am working on IBM-3090.  I have a MQ triggered program in
COBOL-CICS.  This program gets the data from the queue and xctls to another
CICS program which accesses DB2 database.  The problem is that I cannot
access DB2 in this second program.  I am getting an sqlcode of -922.  If I
trigger the program which reads from the queue directly through CICS it
runs
fine and gets the database access.  Can anybody give any clue what may be
the reason ?

Manish Sharma
___
Patni Computer Systems Limited
Mumbai - 400 096
Tel: 91 22 8291454 ext. 5537
Fax: 91 22 8291778

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

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



_
MSN 8 with e-mail virus protection service: 3 months FREE*.
http://join.msn.com/?page=features/virus&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_eliminateviruses_3mf

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: Transaction coordination with 5.3 and Oracle on AIX 5.1

[Robert Broderick]

Are you sure your compile of the SWITCH file worked. I had problems with the
makefile that was supplied. What does your XA_Resource stanza look like. The
first one is there because we are using WMQI but when we were setting up XA
with MQ alone it looked like the commented out one:

XAResourceManager:
## Test DB XA control for ARIBA machine
  Name=Oracle8 retbolt1.ARDB
  SwitchFile=/opt/wmqi/merant/lib/UKor8dtc16.so

XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+sestm=0+threads=TRUE+DB=retbolt1.ARDB
  XACloseString=
  ThreadOfControl=THREAD
## ARIBA database XA control
#Name=Oracle8 retbolt1.ARDB
#SwitchFile=/opt/mqm/samp/xatm/oraswit
#
XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+sestm=0+threads=TRUE+DB=retbolt1.ARDB
#XACloseString=







From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
Reply-To: MQSeries List <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
Date: Mon, 30 Dec 2002 14:26:10 -0500

Yes.  I can access the DB via SQLPLUS using the user and password in the
qm.ini file.

-Original Message-
From: Robert Broderick [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:21 PM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1

Can you connect to the Oracle DB using SQLPLUS from the same machine. I
am
wondering if your tnsnames.ora file is correct. and you have the link
(either in your /usr/lib directory or in the prog) set to point to then
ORACLE client library file

   bobbee







>From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Transaction coordination with 5.3 and Oracle on AIX 5.1
>Date: Mon, 30 Dec 2002 11:20:30 -0500
>
>I'm having problems making XA work with MQ 5.3 and Oracle 8.1.7 on AIX
>5.1.
>
>I created the switch file, added the XAResourceManager stanza to qm.ini
>and granted the appropriate database privileges.
>
>
>
>When I start the QMgr, I get the following in the log:
>
>AMQ7604: The XA resource manager 'isgamt06' was not available when
>called for
>
>xa_open. The queue manager is continuing without this resource manager.
>
>EXPLANATION:
>
>The XA resource manager 'isgamt06' has indicated that it is not
>available, by
>
>returning XAER_RMERR on an xa_open request or XAER_RMFAIL when called
>for
>
>something else. Normally this indicates that the resource manager has
>been shut
>
>down. In this case the resource manager cannot participate in any new
>
>transactions. Any in-flight transactions in which it was involved will
>be
>
>backed out, and any transactions in which it is in-doubt will only be
>resolved
>
>when contact with the resource manager is re-established. A further
>message
>
>will be issued when the queue manager has been able to do this. If the
>problem
>
>occurred on an xa_open request, and the resource manager should be
>available,
>
>then there may be a configuration problem.
>
>ACTION:
>
>Try to establish the reason why the resource manager is unavailable. It
>may be
>
>that an invalid XAOpenString has been defined for the resource manager
>in the
>
>'qm.ini' configuration file. If this is the case, stop and then restart
>the
>
>queue manager so that any change will be picked up. Alternatively, the
>queue
>
>manager may be reaching a resource constraint with this resource
>manager. For
>
>example, the resource manager may not be able to accommodate all of the
>queue
>
>manager processes being connected at one time, you may need to alter
one
>of its
>
>tuning parameters.
>
>
>
>I also get a trace file containing:
>
>ORACLE XA: Version 8.1.7.0.0. RM name = 'Oracle_XA'.
>
>110226.158670.1:
>
>ORA-03113: end-of-file on communication channel
>
>110226.158670.1:
>
>xaolgn: XAER_RMERR; logon failed. ORA-3113.
>
>
>
>I tried using the DbgFl parameter and got this additional information
in
>the trace file:
>
>xaoopen: return -3
>
>
>
>Curiously, If I change the XAOpenString attribute to use SqlNet,
>everything works.
>
>
>
>Can anyone shed any light on this?
>
>
>
>CONFIDENTIALITY NOTICE: This E-Mail transmission may contain
confidential
>or legally privileged information that is intended only for the
>individual(s)or entity(ies) named in the E-Mail address. If you are not
the
>intended recipient, you are hereby notified that any disclosure,
copying,
>distribution, or reliance upon the contents of this E-Mail is strictly
>prohibited. If you have received this E-Mail transmission in error,
please
>reply to the sender so that arrangements can be made for proper
delivery,
>after which please delete the message from your inbox. Thank you


_
MSN 8 limited-time offer: Join now and get 3 months FREE*.
http://join.msn.com/?page=dept/dialup&xAPID=42&PS=47575&PI=7324&DI=7474&;
SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_newm

Re: Hi

[Robert Broderick]

Looks like ole Shailesh Kuma started celebrating New Years a little
early







From: Shailesh Kumar U <[EMAIL PROTECTED]>
Reply-To: MQSeries List <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Hi
Date: Tue, 31 Dec 2002 13:48:36 +0530

Hi MqSeries bonds,

How are you all? I am missing u so much.
As of Now I do not have any questions.
See u later

By
Regards
   Shailesh Kumar



_
MSN 8 limited-time offer: Join now and get 3 months FREE*.
http://join.msn.com/?page=dept/dialup&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_newmsn8ishere_3mf

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: ebcdic to ascii conversion in MQseries

[Gutekunst, Brant]

Title: Message









I’d like to add that the preferred
method is to do the conversion on the get, rather than on the channel.

 

In either case, you also need to make sure
that the Format of the message is MQFMT_STRING.

 

-Original Message-
From: John Scott
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 31, 2002
5:23 AM
To: [EMAIL PROTECTED]
Subject: Re: ebcdic to ascii
conversion in MQseries

 



Have a look at the
MQGMO_CONVERT option for the get message options when you read the message.
This will convert from the mainframe charset to the Solaris charset for you.





 





If you can't change the
program that gets the messages, you can change the channel definition between
mainframe and Solaris to do the convertion on the messages that get
transferred. You'll find this on the CONVERT option of a channel definition,
something like:





 





ALTER CHL(MFQM.TO.SOLARISQM)
CONVERT(YES)



Regards 
John Scott

Senior
Middleware Technical Specialist 
Argos Ltd




-Original
Message-
From: Manish Sharma
[mailto:[EMAIL PROTECTED]] 
Sent: 31 December 2002 10:14
To: [EMAIL PROTECTED]
Subject: ebcdic to ascii conversion
in MQseries



Hi,

We have a setup wherein we communicate between two
applications using

MQseries 5.1 installed on sunsolaris and MQSeries on
mainframes. When any

message is written from mainframes and read from
Unix local queue we get junk characters. 

I have heard that some X format to ASCII
conversion is required on message.

It would be very helpful if someone can let us
know.

1> What is this X format.

2> Do we have to do this conversion programatically
or just set the property

in a queue.

3> Any other methods by which i can achieve this.

 





-Original
Message-
From: MQSeries List
[mailto:[EMAIL PROTECTED]]On Behalf Of Rosangela
Andrade
Sent: Tuesday, December 31, 2002
2:27 PM
To: [EMAIL PROTECTED]
Subject: Trigger



I have a program that of the one get browse in the DLQ
and later records another line with in syncponit. However when cics falls, in
the following day it comes back to record the same messages of the DLQ in the
other line. Please, as I make this not to happen 



Tia

 

Rosangela

 

 







Busca Yahoo! 
O melhor lugar para encontrar tudo o que vocj procura na Internet







**

Click here to visit the Argos home page
http://www.argos.co.uk

The information contained in this message or any
of its attachments may be privileged and confidential, and is intended
exclusively for the addressee.
The views expressed may not be official policy,
but the personal views of the originator.
If you are not the intended addressee, any
disclosure, reproduction, distribution, dissemination or use of this
communication is not authorised.
If you have received this message in error,
please advise the sender by using your reply facility in youe e-mail software.
All messages sent and received by Argos Ltd are
monitored for virus, high risk file extensions, and inappropriate content. As a
result users should be aware that mail maybe accessed.

**



CONFIDENTIALITY NOTICE: This E-Mail transmission may contain confidential or legally privileged information that is intended only for the individual(s)or entity(ies) named in the E-Mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this E-Mail is strictly prohibited. If you have received this E-Mail transmission in error, please reply to the sender so that arrangements can be made for proper delivery, after which please delete the message from your inbox. Thank you

Re: ebcdic to ascii conversion in MQseries

[John Scott]

Title: Message



Have a
look at the MQGMO_CONVERT option for the get message options when you read the
message. This will convert from the mainframe charset to the Solaris charset for
you.
 
If you
can't change the program that gets the messages, you can change the channel
definition between mainframe and Solaris to do the convertion on the messages
that get transferred. You'll find this on the CONVERT option of a channel
definition, something like:
 
ALTER
CHL(MFQM.TO.SOLARISQM) CONVERT(YES)
Regards
John Scott
Senior Middleware Technical
Specialist Argos
Ltd 

  
  -Original Message-From: Manish Sharma
  [mailto:[EMAIL PROTECTED]] Sent: 31 December 2002
  10:14To: [EMAIL PROTECTED]Subject: ebcdic to ascii
  conversion in MQseries
  
  
  
  
  
  
  Hi,
  We have a setup wherein we communicate between two applications using
  MQseries 5.1 installed on sunsolaris and MQSeries on mainframes. When
  any
  message is written from
  mainframes and read from Unix
  local queue we get junk characters.
  
  I have heard that some X format to ASCII conversion is required
  on message.
  It would be very helpful if someone can
  let us know.
  1> What is this X format.
  2> Do we have to do this conversion programatically or just set the
  property
  in a queue.
  3> Any other methods by which i can achieve this.
   
  
-Original Message-From: MQSeries List
[mailto:[EMAIL PROTECTED]]On Behalf Of Rosangela
AndradeSent: Tuesday, December 31, 2002 2:27 PMTo:
[EMAIL PROTECTED]Subject: Trigger
I
have a program that of the one get browse in the DLQ and later records
another line with in syncponit. However when cics falls, in the following
day it comes back to record the same messages of the DLQ in the other line.
Please, as I make this not to happen 
Tia
 
Rosangela
 


Busca Yahoo! O melhor
lugar para encontrar tudo o que vocj procura na
Internet

**

Click here to visit the Argos home page http://www.argos.co.uk

The information contained in this message or any of its attachments may be privileged and confidential, and is intended exclusively for the addressee.
The views expressed may not be official policy, but the personal views of the originator.
If you are not the intended addressee, any disclosure, reproduction, distribution, dissemination or use of this communication is not authorised.
If you have received this message in error, please advise the sender by using your reply facility in youe e-mail software.
All messages sent and received by Argos Ltd are monitored for virus, high risk file extensions, and inappropriate content. As a result users should be aware that mail maybe accessed.

**

ebcdic to ascii conversion in MQseries

[Manish Sharma]

Hi,
We have a setup wherein we communicate between two applications using
MQseries 5.1 installed on sunsolaris and MQSeries on mainframes. When any
message is written from mainframes and read from Unix local queue we 
get junk characters. 
I have heard that some X format to ASCII conversion is required 
on message.
It would be very helpful if someone can 
let us know.
1> What is this X format.
2> Do we have to do this conversion programatically or just set the 
property
in a queue.
3> Any other methods by which i can achieve this.
 

  -Original Message-From: MQSeries List 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Rosangela 
  AndradeSent: Tuesday, December 31, 2002 2:27 PMTo: 
  [EMAIL PROTECTED]Subject: Trigger
  I 
  have a program that of the one get browse in the DLQ and later records another 
  line with in syncponit. However when cics falls, in the following day it comes 
  back to record the same messages of the DLQ in the other line. Please, as I 
  make this not to happen 
  Tia
   
  Rosangela
   
  
  
  Busca Yahoo! O melhor 
  lugar para encontrar tudo o que vocj procura na 
Internet

Trigger

[Rosangela Andrade]

I have a program that of the one get browse in the DLQ and later records another line with in syncponit. However when cics falls, in the following day it comes back to record the same messages of the DLQ in the other line. Please, as I make this not to happen 
Tia
 
Rosangela
 Busca Yahoo! 
O melhor lugar para encontrar tudo o que vocj procura na Internet

Hi

[Shailesh Kumar U]

Hi MqSeries bonds,
 
    How are you all? I am missing u 
so much.
    As of Now I do not have any 
questions.
    See u later 
 
By
Regards   Shailesh 
Kumar

Re: WMQI: ACL Problems

[K K HK]

Manish,

Do you get error message on CICS or DB2 log?   I think the userid assigned
to the MQ triggered transaction is different from the one which does not
encountered problem.

Could you try to assign same userID to the MQ triggered transaction?

KK






Original Message Follows
From: Manish Sharma <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: WMQI: ACL Problems
Date: Mon, 30 Dec 2002 20:19:22 +0530

Hi,

I am working on IBM-3090.  I have a MQ triggered program in
COBOL-CICS.  This program gets the data from the queue and xctls to another
CICS program which accesses DB2 database.  The problem is that I cannot
access DB2 in this second program.  I am getting an sqlcode of -922.  If I
trigger the program which reads from the queue directly through CICS it runs
fine and gets the database access.  Can anybody give any clue what may be
the reason ?

Manish Sharma
___
Patni Computer Systems Limited
Mumbai - 400 096
Tel: 91 22 8291454 ext. 5537
Fax: 91 22 8291778

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


_
The new MSN 8: smart spam protection and 3 months FREE*.
http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_smartspamprotection_3mf

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