Advanced Queues

1.6 Advanced Queues

Queuing feature is used in OFSLL for writing debugs into the XMLTYPE column of LOG_FILES_HEADER table instead of writing into the file system.

Also, in OFSLL, Outbound database calls are routed through application server through AQ JMS bridge. The MDB deployed in Middleware, reads the AQ message remotely which has all information required to make the call to Bureau or RO /DT.

The MDB deployed in Middleware, reads the AQ message ('OFSLL_OUTBOUND_TOPIC') remotely which has information about job set and job set status code, which has been initiated by job scheduler.

To enable alert and debug message queue:

1. Set the system parameter "CMN_DEBUG_METHOD" with syp_value = 4.

SQL> update system_parameters set syp_value = '4' where syp_parameter_cd = 'CMN_DEBUG_METHOD';

To enable MDB EJB queue:

2. Set the system parameter and credit bureau parameter in "OUTBOUND_CALL_Q" with syp_value = Y.

UPDATE SYSTEM_PARAMETERS SET SYP_VALUE='Y' WHERE SYP_PARAMETER_CD='OUTBOUND_CALL_Q' AND SYP_ENABLED_IND='Y'
UPDATE CREDIT_BUREAU_PARAMETERS SET CRP_VALUE='Y' WHERE CRP_PARAMETER_CD='OUTBOUND_CALL_Q'

3. Start the queue services using the sql file.

SQL>setup_AQ_subscribe.sql.

4. Once the queue services are started, system subscribes and registers the queue for a notification so that whenever a data inserted into the queue it will notify the system.

To switch back to the existing file system mechanism:

5. To unsubscribe, de-register the queue and stops the queue services for notification, run the below sql file:

SQL>setup_AQ_unsubscribe.sql

6. Set the system parameter "CMN_DEBUG_METHOD"with syp_value= 1.

SQL> update system_parameters set syp_value = '1' where syp_parameter_cd = 'CMN_DEBUG_METHOD';

Note:

Please do not delete any queue or queue table from the schema.
When you unsubscribe the queue, MDB queue is also stopped. You need to start ‘OFSLL_OUTBOUND_Q’ and ‘OFSLL_OUTBOUND_TOPIC’ to continue with MDB flow.
Ensure that you have granted ‘dbms_aqin’ privileges to the schema user.

Parent topic: Setup and Configuration of the Database Server