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 » To drain a MQ thru JCL

Post new topic  Reply to topic
 To drain a MQ thru JCL « View previous topic :: View next topic » 
Author Message
Umeshrath
PostPosted: Thu Apr 20, 2006 6:55 pm    Post subject: To drain a MQ thru JCL Reply with quote

Novice

Joined: 27 Dec 2005
Posts: 23
Location: Hyderabad

I tried the saem JCL but it is giving this error message.
Can anybody help me on this?

//STEP010 EXEC PGM=CSQUTIL,
// PARM='SMQE'
//STEPLIB DD DSN=SYS1.SCSQANLE,DISP=SHR
// DD DSN=SYS1.SCSQAUTH,DISP=SHR
//SYSIN DD *
COMMAND
//CSQUCMD DD *
CLEAR QLOCAL(HSSERR.SMQE)
/*
//SYSPRINT DD SYSOUT=*

This is my job. HSSERR is the name of the queue.

In the JCL provided by you you hav written that
CLEAR QLOCAL(HLQ.your queue)

What is this HLQ? Do we have to write HLQ.HSSERR. I tried that also.
But i am getting the following message in my spool.

COMMAND
CSQU127I Executing COMMAND using input from CSQUCMD data set
CSQU120I Connecting to SMQE
CSQU121I Connected to queue manager SMQE
CSQU055I Target queue manager is SMQE
CLEAR QLOCAL(SMQE.HSSERR)
CSQN205I COUNT= 3, RETURN=00000020, REASON=FFFFFFFF
CSQ9016E )SE CLEAR COMMAND REJECTED, UNAUTHORIZED REQUEST
CSQ9023E )SE CSQ9SCND 'CLEAR QLOCAL' ABNORMAL COMPLETION
CSQU057I 1 commands read
CSQU058I 1 commands issued and responses received, 1 failed
CSQU143I 1 COMMAND statements attempted
CSQU144I 1 COMMAND statements executed successfully
CSQU148I CSQUTIL Utility completed, return code=0

Regards,
Umesh
_________________
Umesh Rath
Back to top
View user's profile Send private message Send e-mail
wschutz
PostPosted: Fri Apr 21, 2006 1:36 am    Post subject: Reply with quote

Jedi Knight

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

Quote:
CSQ9016E
'cmd' command request not authorized
Explanation:

The command requires a level of authorization that you do not have, either for the command itself, or for the resource that it is operating on.
System Action:

The command is not executed. Processing is terminated.
Operator Response:

If the command must be executed on behalf of the user and your installation operating procedures permit it, enter the command on request.
System Programmer Response:

Contact the system programmer responsible for system security, and request that this person grant you authorization to use the command. Otherwise, you must have someone who is authorized issue the command for you.


And...I don't know where you got the HLQ bit, but you specify the name of the queue inside the brackets:
Quote:
CLEAR QLOCAL(HSSERR)
if HSSERR is the name of the queue.
_________________
-wayne
Back to top
View user's profile Send private message Send e-mail AIM Address
wschutz
PostPosted: Fri Apr 21, 2006 2:08 am    Post subject: Reply with quote

Jedi Knight

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

and PLEASE don't DOUBLE POST.....it really annoys us
http://www.mqseries.net/phpBB2/viewtopic.php?t=28684&highlight=
_________________
-wayne
Back to top
View user's profile Send private message Send e-mail AIM Address
Umeshrath
PostPosted: Fri Apr 21, 2006 7:00 am    Post subject: Reply with quote

Novice

Joined: 27 Dec 2005
Posts: 23
Location: Hyderabad

Sorry WSCHUTZ for double posting.

It really annoys people.

Thanks a lot for the answer.

I will check with the MQ admini guys and let u know the outcome.

Regards,
Umesh
_________________
Umesh Rath
Back to top
View user's profile Send private message Send e-mail
Umeshrath
PostPosted: Sun Apr 23, 2006 8:04 pm    Post subject: Reply with quote

Novice

Joined: 27 Dec 2005
Posts: 23
Location: Hyderabad

Hi,

I discussed about the CLEAR command with MQ admini.They said they never gave access for this command to anybody.

They are saying if the MQ is open by anychance while issuing this command then this command will not work.

Do u have any idea about this?

Regards,
Umesh
_________________
Umesh Rath
Back to top
View user's profile Send private message Send e-mail
Mr Butcher
PostPosted: Sun Apr 23, 2006 9:52 pm    Post subject: Reply with quote

Padawan

Joined: 23 May 2005
Posts: 1716

thats true, if the queue is in use the clear command will not work.

you can use a small program to read the queue empty if you want to "clear" it (modify one of the samples)
_________________
Regards, Butcher
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 » To drain a MQ thru 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.