| Author | 
		  Message
		 | 
		
		  | rk400 | 
		  
		    
			  
				 Posted: Wed Mar 12, 2003 4:41 am    Post subject: altmqfls on TANDEM | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 04 Mar 2003 Posts: 27
  
  | 
		  
		    
			  
				Hi,
 
I am trying to increase the primary and secondary extets of my queue physical file using altmqfls. It says "type qlocal in use" where as it is not being used by any one of our processes. 
 
 
If I check using file info that file gets opened immed after starting the queue manager. 
 
 
Is there any way to increase the primary and secondary extents.
 
 
thanx
 
RK | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqonnet | 
		  
		    
			  
				 Posted: Wed Mar 12, 2003 6:23 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand Master
 
 Joined: 18 Feb 2002 Posts: 1114 Location: Boston, Ma, Usa. 
  | 
		  
		    
			  
				This is a known problem and is being fixed as per my knowledge.  And the problem is, you cannot altmqlfs and increase the size of a queue without bringing the QM down.  The new enhancement would enable the user to change the queue size without bringing the QM down.  
 
 
Hence at this point you dont have a choice but to end your qm and then change the queue size.
 
 
Cheers
 
Kumar _________________ IBM Certified WebSphere MQ V5.3 Developer
 
IBM Certified WebSphere MQ V5.3 Solution Designer
 
IBM Certified WebSphere MQ V5.3 System Administrator | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | rk400 | 
		  
		    
			  
				 Posted: Wed Mar 12, 2003 6:34 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 04 Mar 2003 Posts: 27
  
  | 
		  
		    
			  
				Hi Kumar,
 
I've tried with stopping the qmgr. Now it throws a different exception 
 
 
"The queue manager is not available for use".
 
 
Trying the following command:
 
 
altmqfls --qmgr QMNAME --type QLOCAL --qsize (100,200,959,1
 
00,200,959) QLOCAL1
 
 
Is there anything wrong in my command.... | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqonnet | 
		  
		    
			  
				 Posted: Wed Mar 12, 2003 7:27 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand Master
 
 Joined: 18 Feb 2002 Posts: 1114 Location: Boston, Ma, Usa. 
  | 
		  
		    
			  
				RK, i am sorry i did not put my words right.
 
The problem that was known was if there are any openers to the queue then you have to close all openers before changing the queue size.
 
 
In your case you dont see any openers but still get this error, 2042 from altmqfls, per my understanding.
 
 
Altmqfls needs the qmgr to be running.  Sorry for the confusion.
 
 
You have to figure out what apps have this queue opened and close them and re-issue altmqfls.  Bear in mind that there could always be outstanding transactions that account for openers.
 
 
Let me know how it goes and we can proceed.
 
 
 
Cheers
 
Kumar _________________ IBM Certified WebSphere MQ V5.3 Developer
 
IBM Certified WebSphere MQ V5.3 Solution Designer
 
IBM Certified WebSphere MQ V5.3 System Administrator | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | LuisFer | 
		  
		    
			  
				 Posted: Wed Mar 12, 2003 7:59 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Partisan
 
 Joined: 17 Aug 2002 Posts: 302
  
  | 
		  
		    
			  
				Normally the queue is open by a QServer (FUP LISTOPENS). You can do the following:
 
Create a new QServer (from Pathway INFO /OUT outqserv1/ MQS-QUEUE'', OBEYFORM, Tedit the outqserv1 file & change the SET SERVER PROCESS with F.E. $QQQQ, & the ADD SERVER MQS-QUEUE00 for MQS-QUEUE0X, from pathway OBEY outqserv1, this one make a new QServer process).
 
Do a DSPMQFLS -m QMGR -type QL Queue_name
 
Do a ALTMQFLS --qmgr QMGR --type QL --server $QQQQ  Queue_name
 
This one free the opener of the queue.
 
Do the ALTMQFLS with qsize. 
 
Return the Queue to the original Qserver (ALTMQFLS --qmgr --type QL --server $OLDQserverName Queue_name). THIS IS IMPORTANT, because the MQLQMAGS programs points to the original QServer Process. 
 
Regards | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | rk400 | 
		  
		    
			  
				 Posted: Thu Mar 13, 2003 12:13 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 04 Mar 2003 Posts: 27
  
  | 
		  
		    
			  
				Hi ,
 
 
I have tried by creating one more q server.. but when the queue server is up altmqfls thows an exception "object is in use". If I make it down then it says "AMQ0002: MQSeries was unable to display an error message 24720"
 
 
Is there any way of extending the primary and sencodary extents of q files?????? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | LuisFer | 
		  
		    
			  
				 Posted: Thu Mar 13, 2003 9:22 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Partisan
 
 Joined: 17 Aug 2002 Posts: 302
  
  | 
		  
		    
			  
				I don't understand, i make a probe & works fine with the SYSTEM.DEAD.LETTER.QUEUE. Following shows the Tacl sesion:
 
 
$SPOOL1 MQMMGR 3> dspmqfls -m QCMT33 -t ql SYSTEM.DEFAULT.LOCAL.QUEUE
 
$SPOOL1 MQMMGR 3..
 
CMQSeries Display MQ Files
 
 
CONNECTING.
 
QLOCAL    SYSTEM.DEFAULT.LOCAL.QUEUE                      
 
    $SPOOL1.QCMT33M.QSYSTEMX
 
    $SPOOL1.QCMT33M.OSYSTEMX
 
    $SPOOL1.QCMT33M.TSYSTEMX
 
 
    Queue/Status Server              :  DEFAULT
 
    Queue Server Options             :  C
 
    Message overflow threshold       :  200000 bytes
 
CC$SPOOL1 MQMMGR 4> runmq     ruinm   nmqsc 
 
C0791003, 5724-A39 (C) Copyright IBM Corp. 1993, 2001  All Rights Reserved.
 
 
Starting MQSeries Commands.
 
 
 
MQSC >dis ql(SYSTEM.DEAD.LETTER.QUEUE) ALL
 
     1 : dis ql(SYSTEM.DEAD.LETTER.QUEUE) ALL
 
AMQ8409: Display Queue details.
 
   DESCR(MQSeries default dead queue)      PROCESS( )
 
   BOQNAME( )                              INITQ( )
 
   TRIGDATA( )                             CLUSTER( )
 
   CLUSNL( )                               QUEUE(SYSTEM.DEAD.LETTER.QUEUE)
 
   CRDATE(2002-08-2                       CRTIME(11.44.32)
 
   ALTDATE(2002-08-2                      ALTTIME(11.45.49)
 
   GET(ENABLED)                            PUT(ENABLED)
 
   DEFPRTY(0)                              DEFPSIST(NO)
 
   MAXDEPTH(640000)                        MAXMSGL(4194304)
 
   BOTHRESH(0)                             SHARE
 
   DEFSOPT(SHARED)                         NOHARDENBO
 
   MSGDLVSQ(PRIORITY)                      RETINTVL(999999999)
 
   USAGE(NORMAL)                           NOTRIGGER
 
   TRIGTYPE(NONE)                          TRIGDPTH(1)
 
   TRIGMPRI(0)                             QDEPTHHI(80)
 
   QDEPTHLO(20)                            QDPMAXEV(ENABLED)
 
   QDPHIEV(DISABLED)                       QDPLOEV(DISABLED)
 
   QSVCINT(999999999)                      QSVCIEV(NONE)
 
   DISTL(NO)                               DEFTYPE(PREDEFINED)
 
   TYPE(QLOCAL)                            SCOPE(QMGR)
 
   DEFBIND(OPEN)                           IPPROCS(0)
 
   OPPROCS(1)                              CURDEPTH(21)
 
MQSC >EXIT
 
AMQ8438: One MQSC command read.
 
 
AMQ8439: No commands have a syntax error.
 
 
AMQ8435: All valid MQSC commands were processed.
 
 
CC$SPOOL1 MQMMGR 5> DSPMQFLS -m QCMT33 -T   t ql SYSTEM.DEAD.LETTER.QUEUE
 
CMQSeries Display MQ Files
 
 
CONNECTING.
 
QLOCAL    SYSTEM.DEAD.LETTER.QUEUE                        
 
    $SPOOL1.QCMT33M.QLCWY0KZ
 
    $SPOOL1.QCMT33M.OLCWY0KZ
 
    $SPOOL1.QCMT33M.TUDH5C9V
 
 
    Queue/Status Server              :  DEFAULT
 
    Queue Server Options             :  C
 
    Message overflow threshold       :  200000 bytes
 
CC$SPOOL1 MQMMGR 6> RUNMQSC 
 
C0791003, 5724-A39 (C) Copyright IBM Corp. 1993, 2001  All Rights Reserved.
 
 
Starting MQSeries Commands.
 
 
 
MQSC >DIS QL(SUS  YSTEM.DEAD.LETTER.QUEUE) ALL
 
     1 : DIS QL(SYSTEM.DEAD.LETTER.QUEUE) ALL
 
AMQ8409: Display Queue details.
 
   DESCR(MQSeries default dead queue)      PROCESS( )
 
   BOQNAME( )                              INITQ( )
 
   TRIGDATA( )                             CLUSTER( )
 
   CLUSNL( )                               QUEUE(SYSTEM.DEAD.LETTER.QUEUE)
 
   CRDATE(2002-08-2                       CRTIME(11.44.32)
 
   ALTDATE(2002-08-2                      ALTTIME(11.45.49)
 
   GET(ENABLED)                            PUT(ENABLED)
 
   DEFPRTY(0)                              DEFPSIST(NO)
 
   MAXDEPTH(640000)                        MAXMSGL(4194304)
 
   BOTHRESH(0)                             SHARE
 
   DEFSOPT(SHARED)                         NOHARDENBO
 
   MSGDLVSQ(PRIORITY)                      RETINTVL(999999999)
 
   USAGE(NORMAL)                           NOTRIGGER
 
   TRIGTYPE(NONE)                          TRIGDPTH(1)
 
   TRIGMPRI(0)                             QDEPTHHI(80)
 
   QDEPTHLO(20)                            QDPMAXEV(ENABLED)
 
   QDPHIEV(DISABLED)                       QDPLOEV(DISABLED)
 
   QSVCINT(999999999)                      QSVCIEV(NONE)
 
   DISTL(NO)                               DEFTYPE(PREDEFINED)
 
   TYPE(QLOCAL)                            SCOPE(QMGR)
 
   DEFBIND(OPEN)                           IPPROCS(0)
 
   OPPROCS(1)                              CURDEPTH(21)
 
MQSC >EXIT
 
AMQ8438: One MQSC command read.
 
 
AMQ8439: No commands have a syntax error.
 
 
AMQ8435: All valid MQSC commands were processed.
 
 
CC$SPOOL1 MQMMGR 7> ALTMQFLS --qmgr QCMT33 --type QL --server $QAQ1 SYSTEM.DEAD.LETTER.QUEUE
 
CMQSeries Alter MQ Files
 
 
$SPOOL1 MQMMGR 8> DSPMQFLS -m QCMT33 -t ql SYSTEM.DEAD.LETTER.QUEUE
 
$SPOOL1 MQMMGR 8..
 
CMQSeries Display MQ Files
 
 
CONNECTING.
 
QLOCAL    SYSTEM.DEAD.LETTER.QUEUE                        
 
    $SPOOL1.QCMT33M.QLCWY0KZ
 
    $SPOOL1.QCMT33M.OLCWY0KZ
 
    $SPOOL1.QCMT33M.TUDH5C9V
 
 
    Queue/Status Server              :  $QAQ1  ======change the QServer
 
    Queue Server Options             :  C
 
    Message overflow threshold       :  200000 bytes
 
CC$SPOOL1 MQMMGR 9> runmq  mqsc 
 
C0791003, 5724-A39 (C) Copyright IBM Corp. 1993, 2001  All Rights Reserved.
 
 
Starting MQSeries Commands.
 
 
 
MQSC >dis ql(system.dead.letter.queue) all 
 
     1 : dis ql(system.dead.letter.queue) all 
 
AMQ8409: Display Queue details.
 
   DESCR(MQSeries default dead queue)      PROCESS( )
 
   BOQNAME( )                              INITQ( )
 
   TRIGDATA( )                             CLUSTER( )
 
   CLUSNL( )                               QUEUE(SYSTEM.DEAD.LETTER.QUEUE)
 
   CRDATE(2002-08-2                       CRTIME(11.44.32)
 
   ALTDATE(2002-08-2                      ALTTIME(11.45.49)
 
   GET(ENABLED)                            PUT(ENABLED)
 
   DEFPRTY(0)                              DEFPSIST(NO)
 
   MAXDEPTH(640000)                        MAXMSGL(4194304)
 
   BOTHRESH(0)                             SHARE
 
   DEFSOPT(SHARED)                         NOHARDENBO
 
   MSGDLVSQ(PRIORITY)                      RETINTVL(999999999)
 
   USAGE(NORMAL)                           NOTRIGGER
 
   TRIGTYPE(NONE)                          TRIGDPTH(1)
 
   TRIGMPRI(0)                             QDEPTHHI(80)
 
   QDEPTHLO(20)                            QDPMAXEV(ENABLED)
 
   QDPHIEV(DISABLED)                       QDPLOEV(DISABLED)
 
   QSVCINT(999999999)                      QSVCIEV(NONE)
 
   DISTL(NO)                               DEFTYPE(PREDEFINED)
 
   TYPE(QLOCAL)                            SCOPE(QMGR)
 
   DEFBIND(OPEN)                           IPPROCS(0)
 
   OPPROCS(0) ==Not Open                     CURDEPTH(21)
 
MQSC >exit
 
AMQ8438: One MQSC command read.
 
 
AMQ8439: No commands have a syntax error.
 
 
AMQ8435: All valid MQSC commands were processed.
 
 
 
$SPOOL1 MQMMGR 12> altmqfls --QMGR    qmgr QCMT33 --type ql --qsize (100,200,959,1,9) SYSTEM.DEAD.LETTER.QUEUE
 
CMQSeries Alter MQ Files
 
 
CC$SPOOL1 MQMMGR 13> fc dsp
 
$SPOOL1 MQMMGR 13> DSPMQFLS -m QCMT33 -t ql SYSTEM.DEAD.LETTER.QUEUE
 
$SPOOL1 MQMMGR 13..
 
CMQSeries Display MQ Files
 
 
CONNECTING.
 
QLOCAL    SYSTEM.DEAD.LETTER.QUEUE                        
 
    $SPOOL1.QCMT33M.QLCWY0KZ
 
    $SPOOL1.QCMT33M.OLCWY0KZ
 
    $SPOOL1.QCMT33M.TUDH5C9V
 
 
    Queue/Status Server              :  $QAQ1
 
    Queue Server Options             :  C
 
    Message overflow threshold       :  200000 bytes
 
CC$SPOOL1 MQMMGR 14> fc altmq        h
 
 
5> DSPMQFLS -m QCMT33 -t ql SYSTEM.DEAD.LETTER.QUEUE
 
6> RUNMQSC
 
7> ALTMQFLS --qmgr QCMT33 --type QL --server $QAQ1 SYSTEM.DEAD.LETTER.QUEUE
 
8> DSPMQFLS -m QCMT33 -t ql SYSTEM.DEAD.LETTER.QUEUE
 
9> runmqsc
 
10> altmqfls --qmgr QMNAME --type QLOCAL --qsize (100,200,959,1
 
11> 9) QLOCAL1
 
12> altmqfls --qmgr QCMT33 --type ql --qsize (100,200,959,1,9) SYSTEM.DEAD.LETTE
 
R.QUEUE
 
13> DSPMQFLS -m QCMT33 -t ql SYSTEM.DEAD.LETTER.QUEUE
 
14> h
 
 
$SPOOL1 MQMMGR 15> fc 7
 
$SPOOL1 MQMMGR 15> ALTMQFLS --qmgr QCMT33 --type QL --server $QAQ1 SYSTEM.DEAD.L
 
ETTER.QUEUE
 
$SPOOL1 MQMMGR 15..                                              s
 
$SPOOL1 MQMMGR 15> ALTMQFLS --qmgr QCMT33 --type QL --server $QAQs SYSTEM.DEAD.L
 
ETTER.QUEUE
 
$SPOOL1 MQMMGR 15..
 
CMQSeries Alter MQ Files
 
 
CC$SPOOL1 MQMMGR 16> fc dsp
 
$SPOOL1 MQMMGR 16> DSPMQFLS -m QCMT33 -t ql SYSTEM.DEAD.LETTER.QUEUE
 
$SPOOL1 MQMMGR 16..
 
CMQSeries Display MQ Files
 
 
CONNECTING.
 
QLOCAL    SYSTEM.DEAD.LETTER.QUEUE                        
 
    $SPOOL1.QCMT33M.QLCWY0KZ
 
    $SPOOL1.QCMT33M.OLCWY0KZ
 
    $SPOOL1.QCMT33M.TUDH5C9V
 
 
    Queue/Status Server              :  DEFAULT
 
    Queue Server Options             :  C
 
    Message overflow threshold       :  200000 bytes
 
CC$SPOOL1 MQMMGR 17> runmqxs  sc
 
C0791003, 5724-A39 (C) Copyright IBM Corp. 1993, 2001  All Rights Reserved.
 
 
Starting MQSeries Commands.
 
 
 
MQSC >dis ql(system.dead.letet  ter.qiue   ueue) all 
 
     1 : dis ql(system.dead.letter.queue) all 
 
AMQ8409: Display Queue details.
 
   DESCR(MQSeries default dead queue)      PROCESS( )
 
   BOQNAME( )                              INITQ( )
 
   TRIGDATA( )                             CLUSTER( )
 
   CLUSNL( )                               QUEUE(SYSTEM.DEAD.LETTER.QUEUE)
 
   CRDATE(2002-08-2                       CRTIME(11.44.32)
 
   ALTDATE(2002-08-2                      ALTTIME(11.45.49)
 
   GET(ENABLED)                            PUT(ENABLED)
 
   DEFPRTY(0)                              DEFPSIST(NO)
 
   MAXDEPTH(640000)                        MAXMSGL(4194304)
 
   BOTHRESH(0)                             SHARE
 
   DEFSOPT(SHARED)                         NOHARDENBO
 
   MSGDLVSQ(PRIORITY)                      RETINTVL(999999999)
 
   USAGE(NORMAL)                           NOTRIGGER
 
   TRIGTYPE(NONE)                          TRIGDPTH(1)
 
   TRIGMPRI(0)                             QDEPTHHI(80)
 
   QDEPTHLO(20)                            QDPMAXEV(ENABLED)
 
   QDPHIEV(DISABLED)                       QDPLOEV(DISABLED)
 
   QSVCINT(999999999)                      QSVCIEV(NONE)
 
   DISTL(NO)                               DEFTYPE(PREDEFINED)
 
   TYPE(QLOCAL)                            SCOPE(QMGR)
 
   DEFBIND(OPEN)                           IPPROCS(0)
 
   OPPROCS(1)   ==the old open                           CURDEPTH(21)
 
MQSC > | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | LuisFer | 
		  
		    
			  
				 Posted: Thu Mar 13, 2003 9:33 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Partisan
 
 Joined: 17 Aug 2002 Posts: 302
  
  | 
		  
		    
			  
				| You can do a FUP ALTER XXXX, MAXEXTENS , PRIMARY, etc too. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | rk400 | 
		  
		    
			  
				 Posted: Mon Mar 17, 2003 2:03 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 04 Mar 2003 Posts: 27
  
  | 
		  
		    
			  
				how can fup alter be used for increasing the pr,sec extents of an unpartioned file??? pls let me know the syntax..
 
 
thanx
 
rk | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | LuisFer | 
		  
		    
			  
				 Posted: Mon Mar 17, 2003 5:20 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Partisan
 
 Joined: 17 Aug 2002 Posts: 302
  
  | 
		  
		    
			  
				Hi RK:
 
It's not possible to change the pri & sec , but yes the MAXEXTENTS. (Sorry)
 
FUP ALTER $VOL.SUBVOL_M.QFILE's, MAXEXTENTS 978. 
 
If you see the ZMQSSMPL.PARTIT sample macro, you can do a PARTIT QFiles.
 
Regards. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | bkasisch | 
		  
		    
			  
				 Posted: Mon Mar 17, 2003 4:01 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Novice
 
 Joined: 14 Oct 2002 Posts: 16
  
  | 
		  
		    
			  
				You guys are making this harder than you need to.
 
 
1. Use ALTMQFLS to get all the filenames for all the queues you want to modify.
 
2. Stop the Queue Manager
 
3. In Fup use "Set Like <filename>" to Set up a template
 
4. Then issue a set ext(pri,sec) (with your new values)
 
5. purge <filename> 
 
6  create <filename>
 
7  (repeat for all file names until done)
 
 
Restart the queue manager | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | rk400 | 
		  
		    
			  
				 Posted: Mon Mar 17, 2003 10:37 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 04 Mar 2003 Posts: 27
  
  | 
		  
		    
			  
				Now I am able to do it..
 
thanx a lot.. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |