Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 7 Administering Message Queues and Mbox Sets : Using SWDIR\util\swadm to Administer Mbox Sets, Message Queues and Messages : Add a Message Queue

Add a Message Queue
When adding queues, you have to add:
1.
2.
3.
To set up a new queue on your system (so that you can then add it to an Mbox set), use the following command:
swadm add_queue queue_name message_type queue_description
where:
queue_name is a descriptive alphanumeric name for the queue.
message_type is used to identify the message type. This should be Local (for local messages).
queue_description specifies the physical database table that is used to hold the queue, in the following format:
version: table
where:
version is an internal number used by iProcess Suite to identify the physical syntax of the string that follows it. This should be either:
0001, for Oracle AQ.
0003, for queues that are held in the iProcess database.
table is the name of the database table that holds the queue, and must be specified in the format needed to access the table (e.g. MS-SQL, DB2 or Oracle AQ).
The database table used to hold the queue must already exist, and must conform to the appropriate format. If it does not, messages will not be able to be added to or read from the queue and iProcess Engine will not function correctly. For more information, see:
“Oracle AQ Queue Tables and Queues” in TIBCO iProcess Engine (Oracle) Administrator's Guide (for Oracle AQ tables).
“iProcess DB2 Database Queues” in TIBCO iProcess Engine (DB2)s Administrator's Guide (for iProcess database tables in a DB2 database).
“iProcess SQL Server Database Queues” in TIBCO iProcess Engine (SQL): Administrator's Guide (for iProcess database tables in a SQL Server database).
If you are using queues held in the iProcess database (version = 0003), you should note that:
The iProcess Engine database schema owner (default swpro) must have at least insert, select and delete permissions on the database table used to hold the queue.
The iProcess Engine database user (default swuser) must have at least insert permissions on the database table used to hold the queue.
Examples
1.
swadm add_queue BGMBOX3 Local 0003:swpro.sw_db_wisqueue3
2.
swadm add_queue BGMBOX4 Local 0003:sw.bart.sw_db_bgqueue4

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved