ADB 7.1 Oracle Stream Mode issues

Products	Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database	7.1.0

Description

Customer may have below queries :

1. working of stream mode : need a explanation as to which Queue tables to look upto.
By default 9 Tables get created .

2. verification steps: so as to ensure the publication service has picked up the message. I have enabled verbose and set debug as 4 but i couldn't see adapter polling for the messages.

3. Performance of Stream in comparison with Trigger (Default Mode). Does TIBCO have any benchmarking document for the same.

4.Why the stream feature was removed in the new version 7.2 ? (I have a idea that oracle bought GoldenGate and are deprecating the stream in new versions )

5.The requirements or prerequisites of using stream. Kindly provide details for the same.

Issue/Introduction

Provided answers to some ADB 7.1 Oracle stream base queries

Resolution

1. working of stream mode : need a explanation as to which Queue tables to look upto.
By default 9 Tables get created.

-> The table corresponding to the "Stream output queue", often is the queue name appended with "_T".

2. verification steps: so as to ensure the publication service has picked up the message. I have enabled verbose and set debug as 4 but I couldn't see adapter polling for the messages.

-> As the data is published directly out from Oracle AQ queue, no more polling. The way to verify the service is to monitor the Oracle queue specified by "Stream Output Queue" for the publication service.

There are many normal ADB features not supported by stream mode:
1. Polling method
2. Polling Interval
3. Use Polling Batch Size
4. Publisher-Batch Confirm Size
5. Publisher-Batch Confirm Timeout
6. Publish by Reference
7. Enable Loop Detection
8. Do Not Generate Triggers
9. Enable Group Messaging
10.Publish child Data
11.Child Table Order By
12.Alert
13.Order by Function
14. Reconnection

Also, Oracle streams has certain restriction, please see http://docs.oracle.com/cd/B28359_01/server.111/b28321/ap_restrictions.htm#STRMS182

3. The performance of Stream in comparison with Trigger (Default Mode). Does TIBCO have any benchmarking document for the same?
-> No formal performance comparison has been carried out.

4.Why the stream feature was removed in the new version 7.2 ? (I have a idea that oracle bought GoldenGate and are deprecating the stream in new versions )
->The main reason for dropping is due to that Oracle Streams is deprecated in Oracle Database 12c and may be unsupported and unavailable in a later Oracle Database release. See, https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60159.

For working of stream mode please read details from adapter document
TIBCO ActiveMatrix Adapter for Database -> Configuration and Deployment -> Publication Service Tabs.

5. The requirements or prerequisites of using stream. Any suggestions on the DB side. Kindly provide details for the same.
-> The desinger user needs DBA privileges and execution privilege on package DBMS_STREAMS_ADM and DBMS_AQ, also the Oracle AQ is enabled. Native Oracle JDBC driver is required in design and runtime. To use Asynchronous Capture Process, database has to be running in log archive mode. For runtime user, it needs to have privilege to access the output queue and source table.

Please note that,

As per the engineering team,both TIBCO and Oracle don’t recommend to use steams. Going forward Oracle itself won’t support stream and so we have also remove stream support from the latest release of ADB Adapter.
We also make customer who are in production to migrate from stream to trigger.

For more details

Please find attached "Functional Spec for Oracle Streams.docx" and "HowToUseStreams.docx".

Attachments

ADB 7.1 Oracle Stream Mode issues get_app

Welcome to "KB Articles"