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 |
|
 |
|