Task 16: Add the IBM MQ entries to the Db2 tables

If you are using queue-sharing groups, run the CSQ5PQSG utility to add queue-sharing group and queue manager entries to the IBM® MQ tables in the Db2® data-sharing group.

  • Repeat this task for each IBM MQ queue-sharing group and each queue manager.
  • You might need to perform this task when migrating from a previous version.
  • Omit this task if you are not using queue-sharing groups.

    If you later want to use queue-sharing groups, perform this task at that time.

Run CSQ5PQSG for each queue-sharing group and each queue manager that is to be a member of a queue-sharing group. (CSQ5PQSG is described in the Administering IBM MQ for z/OS®.)

Perform the following actions in the specified order:
  1. Add a queue-sharing group entry into the IBM MQ Db2 tables using the ADD QSG function of the CSQ5PQSG program. A sample is provided in thlqual.SCSQPROC(CSQ45AQS).

    Perform this function once for each queue-sharing group that is defined in the Db2 data-sharing group. The queue-sharing group entry must exist before adding any queue manager entries that reference the queue-sharing group.

  2. Add a queue manager entry into the IBM MQ Db2 tables using the ADD QMGR function of the CSQ5PQSG program. A sample is provided in thlqual.SCSQPROC(CSQ45AQM).

    Perform this function for each queue manager that is to be a member of the queue-sharing group.

    Note:
    1. A queue manager can only be a member of one queue-sharing group.
    2. You must have RRS running to be able to use queue-sharing groups.