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 IndexMainframe, CICS, TXSeriesChange of PSID

Post new topicReply to topic
Change of PSID View previous topic :: View next topic
Author Message
GheorgheDragos
PostPosted: Tue Apr 14, 2020 3:03 am Post subject: Change of PSID Reply with quote

Apprentice

Joined: 28 Jun 2018
Posts: 46

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
View user's profile Send private message
gbaddeley
PostPosted: Tue Apr 14, 2020 3:33 pm Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2190
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
View user's profile Send private message
bruce2359
PostPosted: Tue Apr 14, 2020 3:46 pm Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8815
Location: US: west coast, almost. Otherwise, enroute.

Moved to mainframe forum.
_________________
My life flows on in endless song;
How can I keep from singing?
Back to top
View user's profile Send private message
hughson
PostPosted: Wed Apr 15, 2020 12:42 am Post subject: Re: Change of PSID Reply with quote

Padawan

Joined: 09 May 2013
Posts: 1512
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:
  1. 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).
  2. 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).
  3. 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)

  4. Move the messages to the temporary queue using the following command:
    Code:
    MOVE QLOCAL(QUEUE_TO_MOVE) TOQLOCAL(TEMP_QUEUE)

  5. Delete the queue you are moving, using the command:
    Code:
    DELETE QLOCAL(QUEUE_TO_MOVE)

  6. 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.
  7. 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.
  8. Move the messages back to the new queue, using the command:
    Code:
    MOVE QLOCAL(TEMP) TOQLOCAL(QUEUE_TO_MOVE)

  9. The queue created in step 3 is no longer required. Use the following command to delete it:
    Code:
    DELETE QL(TEMP_QUEUE)

  10. 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
View user's profile Send private message Visit poster's website
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexMainframe, CICS, TXSeriesChange of PSID
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.