Introduction

In this chapter, the configuration details of the Streams clients will be examined. The three main Streams clients have been introduced in a previous chapter. They are Capture, Propagation and Apply. The next step is to focus on the methodology used to create and manage these Streams processes. Examples will be included in order to show how the data flow, in terms of replication, moves from the producer to the consumer.

In the environment set up section, information will be presented on the methods used to set up the user/schema that acts as the Streams administrator.  This setup includes the assignment of the appropriate privileges and the adjustment of the initialization parameters needed for the Streams process. Initialization parameters configure the necessary queue and job processes for the database instance.

In the section that deals with Streams clients, various methods that can be used to create the Capture and Propagate processes will be introduced. In the next chapter, the information will be expanded to cover the other Streams client known as the Apply process. The Apply process by itself is a distinct and independent process that runs on a destination database instance.

Before getting into the detailed explanation, it will be useful to review the information from earlier chapters about the Streams clients.