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 » General IBM MQ Support » MQSeries + PGM8

Post new topic  Reply to topic
 MQSeries + PGM8 « View previous topic :: View next topic » 
Author Message
Wasabi
PostPosted: Wed Jun 04, 2008 8:07 am    Post subject: MQSeries + PGM8 Reply with quote

Newbie

Joined: 04 Jun 2008
Posts: 1

Hi folks!

I'm almost sure this isn't the right forum, but I don't know whom or where to ask. I think you might know the answer, though.

I have various MQSeries Queues which I access via Oracle's PGM8 package.

Often, these queues will spit out an error 2042, which means the object is already in use (a script terminated not properly). When the scripts fail, there is no way to close the queue properly, because the queue handle is gone by then.

The admin (read: my contact person) of the MQSeries Queues I have access to hasn't got permission to kill those blocking processes. He sais I can do it remotely as I established the connections, but I don't know how.

So...is there anyway to kill the opened "session" remotely from my client database (Oracle 9i) via PGM8?
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Wed Jun 04, 2008 3:35 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

I suppose you are accessing MQ via a client connection. If you need the connection killed, provide the MQ admin with the connection information. Close all your PGM8 access to MQ and ask the MQ Admin to force close your channel. If the channel is not reserved for your use exclusively request a new channel be defined for your exclusive use. After the MQAdmin has started your channel again you can restart working with your PGM8 package.

Enjoy
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » MQSeries + PGM8
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.