| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Change of PSID |
« View previous topic :: View next topic » |
| Author |
Message
|
| GheorgheDragos |
 Posted: Tue Apr 14, 2020 3:03 am Post subject: Change of PSID |
 |
|
Acolyte
Joined: 28 Jun 2018
Posts: 51
|
Dear MQ community,
With a lot of effort and time spent I have finally put together a proposal to move around queues from one PS/BP to another to prevent queues that contain very short lived messages to be on the same storage media/BP that buffers, for performance increase. There are a couple of options I can think of for moving queues :
a) ALTER STGCLASS to change PSET;
b) MOVE QLOCAL to move also messages;
c) COPY MESSAGES/DEFINE LIKE/DELETE/DEFINE LIKE in batch
d) ALTER QLOCAL (STGCLASS) to change the storage class to a newly defined one
If anyone has done this activity before.. would any of the commands or scenarios above work if : queues are in use / queues have messages. If option 4, and I alter the stgclass, will the messages be moved to the new stgclass as well ? Will the cmd work even if the queue has messages ?
Thank you for your time
Dragos |
|
| Back to top |
|
 |
| gbaddeley |
| Posted: Tue Apr 14, 2020 3:33 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
Option d ? If there are any msgs on the queue, unload or clear them. Alter the queue to change the stgclass. If necessary, load msgs back onto the queue.
_________________
Glenn |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Tue Apr 14, 2020 3:46 pm Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
Moved to mainframe forum.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| hughson |
| Posted: Wed Apr 15, 2020 12:42 am Post subject: Re: Change of PSID |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
Location: Bay of Plenty, New Zealand
|
| IBM Knowledge Center wrote: |
Moving a non-shared queue
To move queues and their messages from one page set to another, use the MQSC MOVE QLOCAL command. When you have identified the queue or queues that you want to move to a new page set, follow this procedure for each of these queues:
- Ensure that the queue you want to move is not in use by any applications (that is, IPPROCS and OPPROCS values from the DISPLAY QSTATUS command are zero) and that it has no uncommitted messages (the UNCOM value from the DISPLAY QSTATUS command is NO).
- Prevent applications from putting messages on the queue being moved by altering the queue definition to disable MQPUTs. Change the queue definition to PUT(DISABLED).
- Define a temporary queue with the same attributes as the queue that is being moved, using the command:
| Code: |
| DEFINE QL(TEMP_QUEUE) LIKE(QUEUE_TO_MOVE) PUT(ENABLED) GET(ENABLED) |
- Move the messages to the temporary queue using the following command:
| Code: |
| MOVE QLOCAL(QUEUE_TO_MOVE) TOQLOCAL(TEMP_QUEUE) |
- Delete the queue you are moving, using the command:
| Code: |
| DELETE QLOCAL(QUEUE_TO_MOVE) |
- Define a new storage class that maps to the required page set, for example:
| Code: |
| DEFINE STGCLASS(NEW) PSID(nn) |
Add the new storage class definition to the CSQINP2 data sets ready for the next queue manager restart.
- Redefine the queue that you are moving, by changing the storage class attribute:
| Code: |
| DEFINE QL(QUEUE_TO_MOVE) LIKE(TEMP_QUEUE) STGCLASS(NEW) |
When the queue is redefined, it is based on the temporary queue created in step 3.
- Move the messages back to the new queue, using the command:
| Code: |
| MOVE QLOCAL(TEMP) TOQLOCAL(QUEUE_TO_MOVE) |
- The queue created in step 3 is no longer required. Use the following command to delete it:
| Code: |
| DELETE QL(TEMP_QUEUE) |
- If the queue being moved was defined in the CSQINP2 data sets, change the STGCLASS attribute of the appropriate DEFINE QLOCAL command in the CSQINP2 data sets. Add the REPLACE keyword so that the existing queue definition is replaced.
|
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
