Description:
Case purging is a database intensive operation. It is recommended to set up a separate background (BG) process and a queue. This will allow purge instructions to be processed by dedicated BG's and not impact other BG instructions.

Steps to create a dedicated queue for purging using the wutil/swbatch command.

1). Stop iProcess Engine.

2). Create a new physical queue (say id = 7).

          Refer to the following document to create queue in Oracle, SQL or DB2

            a). TIBCO iProcess Engine (Oracle) Administrator's Guide  > Chapter 3 Mbox Sets and Message Queues > Oracle AQ Queue Tables and Queues
            b). TIBCO iProcess Engine (SQL) Administrator's Guide > Chapter 3 Mbox Sets and Message Queues > Creating Additional SQL Database Queue Tables
            c). TIBCO iProcess Engine (DB2) Administrator's Guide > Chapter 3 Mbox Sets and Message Queues > Creating Additional DB2 Database Queue Tables

   swadm add_queue PURGEMBOX1 Local 0001::purgemboxtable1:purgemboxqueue1

3). Create new mboxset (say id = 6).

  swadm add_mboxset PURGEBGMBSET1 Local

4). Add the new queue to the new mboxset.

  swadm add_queue_to_mboxset 6 7

5). Confirm that these have been set correctly.

           swadm show_mboxsets v
           swadm show_queues

6). Set swutil or swbatch to make calls via the new mbox set.

           swadm set_attribute 0 PSTAFFIFC 0 MBSET_WRITE_BG 6

           OR (for swbatch)

           swadm set_attribute 0 SWBATCH 0 MBSET_WRITE_BG 6

7). Add a new BG process (say 9).

           swadm add_process 1 BG enabled

8). Configure the new BG Processes to dequeue and enqueue on the same mbset.

          swadm set_attribute  0 BG 9 MBSET_READ_BG 6
          swadm set_attribute 0 BG 9 MBSET_WRITE_BG 6

Note that step 8 will have to be repeated for each additional BG process added.

9). Start the iProcess Engine.

Best Practice for TIBCO iProcess Engine case purging using the swutil or swbatch utility.

TIBCO iProcess Engine (Oracle) Administrator's Guide  > Chapter 3 Mbox Sets and Message Queues > Oracle AQ Queue Tables and Queues
TIBCO iProcess Engine (SQL) Administrator's Guide > Chapter 3 Mbox Sets and Message Queues > Creating Additional SQL Database Queue Tables
TIBCO iProcess Engine (DB2) Administrator's Guide > Chapter 3 Mbox Sets and Message Queues > Creating Additional DB2 Database Queue Tables