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 » creating 7000 Queues at one Shot

Post new topic  Reply to topic
 creating 7000 Queues at one Shot « View previous topic :: View next topic » 
Author Message
Gaya3
PostPosted: Thu Apr 03, 2008 1:30 am    Post subject: creating 7000 Queues at one Shot Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

Hi All

Are there any support pacs or any tools which helps me to create 7000+ queues at one shot.

If so please let me know.

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die


Last edited by Gaya3 on Thu Apr 03, 2008 1:31 am; edited 1 time in total
Back to top
View user's profile Send private message
zpat
PostPosted: Thu Apr 03, 2008 1:40 am    Post subject: Reply with quote

Jedi Council

Joined: 19 May 2001
Posts: 5866
Location: UK

Write some simple program to generate the DEFINE commands and execute this command file with RUNMQSC.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Apr 03, 2008 1:40 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Well... MS0S can help, at least in terms of letting you create an MQSC script with 7000 "Define queue" commands.

But you probably want a script, instead, that will create the file for you.

I hope you have a naming standard!
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Gaya3
PostPosted: Thu Apr 03, 2008 2:11 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

Thanks, let me see MS0S support pac

yes, there are naming standards in place.

Yes, i thought of doing it using shell scripts,

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Apr 03, 2008 2:11 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

zpat wrote:
Write some simple program to generate the DEFINE commands and execute this command file with RUNMQSC.





Don't forget you'll need the same or similar technology to administer the queues (change queue depth, set triggering, etc) and to produce setmqauth commands.

7000+ queues? Now that's what I call an MQ estate! I wish you joy with it

(Out of morbid curiosity, why that number? All on 1 queue manager?)
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Gaya3
PostPosted: Thu Apr 03, 2008 2:22 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

I know 7000 queues that too under one queue manager

it will be cut short to 2000 to 3000 in one queue manager. ( with client )

*Convincing some one is the best part in life......

But coming up with a generic script is the teadious task now for me.

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Apr 03, 2008 2:33 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

Gaya3 wrote:
I know 7000 queues that too under one queue manager


It's a big and impressive number, but not beyond the bounds of reason. Administration will be the problem.

Gaya3 wrote:
it will be cut short to 2000 to 3000 in one queue manager. ( with client )


Deploy the trout.....

Gaya3 wrote:
But coming up with a generic script is the teadious task now for me.


Time to brush off those programming / scripting skills.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Gaya3
PostPosted: Thu Apr 03, 2008 2:36 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US



I have to

Vitor wrote:

Time to brush off those programming / scripting skills.


Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
Gaya3
PostPosted: Thu Apr 03, 2008 3:19 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

you jeff for MS0S tool,




regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
jeevan
PostPosted: Thu Apr 03, 2008 8:48 am    Post subject: Re: creating 7000 Queues at one Shot Reply with quote

Grand Master

Joined: 12 Nov 2005
Posts: 1432

Gaya3 wrote:
Hi All

Are there any support pacs or any tools which helps me to create 7000+ queues at one shot.

If so please let me know.

Regards
Gayathri


To answer, you need to tell us

Do you have queue maning standard or you can name a queue as Q1...Q7000 ( I hope you have queue namaing standard in place)

Do all of them have same attribute or differ?

What portion do you like to automate ? creating a defintion ( define queue local( ) ) or implementation or both?

what os ( for scripting purpose) you have to create these queue ? in windows or unix? or both?

First of all, you have to craete a file with all these queue names. Once you have a file with all the queue name, grou them based on

os
simiarl attributes
hostname
queue manager name

your file looks like :
Queues
Windows
Group A
Hostname
Queue Name
.
.
.
Group B
Hostname
Queue name
.
.
.
Unix
Group A
Hostname
Queue Name
.
.
.
Group B
Hostname
Queue name
.
.
.


Nothing will help you to do this. you have to do this yourself.

Once you have this file, you can create a script which create a defitnition, puts in the hierarchical directories and runs based on the os/hostname. You still need to pass the queue manager name, but if your server dns is aliased as the queue manager name, ( if the server contains only one queue namager) you can use the alias in hostname. Otherwise you also have to provide queue manager name under the hostname

With remote execution, you can execute all the script staying in one server ( I am not sure wether you can do remote execution to windows staying in unix box, but you can do vice versa - execute remotely staying in windows box(I think there exists some ssh client in windows by which you can execute the script in remote unix server)

If you are creating all the queues in one queue manager, it is much simpler. You just have a file with queue names, and have a simple script to create definition all in one file. run that file against runmqsc for the queue manager.



Thanks
Back to top
View user's profile Send private message
Gaya3
PostPosted: Thu Apr 03, 2008 7:36 pm    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

impressed, you made me to think again in to some more directions.

thanks let me look in to it

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Sun Apr 06, 2008 5:40 pm    Post subject: Reply with quote

Jedi Knight

Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia

Also consider capacity and sizing issues. Is the file system big enough to hold the maximum amount of data that needs to be queued at any one time?

# queues X maxdepth X maxmsgln = really big number !

If naming includes a queue number, use leading zeroes and allow for growth, ie. MY.Q00001, MY.Q00002 rather than MY.Q1, MY.Q2.

I also question a design which requires so many queues. It could be very inefficient. Can you share any details?
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Sun Apr 06, 2008 11:53 pm    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

gbaddeley wrote:
Also consider capacity and sizing issues. Is the file system big enough to hold the maximum amount of data that needs to be queued at any one time?

# queues X maxdepth X maxmsgln = really big number !


Not to mention log, if persistent messages are in use...
_________________
I am *not* the model of the modern major general.
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 » General IBM MQ Support » creating 7000 Queues at one Shot
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.