adding a queue manager, DB2 tables, queue-sharing groups, adding a queue-sharing group, removing from DB2 tables, removing a queue manager, removing a queue-sharing group, migration, data-sharing group, migrating a data-sharing group, queue-sharing group, migrating a queue-sharing group" /> Keywords and parameters

 

Keywords and parameters

Queue-sharing group utility 





>>-PARM='------------------------------------------------------->

>--+-ADD QMGR,qmgr-name,qsg-name,dsg-name,DB2-ssid----+-'------><
   +-ADD QSG,qsg-name,dsg-name,DB2-ssid---------------+
   +-REMOVE QMGR,qmgr-name,qsg-name,dsg-name,DB2-ssid-+
   +-REMOVE QSG,qsg-name,dsg-name,DB2-ssid------------+
   +-MIGRATE DSG,dsg-name,DB2-ssid--------------------+
   +-MIGRATE QSG,qsg-name,dsg-name,DB2-ssid-----------+
   +-FORCE QMGR,qmgr-name,qsg-name,dsg-name,DB2-ssid--+
   '-VERIFY QSG,qsg-name,dsg-name,DB2-ssid------------'

A queue-sharing group name (qsg-name) can have up to 4 characters, comprising uppercase A-Z, 0-9, $, #, @. It must not start with a numeric. For implemtation reasons, names of less than 4 characters are padded internally with @ symbols, so do not use names ending in @.

PARM

This field contains the function request followed by the function-specific parameters. These are described below:

ADD QMGR

Add a queue manager record into the CSQ.ADMIN_B_QMGR table. This only completes successfully if a corresponding queue-sharing group record already exists in the CSQ.ADMIN_B_QSG table and the queue manager entry does not already exist in the CSQ.ADMIN_B_QMGR table as the member of a different queue-sharing group.

qmgr-name

The queue manager name

qsg-name

The queue-sharing group name

dsg-name

The DB2 data-sharing group name

DB2-ssid

The DB2 subsystem ID

ADD QSG

Add a queue-sharing group record into the CSQ.ADMIN_B_QSG table.

qsg-name

The queue-sharing group name

dsg-name

The DB2 data-sharing group name

DB2-ssid

The DB2 subsystem ID

REMOVE QMGR

Remove a queue manager record from the CSQ.ADMIN_B_QMGR table. This only completes successfully if the queue manager has either never been started, or terminated normally from its last execution.

qmgr-name

The queue manager name

qsg-name

The queue-sharing group name

dsg-name

The DB2 data-sharing group name

DB2-ssid

The DB2 subsystem ID

REMOVE QSG

Remove a queue-sharing group record from the CSQ.ADMIN_B_QSG table. This only completes successfully if no queue managers are defined to the queue-sharing group.

qsg-name

The queue-sharing group name

dsg-name

The DB2 data-sharing group name

DB2-ssid

The DB2 subsystem ID

MIGRATE DSG

Check that the installation is ready to migrate its DB2 data-sharing group table definitions from WebSphere MQ V5.3 or 5.3.1 to WebSphere MQ V6.0.

It verifies that:

  • All the queue managers in the data-sharing group have applied the migration & coexistence PTF and have since been started.

  • The data-sharing group has not already been migrated.

dsg-name

The DB2 data-sharing group name

DB2-ssid

The DB2 subsystem ID
This function does not actually do the migration, which involves several steps. It is included as part of the sample migration job CSQ45ATB in thlqual SCSQPROC.

Migration requires that a migration PTF is installed on all queue managers in the data-sharing group.

For more details about migration to V6.0 and the migration & coexistence PTF, see the WebSphere MQ for z/OS System Setup Guide.

MIGRATE QSG

Check that the installation is ready to migrate its DB2 queue-sharing group table definitions from WebSphere MQ V5.3 or Version 5.3.1 to WebSphere MQ V6.0.

The MIGRATE QSG and MIGRATE DSG functions perform exactly the same function. The only difference is in the scope of the processing. MIGRATE QSG works on a single queue-sharing group only, MIGRATE DSG works on all queue-sharing groups that are defined within the data-sharing group.

It verifies that:

  • All the queue managers in the queue-sharing group have applied the migration & coexistence PTF and have since been started.

qsg-name

The queue-sharing group name

dsg-name

The DB2 data-sharing group name

DB2-ssid

The DB2 subsystem ID
This function does not actually do the migration, which involves several steps. It is included as part of the sample migration job CSQ45ATB in thlqual SCSQPROC.

Migration requires that a migration PTF is installed on all queue managers in the queue-sharing group.

For more details about migration to V6.0 and the migration & coexistence PTF, see the WebSphere MQ for z/OS System Setup Guide.

FORCE QMGR

Remove a queue manager record from the CSQ.ADMIN_B_QMGR table, even if the queue manager has terminated abnormally.
Attention:
This can override WebSphere MQ efforts to maintain data in a consistent state. Only use this function when we cannot carry out the procedure for removing a queue manager from a queue sharing group on page Removing a queue manager from a queue-sharing group.

qmgr-name

The queue manager name

qsg-name

The queue-sharing group name

dsg-name

The DB2 data-sharing group name

DB2-ssid

The DB2 subsystem ID

VERIFY QSG

Validate the consistency of the DB2 object definitions for queue manager, CF structure, and shared queue objects, within the queue-sharing group.

qsg-name

The queue-sharing group name

dsg-name

The DB2 data-sharing group name

DB2-ssid

The DB2 subsystem ID