Creating the WebSphere MQ queues

To test the SimplifiedDBRouting message flow that you create, you must also create the required WebSphere MQ local queues.

The following script creates the queues that you require for the SimplifiedDBRouting message flow:

********************************************
*  Define the queues for SimplifiedDBRouting    *
*************************************************
DEFINE QL('SIMPLERROUTEDB_IN')   REPLACE
DEFINE QL('SIMPLERROUTEDB_FAILURE')  REPLACE
DEFINE QL('SIMPLERROUTEDB_KEYNOTFOUND') REPLACE
DEFINE QL('SIMPLERROUTEDB_ORDERCLOCK') REPLACE
DEFINE QL('SIMPLERROUTEDB_SNRSTAFF') REPLACE
DEFINE QL('SIMPLERROUTEDB_DEFAULT') REPLACE

To create the queues:

  1. Copy and paste the script into a text editor, and save the file. You can choose any file name but the following instructions assume that you have called the file simplifieddbrouting.tst.
  2. In a command window, navigate to the directory containing simplifieddbrouting.tst, and enter the following command, where MB8QMGR is the name of the queue manager that hosts the broker to which you deploy the Simplified Database Routing sample:
    runmqsc MB8QMGR < simplifieddbrouting.tst

You can use the WebSphere MQ Explorer to check that the queues have been created.

Back to Building the Simplified Database Routing sample

Back to sample home