ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Mainframe, CICS, TXSeries » MQ DB2 JCL

Post new topic  Reply to topic
 MQ DB2 JCL « View previous topic :: View next topic » 
Author Message
suresh_shahukaru
PostPosted: Mon Apr 24, 2006 6:19 am    Post subject: MQ DB2 JCL Reply with quote

Novice

Joined: 22 Apr 2006
Posts: 17

If anyone has got any sample JCL which runs a PL/1 / COBOL program using DB2 and MQ, please send me.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Mon Apr 24, 2006 6:30 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

http://publib.boulder.ibm.com/infocenter/wmqv6/v6r0/index.jsp?topic=/com.ibm.mq.csqzal.doc/sappls.htm
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
suresh_shahukaru
PostPosted: Tue Apr 25, 2006 10:11 am    Post subject: Reply with quote

Novice

Joined: 22 Apr 2006
Posts: 17

While link-editing,

for a IMS - MQ program we give CSQQSTUB
for a PL/1 - MQ batch program we give CSQBSTUB

What should be given for a DB2 - MQ program?
Back to top
View user's profile Send private message
wschutz
PostPosted: Tue Apr 25, 2006 10:15 am    Post subject: Reply with quote

Jedi Knight

Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)

http://publib.boulder.ibm.com/infocenter/wmqv6/v6r0/index.jsp?topic=/com.ibm.mq.csqzal.doc/preprn.htm
_________________
-wayne
Back to top
View user's profile Send private message Send e-mail AIM Address
suresh_shahukaru
PostPosted: Tue Apr 25, 2006 10:31 am    Post subject: Reply with quote

Novice

Joined: 22 Apr 2006
Posts: 17

I have been to that link which you have provided.

I tried using CSQBSTUB but it is failing with 2129.

Do I need to use any one of the following:

CSQBRRSI

CSQBRSTB
Back to top
View user's profile Send private message
wschutz
PostPosted: Tue Apr 25, 2006 10:36 am    Post subject: Reply with quote

Jedi Knight

Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)

So this is a subtle DOUBLE POST.... did you see JT's link on your other related posting:
http://www.mqseries.net/phpBB2/viewtopic.php?t=29017&highlight=2129
_________________
-wayne
Back to top
View user's profile Send private message Send e-mail AIM Address
suresh_shahukaru
PostPosted: Tue Apr 25, 2006 10:45 am    Post subject: Reply with quote

Novice

Joined: 22 Apr 2006
Posts: 17

I included the libraries in the STEPLIB but it didnt work.

Commented out the DB2 part in the program and re-ran as a normal MQ-PL/1 program and MQCONN was successful.

Any thoughts?
Back to top
View user's profile Send private message
kevinf2349
PostPosted: Tue Apr 25, 2006 10:52 am    Post subject: Reply with quote

Grand Master

Joined: 28 Feb 2003
Posts: 1311
Location: USA

Again.....

How about posting the JCL you ran? That may be of some help.
Back to top
View user's profile Send private message
suresh_shahukaru
PostPosted: Wed Apr 26, 2006 5:26 am    Post subject: 2019 Reason Code Reply with quote

Novice

Joined: 22 Apr 2006
Posts: 17

There was some problem in the JCL steplib that I gave. Now the MQCONN using MQ-PL1-DB2 is working fine.

But now I have got a different issue.

The MQCONN, MQOPEN and the first MQGET are successful. The second MQGET in the same unit of work is failing with 2019 error.

I got a similar error 2018 while doing MQPUT for the second time in IMS program, there the reason being the connection getting lost after IMS syncpoint and is fixed now.

Here in DB2, MQ program is there anyother similar that I need to take care to avoid the error 2019.
Back to top
View user's profile Send private message
wschutz
PostPosted: Wed Apr 26, 2006 10:16 am    Post subject: Reply with quote

Jedi Knight

Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)

Any chance you are accidently overlaying the variable that holds Hobj?
_________________
-wayne
Back to top
View user's profile Send private message Send e-mail AIM Address
suresh_shahukaru
PostPosted: Mon May 01, 2006 1:32 am    Post subject: Reply with quote

Novice

Joined: 22 Apr 2006
Posts: 17

Yes, you are correct. I am having different structures based on the same pointer and the pointer got assigned to a different structure.

Re-assigned the pointer to the MQGET structure and is working fine now.

Thanks.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » Mainframe, CICS, TXSeries » MQ DB2 JCL
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.