| Author | 
		  Message
		 | 
		
		  | tophoven | 
		  
		    
			  
				 Posted: Mon Mar 12, 2007 4:39 am    Post subject: Alter Queue does not work | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 08 Dec 2005 Posts: 6
  
  | 
		  
		    
			  
				Hello all,
 
 
I want to change the StorageClass of the SYSTEM.PENDING.DATA.QUEUE unfortunately I get an error when I try to execute following statement via Job:
 
 
  ALTER                                                                    -
 
    QLOCAL(SYSTEM.PENDING.DATA.QUEUE)               -
 
    QSGDISP(QMGR)                                                  -
 
    STGCLASS(SGSYS01)                                
 
 
I get a message, that the STGCLASS ACTIVE OR QUEUE IN USE .
 
And this is right. 
 
After that I tried to change the Queue during the System Startup of the Queue Manager but in the CSQINP1 the command doesn't work with the Error: Command cannot be issued from CSQINP1
 
 
If I put the Command in the CSQINP2 Dataset I get the same error as if I didt it with a job.
 
 
Can anyone help me, how I can change the StgClass for this Queue?
 
 
Tanks in advanced
 
 
Franz-Josef | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Michael Dag | 
		  
		    
			  
				 Posted: Mon Mar 12, 2007 4:57 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 13 Jun 2002 Posts: 2607 Location: The Netherlands (Amsterdam) 
  | 
		  
		    
			  
				oops... fat fingers... _________________ Michael
 
 
 
 
 
MQSystems Facebook page
  Last edited by Michael Dag on Mon Mar 12, 2007 4:58 am; edited 1 time in total | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Michael Dag | 
		  
		    
			  
				 Posted: Mon Mar 12, 2007 4:57 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 13 Jun 2002 Posts: 2607 Location: The Netherlands (Amsterdam) 
  | 
		  
		    
			  
				does the command work for other queues? 
 
 
maybe you cannot change the storage class of SYSTEM.* queues...    _________________ Michael
 
 
 
 
 
MQSystems Facebook page | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Vitor | 
		  
		    
			  
				 Posted: Mon Mar 12, 2007 4:57 am    Post subject: Re: Alter Queue does not work | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA 
  | 
		  
		    
			  
				
   
	| tophoven wrote: | 
   
  
	I get a message, that the STGCLASS ACTIVE OR QUEUE IN USE .
 
And this is right. 
 
 | 
   
 
 
 
I agree - as per the manual:
 
 
   
	| Quote: | 
   
  
	STGCLASS(string)
 
The name of the storage class.
 
This parameter is supported only on local and model queues.
 
This is an installation-defined name.
 
This parameter is valid on z/OS only. For more information, see the
 
WebSphere MQ for z/OS Concepts and Planning Guide.
 
The first character of the name must be uppercase A through Z, and
 
subsequent characters either uppercase A through Z or numeric 0 through
 
9.
 
Note: You can change this parameter only if the queue is empty and
 
closed. | 
   
 
 
 
So making sure the queue is empty and closed would seem to be the way forward. Which could be tricky for a system queue.
 
 
Or am I missing something?    _________________ Honesty is the best policy.
 
Insanity is the best defence. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | tophoven | 
		  
		    
			  
				 Posted: Mon Mar 12, 2007 5:04 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 08 Dec 2005 Posts: 6
  
  | 
		  
		    
			  
				
   
	| Michael Dag wrote: | 
   
  
	does the command work for other queues? 
 
 
maybe you cannot change the storage class of SYSTEM.* queues...    | 
   
 
 
 
yes i does | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | bruce2359 | 
		  
		    
			  
				 Posted: Mon Mar 12, 2007 8:03 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Guest
 
 
 
 
 
  | 
		  
		    
			  
				| INP1 concatenation is for defining buffers and such - BEFORE objects are defined in INP2 concatenation. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | kevinf2349 | 
		  
		    
			  
				 Posted: Mon Mar 12, 2007 11:25 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand Master
 
 Joined: 28 Feb 2003 Posts: 1311 Location: USA 
  | 
		  
		    
			  
				I guess the obvious question is...why do you need to change it's storage class?
 
 
I believe the SPDQ is a new queue with version 6 but I am pretty sure that the queue manager itself will have it open so you may be SOL for doing an ALTER.
 
 
Have you tried doing a DEFINE REPLACE in the CSQINP2 deck? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |