MQSeries.net
Search
Tech Exchange
Education
Certifications
Library
Info Center
SupportPacs
LinkedIn
Search
FAQ
 Â
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
»
IBM MQ Installation/Configuration Support
»
Massive ALTER QLOCAL()s, best approach...
Massive ALTER QLOCAL()s, best approach...
«
View previous topic
::
View next topic
»
Author
Message
HenriqueS
Posted: Fri Sep 26, 2008 11:35 am
Post subject: Massive ALTER QLOCAL()s, best approach...
Master
Joined: 22 Sep 2006
Posts: 235
Hello folks,
What would be the best way to do this? It´s a massive ALTER QLOCAL changing...
ALTER QLOCAL (QM.XXXX) TRIGGER INITQ(SYSTEM.CHANNEL.INITQ) TRIGDATA(YYYYY.TO.XXXXX)
WHERE XXXX is the name of the remote location... YYYYY is my location.
Is there a tool to help on that or Unix scripting is the way to go?
_________________
HenriqueS
Certified Websphere MQ 6.0 System Administrator
Back to top
Tibor
Posted: Tue Sep 30, 2008 6:36 am
Post subject:
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
Try this one-liner for creating an mqsc script:
Code:
echo "dis ql(QM.*)" | runmqsc QMGRNAME | grep QUEUE | tr '()' ' ' | tr -s ' ' | cut -f3 -d' ' | cut -f2- -d'.' | xargs -I %% echo "alter qlocal (XMIT_%%) trigger initq(SYSTEM.CHANNEL.INITQ) trigdata(YYYY.TO.%%)"
Hope this helps,
Tibor
Back to top
HenriqueS
Posted: Wed Nov 05, 2008 5:58 am
Post subject:
Master
Joined: 22 Sep 2006
Posts: 235
Thanks a lot, helped much.
_________________
HenriqueS
Certified Websphere MQ 6.0 System Administrator
Back to top
Display posts from previous:
All Posts
1 Day
7 Days
2 Weeks
1 Month
3 Months
6 Months
1 Year
Oldest First
Newest First
Page
1
of
1
MQSeries.net Forum Index
»
IBM MQ Installation/Configuration Support
»
Massive ALTER QLOCAL()s, best approach...
Jump to:
Select a forum
General Discussion
----------------
Read First for All New to IBM MQ, Integration, Messaging, WebSphere - Only Moderators Post Here
General Discussion
Messaging and Integration Technologies FAQ
News/Updates
Links
Job Seekers
Job Postings
General Forums Information
Requirements, Wishlists & Enhancement Requests
----------------
RFEs - Requirements, Wishlists & Enhancement Requests - Open Forum
IBM MQ Support
----------------
General IBM MQ Support
IBM MQ Cloud and SaaS, Cloud Hybrid and Containers
IBM MQ Installation/Configuration Support
Clustering
IBM MQ Telemetry / Low Latency Messaging / Everyplace
Mainframe, CICS, TXSeries
iSeries, OpenVMS, HP-NSS
IBM MQ Performance Monitoring
IBM MQ Security
IBM MQ Development
----------------
IBM MQ Java / JMS
IBM MQ API Support
Multiphase Commit
User Exits
WebSphere Message Broker
----------------
WebSphere Message Broker (ACE) Support
WMB Patterns Repository - Available for Download
WebSphere Application Server
----------------
WebSphere Application Server
Web Services
----------------
WebSphere DataPower
Products that use IBM MQ
----------------
Workflow Engines - IBM MQ Workflow & Business Process Choreographer
WebSphere Process Server (WID/WPS/WAS+)
WebSphere Interchange Server + Adapters
IBM MQ File Transfer Edition
Resources, Files, Samples, Archives, Misc
----------------
Files and Code Samples
Archives - All
Challenge Forum
Sponsored Forums
----------------
Cressida Technology
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.