Demonstration of configuring Oracle schemas to propagate message using Oracle advanced queue through IBM Websphere.
1. Configuring MQ Admin user for client OUTBOUND_CLIENT, INBOUND_CLIENT
1.1 Granting Queue propagation privileges to AQ admin user.
1.2 Granting QUEUEING & DEQUEING privileges to the AQ admin user
2. CREATE A NEW AQ QUEUE for OUTBOUND Propagation
Create OUTBOUND_CLIENT QUEUE Table
3. Create a new AQ QUEUE table for INBOUND Propagation
4. Creating Trigger on queue table to monitor propagation details. (OPTIONAL)
Precreate a table iai_logger depending upon your application logic.
5. Create AQ gateway Link (OUTBOUND_CLIENT)
Use the IBM Websphere MQ username,password,port,Channel, queue manager name etc ..that is configured for your case.
6. Create Non oracle Queue & Register (OUTBOUND_CLIENT)
7. Add Subscriber (OUTBOUND_CLIENT)
8. Scheuling the propagation (OUTBOUND_CLIENT)
9. Setup INBOUND_CLIENT for Inbound Queue
10. Create Queue Table (INBOUND_CLIENT)
11. Create Gateway Link for Inbound Queue
12. Create Non oracle queue & Register (INBOUND_CLIENT)
13. Add subscriber (INBOUND_CLIENT)
14. Start Propagation (INBOUND_CLIENT)
15. Testing the propagation
Send a message through queue, that might be XML, LOB.
Following query should show some data and disappears once message gets propagated through IBM Queue.
Check how many messages been propagated/failure etc
16. Some useful MQ VIEWS