2 Configuring the OracleAS CDC Adapter for IMS/DB

Configuring the Data Source Driver Advanced Properties

You configure the advanced properties for a data source in the Advanced tab of the data source editor. The advanced settings are the same for every data source. Advanced settings let you do the following:

• Define the transaction type

• Edit the syntax name

• Provide a table owner

• Determine if a data source is updatable or readable

• Provide repository information

• Set the virtual view policy

Use the following procedure to configure the data source advanced features.

1. Open Oracle Studio.

2. In the Design Perspective Configuration View, expand the Machine folder and then expand the machine where you want to configure the data source.

3. Expand the Data sources folder, right click the data source you are configuring, then select Open.

4. Click the Advanced tab and make the changes. The following table describes the available fields:

Selecting the Imput Files

1. From the Start menu, select, Programs, Oracle, and then select Studio.

2. In the Configuration view, expand the computer defined in "Setting Up the IBM z/OS Platform in Oracle Studio".

3. Expand Bindings. The binding configurations available on this computer are listed.

4. Expand NAV binding.

5. Expand Data sources.

6. Right-click the IMS/DB data source defined in Setting Up the IMS/DB Data Source.

7. Select Show Metadata View, to open the Metadata tab, with the IMS/DB data source displayed under the data sources list.

8. Right-click the IMS/DB data source and select New Import.

   The New Import screen is displayed.

9. Enter a name for the import. The name can contain letters and numbers and the underscore character only.

10. From the Import Type list select IMS-DLI Import Manager. This should be the only choice in the list. The New Import wizard is shown in the following figure:

    Figure 2-8 The Metadata Import dialog box

    
    

11. Click Finish. The Metadata Import wizard opens.

12. Click Add in the Import Wizard to add DBD files. The Add Resource screen is displayed, providing the option of selecting files from the local computer time stamp or copying the files from another computer.

    Figure 2-9 The Select Resources screen

    
    

13. Click Add.

    The Select Resources screen is displayed, which provides the option to select files from the local computer or copy the files from another computer.

14. If the files are on another computer, right-click My FTP Sites and select Add. Optionally, double-click Add FTP site. The Add FTP Site screen is displayed.

15. Set the FTP data connection by entering the server name where the DBD files reside and, if not using anonymous access, enter a valid user name and password to access the computer.

16. To browse and transfer files required to generate the metadata, access the computer using the user name as the high-level qualifier.

    After accessing the computer, you can change the high-level qualifier by right-clicking the computer and selecting Change Root Directory.

17. Select the files to import and click Finish to start the transfer.

18. Repeat the procedure for COBOL copybooks.

    The format of the COBOL copybooks must be the same. For example, you cannot import a COBOL copybook that uses the first six columns with a COBOL copybook that ignores the first six columns. In this type of case, repeat the import process.

    You can import the metadata from one COBOL copybook and later add to this metadata by repeating the import using different COBOL copybooks.

19. Click Add in the Import wizard to add a PSB file, if necessary.

    The selected files are displayed in the Get Input Files screen. The following figure shows the Get Imput Files screen.

    Figure 2-10 Get Imput Files

    
    

20. Click Next to go to the Applying Filters step.

Applying Filters

This section describes the steps required to apply filters on the COBOL Copybook files used to generate the Metadata. It continues the Selecting the Imput Files step.

Perform the following steps to apply filters.

1. Apply filters to the copybooks, as needed.

   The following is theApply Filters editor.

   Figure 2-11 Apply Filters Screen

   
   

   The following COBOL filters are available:

   • COMP_6 switch: The MicroFocus COMP-6 compiler directive. Specify either COMP-6'1' to treat COMP-6 as a COMP data type or COMP-6'2' to treat COMP-6 as a COMP-3 data type.

   • Compiler source: The compiler vendor.

   • Storage mode: The MicroFocus Integer Storage Mode. Specify either NOIBMCOMP for byte storage mode or IBMCOMP for word storage mode.

   • Ignore after column 72: Ignore columns 73 to 80 in the COBOL copybooks.

   • Ignore first 6 columns: Ignore the first six columns in the COBOL copybooks.

   • Prefix nested column: Prefix all nested columns with the previous level heading.

   • Replace hyphens (-) in record and field names with underscores (_): A hyphen, which is an invalid character in Oracle metadata, is replaced with an underscore.

   • Case sensitive: Specifies whether to consider case sensitivity or not.

   • Find: Searches for the specified value.

   • Replace with: Replaces the value specified for in the Find field with the value specified here.

   The following DBD filters are available:

   • Ignore after column 72: Ignore columns 73 to 80 in the COBOL copybooks.

   • Ignore first 6 columns: Ignore the first six columns in the COBOL copybooks.

   • Ignore labels: Ignore labels in the DBD files.

   The following PSB filters are available:

   • Ignore after column 72: Ignore columns 73 to 80 in the COBOL copybooks.

   • Ignore first 6 columns: Ignore the first six columns in the COBOL copybooks.

2. Click Next to go to the Selecting Tables step.

Selecting Tables

This section describes the steps required to select the tables from the COBOL Copybooks.

The following procedure continues the Applying Filters step. Perform these steps to select the tables.

1. From the Select Tables screen, select the tables to access. To select all tables, click Select All. To clear all the selected tables, click Unselect All.

   The Select Tables screen is shown in the following figure:

   Figure 2-12 Select Tables Screen

   
   

   The import manager identifies the names of the segments in the DBD files that are imported as tables.

2. Click Next (the Import Manipulation screen opens) to continue to the Matching DBD to COBOL step.

Matching DBD to COBOL

This step lets you match the DBD file to your COBOL copybook. It is a continuation of the Selecting Tables step. The following figure shows the DBD to COBOL step that is displayed in the Editor.

Figure 2-13 Match DBD to COBOL Screen

1. Match each table selected from the DBD file with the COBOL copybook that contains the relevant table structure. Select the files and tables from the dropdown lists for each DBD entry.

2. Click Next (the Import Manipulation screen opens) to continue to the Import Manipulation step.

Import Manipulation

This section describes the operations available for manipulating the imported records (tables). It continues the Matching DBD to COBOL step.

The import manager identifies the names of the records in the DDM Declaration files that are imported as tables. You can manipulate the general table data in the Import Manipulation Screen.

Perform the following steps to manipulate the table metadata.

1. From the Import Manipulation screen (see Import Manipulation Screen figure), right-click the table record marked with a validation error, and select the relevant operation. For the available operations, see the table, Table Manipulation Options.

2. Repeat step 1 for all table records marked with a validation error. You resolve the issues in the Import Manipulation Screen.

   Once all the validation error issues have been resolved, the Import Manipulation screen is displayed with no error indicators.

3. Click Next to continue to the Metadata Model Selection.

Import Manipulation Screen

The Import Manipulation screen is shown in the following figure:

Figure 2-14 Import Manipulation Screen

The upper area of the screen lists the DDM Declaration files and their validation status. The metadata source and location are also listed.

The Validation tab at the lower area of the screen displays information about what must be resolved to validate the tables and fields generated from the COBOL. The Log tab displays a log of what has been performed (such as renaming a table or specifying a data location).

The following operations are available in the Import Manipulation screen:

• Resolving table names, where tables with the same name are generated from different files during the import.

• Selecting the physical location for the data.

• Selecting table attributes.

• Manipulating the fields generated from the COBOL, as follows:

  • Merging sequential fields into one (for simple fields).

  • Resolving variants by either marking a selector field or specifying that only one case of the variant is relevant.

  • Adding, deleting, hiding, or renaming fields.

  • Changing a data type.

  • Setting the field size and scale.

  • Changing the order of the fields.

  • Setting a field as nullable.

  • Selecting a counter field for array for fields with dimensions (arrays). You can select the array counter field from a list of potential fields.

  • Setting column-wise normalization for fields with dimensions (arrays). You can create new fields instead of the array field where the number of generated fields aredetermined by the array dimension.

  • Creating arrays and setting the array dimension.

The following table lists and describes the available operations when you right-click a table entry:

You can manipulate the data in the table fields in the Field Manipulation Screen. Double-click a line in the Import Manipulation Screen to open the Field Manipulation Screen.

Field Manipulation Screen

The Field Manipulation screen lets you make changes to fields in a selected table. You get to the Field Manipulation screen through the Import Manipulation Screen. The Field Manipulation screen is shown in the following figure.

Figure 2-15 Field Manipulation Screen

You can perform all of the available tasks in this screen through the menu or toolbar. You can also right click anywhere in the screen and select any of the options available in the main menus from a shortcut menu. The following table describes the tasks that are done in this screen. If a toolbar button is available for a task, it is pictured in the table.

Table 2-3 Field Manipulation Screen Commands

Command	Description
General menu
Undo	Click to undo the last change made in the Field Manipulation screen.
Select fixed offset	The offset of a field is usually calculated dynamically by the server at run time according the offset and size of the proceeding column. Select this option to override this calculation and specify a fixed offset at design time. This can happen if there is a part of the buffer to skip. When you select a fixed offset you pin the offset for that column. The indicated value is used at run time for the column instead of a calculated value. Note that the offset of following columns that do not have a fixed offset are calculated from this fixed position.
Test import tables	Select this table to create an SQL statement to test the import table. You can base the statement on the Full table or Selected columns. When you select this option, the following screen opens with an SQL statement based on the table or column entered at the bottom of the screen. Enter the following in this screen: Data file name: Enter the name of the file that contains the data you want to query. Limit query results: Select this to limit the results to a specified number of rows. Enter the amount of rows you want returned in the following field. 100 is the default value. Define Where Clause: Click Add to select a column to use in a Where clause. In the table in the middle of the sreen, you can add the operator, value and other information. Click the columns to make the selections. To remove a Where Clause, select the row with the Where Clause you want t remove and then click Remove. The resulting SQL statement with any Where Clauses that you added are displayed at the bottom of the screen. Click OK to send the query and test the table.
Attribute menu
Change data type	Select Change data type from the Attribute menu to activate the Type column, or click the Type column and select a new data type from the list.
Create array	This command lets you add an array dimension to the field. Select this command to open the Create Array screen. Enter a number in the Array Dimension field and click OK to create the array for the column.
Hide/Reveal field	Select a row from the Field manipulation screen and select Hide field to hide the selected field from that row. If the field is hidden, you can select Reveal field.
Set dimension	Select this to change or set a dimension for a field that has an array. Select Set dimension to open the Set Dimension screen. Edit the entry in the Array Dimension field and click OK to set the dimension for the selected array.
Set field attribute	Select a row to set or edit the attributes for the field in the row. Select Set field attribute to open the Field Attribute screen. Click in the Value column for any of the properties listed and enter a new value or select a value from a list.
Nullable/Not nullable	Select Nullable to activate the Nullable column in the Field Manipulation screen. You can also click in the column. Select the check box to make the field Nullable. Clear the check box to make the field Not Nullable.
Set scale	Select this to activate the Scale column or click in the column and enter the number of places to display after the decimal point in a data type.
Set size	Select this to activate the Size column or click in the column and enter the number of total number of characters for a data type.
Field menu
Add	Select this command or use the button to add a field to the table. If you select a row with a field (not a child of a field), you can add a child to that field. Select Add Field or Add Child to open the following screen: Enter the name of the field or child, and click OK to add the field or child to the table.
Delete field	Select a row and then select Delete Field or click the Delete Field button to delete the field in the selected row.
Move up or down	Select a row and use the arrows to move it up or down in the list.
Rename field	Select Rename field to make the Name field active. Change the name and then click outside of the field.
Sturctures menu
Columnwise Normalization	Select Columnwise Normalization to create new fields instead of the array field where the number of generated fields are determined by the array dimension.
Combining sequential fields	Select Combining sequential fields to combine two or more sequential fields into one simple field. The following dialog box opens: Enter the following information in the Combining sequential fields screen: First field name: Select the first field in the table to include in the combined field End field name: Select the last field to be included in the combined field. Ensure that the fields are sequential. Enter field name: Enter a name for the new combined field.
Flatten group	Select Flatten Group to flatten a field that is an array. This field must be defined as Group for its data type. When you flatten an array field, the entries in the array are spread into a new table, with each entry in its own field. The following screen provides options for flattening. Do the following in this screen: Select Recursive operation to repeat the flattening process on all levels. For example, if there are multiple child fields in this group, you can place the values for each field into the new table when you select this option. Select Use parent name as prefix to use the name of the parent field as a prefix when creating the new fields. For example, if the parent field is called Car Details and you have a child in the array called Color, when a new field is created in the flattening operation it is called Car Details_Color.
Mark selector	Select Mark selector to select the selector field for a variant. This is available only for variant data types. Select the Selector field form the following screen.
Replace variant	Select Replace variant to replace a variant's selector field.
Select counter field	Select Counter Field opens a screen where you select a field that is the counter for an array dimension.

Metadata Model Selection

This section lets you generate virtual and sequential views for imported tables containing arrays. In addition, you can configure the properties of the generated views. It continues the Import Manipulation procedure. This lets you flatten tables that contain arrays.

In the Metadata Model Selection step, you can select configure values that apply to all tables in the import or set specific settings for each table. The following describes how to configurations available in the The Metadata Model Selection editor.

• Select one of the following:

  • Default values for all tables: Select this to configure the same values for all the tables in the import. Make the following selections when using this option:

    • Generate sequential view: Select this to map non-relational files to a single table.

    • Generate virtual views: Select this to have individual tables created for each array in the non-relational file.

    • Include row number column: Select one of the following:

      true: Select true, to include a column that specifies the row number in the virtual or sequential view. This is true for this table only, even if the data source is not configured to include the row number column.

      false: Select false, to not include a column that specifies the row number in the virtual or sequential view for this table even if the data source is configured to include the row number column.

      default: Select default to use the default data source behavior for this parameter.

      For information on how to configure these parameters for the data source, see Configuring the Data Source Driver Advanced Properties.

    • Inherit all parent columns: Select one of the following:

      true: Select true, for virtual views to include all the columns in the parent record. This is true for this table only, even in the data source is not configured to include all of the parent record columns.

      false: Select false, so virtual views do not include the columns in the parent record for this table even if the data source is configured to include all of the parent record columns.

      default: Select default to use the default data source behavior for this parameter.

      For information on how to configure these parameters for the data source, see Configuring the Data Source Driver Advanced Properties.

  • Specific virtual array view settings per table: Select this to set different values for each table in the import. This overrides the data source default for that table. Make the selections in the table under this selection.

When you are finished, click Next to go to the Import the Metadata step.

The Metadata Model Selection editor is shown in the following figure:

Figure 2-16 The Metadata Model Selection editor

Import the Metadata

This section describes the steps required to import the metadata to the target computer. It continues the Metadata Model Selection step.

You can now import the metadata to the computer where the data source is located, or import it later (in case the target computer is not available).

Perform the following steps to transfer the metadata.

1. Select Yes to immediately transfer the metadata from the Windows computer to the z/OS platform, or No to transfer the metadata later.

   The metadata is imported based on the options selected in the previous steps and it is stored on the IBM z/OS platform computer. An XML representation of the metadata is generated. This XML file can be viewed by expanding the Output node.

2. Click Finish.

After performing the import, you can view the metadata in the Metadata tab in Oracle Studio Design perspective. You can also make any fine adjustments to the metadata and maintain it, as necessary.

The Import Metadata screen is shown in the following figure:

Figure 2-17 The Import Metadata screen

After performing the import, you can view the metadata in the Metadata tab in Oracle Studio. You can also make any fine adjustments to the metadata and maintain it, as necessary.

MVS Logstream Creation

A sample job for the creation of the DASD MVS logstream called Oracle.IMS.DCAPDATA is supplied in the <HLQ>.USERLIB(LOGCRIMS) member. For additional information, see the MVS Setting Up a Sysplex IBM manual.

Managing the MVS Logstream

The ATYLOGR program that is provided is used to manage MVS logstreams. It provides the following options:

• Delete all events

• Delete events to a specific time stamp

• Print events between two time stamps

• Print all events from the oldest to a selected time stamp

• Print all events from the newest to a selected time stamp

• Print all events

Creating and Configuring the CDC$PARM Data Set

The CDC$PARM is the DD card name used for configuring the DFSFLGX0 exit. It can be any QSAM data set or member with the LRECL=80 definition. For example, you can build it as a member of the <HLQ>.USERLIB library.

The data set contains parameters, one parameter on a line, according to the follow syntax:

<parameter name>=<parameter value>

The parameters and their valid values are described in CDC$PARM Properties.

Update the IMS Environment

You must do the following to update the IMS Environment:

• Copy the supplied DFSFLGX0 exit module from the supplied <HLQ>. LOADCDIM library to the IMS RES library.

• If necessary, add the CDC$PARM DD card to the IMS Control Region and batch jobs.

• Restart the IMS Control Region.

Adjust the DBD for the Relevant Databases

You must do the following to adjust the DBD for the relevant databases:

• Adjust the DBD for each IMS/DB database that is included in your CDC solution, defining the usage of DFSFLGX0 exit, by adding the following parameter to the DBD macro:

  EXIT= (*, KEY, NOPATH, DATA, LOG, (CASCADE, KEY, NODATA, NOPATH))
  

• Recompile DBD and the corresponding PSB and ACB objects, then restart the IMS Control Region.

CDC$PARM Properties

CDC$PARM is the name of DD card that defines a QSAM data set or PDS member that contains the parameters for a DFSFLGX0 user exit. For an explanation on how to create this and its syntax, see Creating and Configuring the CDC$PARM Data Set. The following list describes the CDC$PARM properties:

• BUFFER_NUM: The logstream buffer number. The valid values are Default-30.

• BUFFER_SIZE: The logstream buffer size. The valid values are Default-22550 bytes.

• DEBUG: If this is ON the debug information is printed using WTO. The default value is OFF.

• LOGSTREAM: The logstream name. The default value is Oracle.IMS.DCAPDATA.

Create a CDC Project

Do the following to create a CDC Project

1. From the Start menu, select, Programs, Oracle, and then select Studio.

2. Open the CDC Solution perspective, click the Perspective button on the perspective toolbar and select CDC Solution from the list.

   The CDC Solution perspective opens with the Getting Started guide in the left pane of the workbench.

3. Click Create new project.

   The Create new project screen opens.

4. In the Project name field, enter a name for your project.

   The types of projects available are listed in the left pane.

5. Select Change Data Capture.

   From the right pane, select IMS-DB.

   Figure 2-18 Create New Project

   
   

6. Click Finish. The Project Overview guide is displayed in the left pane.

7. Click Design. The Design wizard opens. Use this wizard to enter the basic settings for your project.

   Note:

   The wizard screens are divided into sections. Some sections provide information only and other sections let you to enter information about the project. If you do not see any information or fields for entering information, click the triangle next to the section name to expand the section.

   Figure 2-19 Design Wizard (Design Options)

   
   

8. In the Client Type you can select Oracle SOA/ODI only. The Use staging area is selected and cannot be changed, you must use a staging area with the OracleAS CDC Adapter for IMS/DB.

9. Click Next.

   The Design Wizard's second screen is displayed. In this step you configure the computers used in your solution. Enter the following information:

   • Server Machine Details: Information about the computer where Oracle Connect is installed. The selection here is always Server Machine and Mainframe.

   • Staging Area Details: Information about the computer platform where the staging area is located.

     For the server machine Name, select one of the following:

     • CDC Stream Service: Select this if the Staging Area is on a staging area computer. This is the default selection.

     • Server Machine: Select this if the staging area is on the same computer where Oracle Connect is installed.

     • Client Machine: Select this if the Staging area is on the local compuer.

     In the Platform list, select the operating system for the staging area. This can be Windows, Linux or UNIX. The available options are:

     • Microsoft Windows

     • HP-UX

     • IBM AIX

     • Sun Solaris

     • Linux (Red Hat)

     • Suse (Linux)

   Figure 2-20 Design Wizard (Configure Solution)

   
   

10. Click Finish. The wizard closes.

Set up the CDC Server

Click Implement in the Getting Started guide to open the Implementation guide.

In the Implementation guide, do the following to set up the CDC server:

• Set up the Machine

• Copy the Metadata

• Set up the CDC Service

Set up the Machine

You do the following to define the IP Address/host name and Port for the CDC server computer.

1. Click Machine.

   The machine definition screen is displayed:

   Figure 2-21 Machine Definition

   
   

2. In the IP address/host name field, do one of the following:

   • Enter the server machine's numeric IP address.

   • Click the Browse button and select the host machine from the ones presented, then click Finish.

     Figure 2-22 Select Machine

     
     

     Note:

     The machine you enter must be compatible with the platform designated in the screen.

3. Enter the port number.

   The default port number is 2551.

4. To connect with user authentication, enter a user name and password, with confirmation, in the Authentication Information area.

5. Select the Connect via NAT with a fixed IP address check box if you are using Network Access Translation and want to always used a fixed IP address for this machine.

6. Click OK.

Continue setting up the CDC Server on the z/OS computer.

Copy the Metadata

In this step, copy the metadata that you imported when Importing Metadata for the IMS/DB Data Source. Do the following to copy the metadata.

1. Click Metadata.

   The Create metadata definitions view is displayed.

   Note:

   The Select Metadata Source link has an asterisk (*) next to it to indicate that you must perform this operation first.

2. Click the Select Metadata Source link.

3. Select Copy from existing metadata.

4. Click Finish. The screen closes.

5. Click Copy from existing metadata source.

   The Copy Existing Metadata Source screen is displayed showing your local computer and with metadata compatible with the data source selected.

   Figure 2-23

   
   

6. From the sources in the left pane, expand the list until you see the tables from the data source you configured when Importing Metadata for the IMS/DB Data Source.

7. Using the arrow buttons, select the required tables and move them into the right pane.

8. Once you have selected all the desired tables, click Finish.

9. Click Customize Metadata.

   The customize metadata screen is displayed.

   Note:

   If you do not want to make any custimizations to the metadata, click Finish to close this screen. A check mark (✓) appears next to Customize Metadata indicating that this step is complete.

   Continue with another step in the design wizard.

   Figure 2-24 Customize Metadata

   
   

10. To change a table name, right-click in the any field under Customize Metadata, and select Add.

11. Enter the table name in the field presented, and click OK.

    Note:

    You may have validation errors in the tables created, which you can correct by the end of the procedure.

12. To make changes to any field in a table, right-click the table created and select Fields Manipulation.

    The Field Manipulation screen is displayed.

    Figure 2-25 Field Manipulation

    
    

13. Right-click in the upper pane and select Field|Add|Field.

14. Enter the name of the field in the screen provided, and click OK.

15. Default values are entered for the table. To manipulate table information or the fields in the table, right-click the table and choose the option you want. The following options are available:

    • Add table: Add a table.

    • Field manipulation: Access the field manipulation window to customize the field definitions.

    • Rename: Rename a table name. This option is used especially when several tables are generated from the COBOL with the same name.

    • Set data location: Set the physical location of the data file for the table.

    • Set table attributes: Set table attributes.

    • XSL manipulation: You specify an XSL transformation or JDOM document that is used to transform the table definition.

    The Validation tab at the bottom of the window that displays information about what you must do to validate the tables and fields generated from the COBOL. The Log tab displays a log of what has been performed (such as renaming a table or specifying a data location).

16. Correct any remaining validation errors.

17. Click Finish to generate the metadata.

Continue setting up the CDC Server on the z/OS computer.

Set up the CDC Service

In this step you define the starting point or event for the change capture and then indicate the name of the change logger. Do the following to set up the CDC service.

1. In the Solution perspective, click Implement.

2. In the Server Configuration section, click CDC Service. The CDC Service wizard is displayed.

3. In the first screen select one of the following to determine the Change Capture starting point:

   • All changes recorded to the journal

   • On first access to the CDC (immediately when a staging area is used, otherwise, when a client first requests changes

   • Changes recorded in the journal after a specific date and time.

     When you select this option, click Set time, and select the time and date from the dialog box that is displayed.

4. Click Next to define the logger. The following is displayed.

   Figure 2-26 CDC Logger Definition Window

   
   

5. In the Logger Name field, enter the name for the logger, as entered in the IMS system fix 80 file. This is configured when Configuring the DFSFLGX0 Exit. the default name for the logger is ORACLE.IMS.DCAPDATA. If you changed the name when configuring IMS, then enter the new name in this field.

6. Click Next to go to the next step where you set the CDC Service Logging. Select the log level to use from the Logging level list.

   Figure 2-27 Logging Level

   
   

   Select one of the following from the list:

   • None

   • API

   • Debug

   • Info

   • Internal Calls

7. Click Finish.

Continue setting up the CDC Server on the z/OS computer.

Set up the Staging Area Server

Click Implement in the Getting Started guide to open the Implementation guide.

In the Implementation guide, do the following under the Stream Service Configuration section, to set up the staging area server:

• (UNKNOWN STEP NUMBER) Set Up the Staging Area Machine

• Set up the Stream Service

• Configure the Access Service Manager

Set Up the Staging Area Machine

To set up the machine for the staging area, do the following.

1. Under the Stream Service Configuration section, click Machine.

2. Use the same configurations used to Set up the Machine for the CDC server.

Continue setting up the staging area Server.

Set up the Stream Service

In this step you set up the stream service. The Stream Service configures the following:

• Staging area

• Filtering of changed columns

• Auditing

1. Click Stream Service. The Stream Service wizard opens.

   Figure 2-28 Staging Area

   
   

   Note:

   This screen appears only if you selected the inclusion of a staging area in your solution.

2. You can configure the following parameters in this screen:

   • Select Eliminate uncommitted changes to eliminate uncommitted changes from your CDC project.

   • Select the Use secured connection check box to configure the staging area to have a secured connection to the server. This is available only if you logged into the server using user name and password authentication.

   • Set the event expiration time in hours.

   • Under File Locations, click the Browse buttons to select the location of the changed files, and temporary staging files, if necessary.

3. Click Next to select the tables to include in the filtering process.

   Figure 2-29 Select Tables

   
   

4. Click the required tables in the left pane and move them to the right pane using the arrow keys.

   Note: You can remove the tables and add new ones to be captured after you add the tables to the right pane. For more information, see Adding and Removing Tables.

5. Click Next. From the tables selected above, select the columns that receive changes. Select the check box next to the table to use all columns in the table.

   Figure 2-30 Column Selection

   
   

   Note:

   Table headers appear grouped in a separate table at the beginning of the list. You can also request the receipt of changes in the headers' columns.

   Any data changes in the columns selected are recorded.

6. Click Next. The Filter selection screen is displayed. the types of changes you want to receive in the tables and which columns to display.

   Figure 2-31 Filter Selection

   
   

7. You can do the following in this screen:

   Select the actions from which you want to receive change information:

   • • Update

     • Insert

     • Delete

     Note:

     These items are all selected by default.

   • Under the Changed Columns Filter column, select the columns for which you want to receive notification of changes.

     Notes:

     • If you do not select a column, you receive notification of all changes.

     • If you select only one, you receive change information only if the field selected undergoes a change.

     • If you select several, but not all, then you receive change information only if any or all of the selected fields undergo a change

8. In the Content Filter column of the Filter screen, double-click a table column and then click the Browse button to filter content from the selected column.

   The Content Filter screen is displayed.

   Figure 2-32 Content Filter

   
   

9. Select a filter type:

   • Select In for events to be returned where the relevant column value equals the values you specify (if a column is NULL, it is not captured).

   • Select Not In for events to be returned where the column value is not in the values you specify (if the column is NULL, it is captured).

   • Select Between for when the column value is between the two values you specify (if a column is NULL, it is not captured).

10. Click Add in the lower-left corner of the Content Filter screen.

    Note:

    If you select several conditions, you receive the change information if one condition is true.

11. Depending on your selection, do one of the following:

    • If you selected In/Not In, continue with step12.

    • If you selected Between, continue with step 14.

12. Click Add in the Add items to the list screen. Enter a value for events to be returned where the column value appears (or does not appear) in that value. To filter empty values ('') for the Not In filter type, leave this field blank in the dialog box that is displayed.

    Figure 2-33 Add Items (In or Not In)

    
    

13. Repeat steps 12 as many times as necessary, and then proceed to step 16.

14. Click Add in the Add items to list screen.

    The Add between values screen is displayed.

    Figure 2-34 Add Items (Between)

    
    

15. Enter values for events to be returned where the column value is between the two values you specify.

16. In the Content Filter screen, click Next.

    Figure 2-35 Auditing Configuration

    
    

17. Select the required auditing level when receiving changes. Your options are:

    • None: For no changes.

    • Summary: For an audit that includes the total number of recorded delivered, system messages, and error messages.

    • Headers: For an audit that includes the total number of records delivered, system and error messages, and the record headers for each captured record.

    • Detailed: For an audit that includes the total number of records delivered, system and error messages, the record headers for each captured record, and the content of the records.

18. Click Finish.

Continue setting up the staging area Server.

Configure the Access Service Manager

In this step you set up a daemon workspace for the CDC adapter. Do the following to configure the access service manager.

1. Click Access Service Manager.

   The Setup Workspace wizard opens.

   Figure 2-36 Select Scenario

   
   

2. Select the scenario that best meets your site requirements:

   • Application Server using connection pooling

   • Stand-alone applications that connect and disconnect frequently

   • Applications that require long connections, such as reporting programs and bulk extractors

3. Click Next.

   The Application Server with connection pooling scenario screen is used to create a workspace server pool. The parameters available depend on the selection you made in the first screen. The following are the available parameters:

   • If you selected Application Server using connection pooling:

     • What is the average number of expected concurrent connections? Enter the number of expected connections, which cannot be greater than the number of acutal available connections.

     • What is the maximum number of connections you want to open? Enter the number of connections you want opened.

   • If you selected Stand-alone applications that connect and disconnect frequently, in addition to the choices listed in the item above, you can also set the following:

     • What is the minimum number of server instances you want available at any time? Enter the number of instances, which cannot be greater than the number of actual available instances.

     • What is themaximum number of server instances you want available at any time? Enter the number of instances you want to be available.

   • If you selected Stand-alone applications that connect and disconnect frequently:

     • How many connections do you want to run concurrently? Enter the number of concurrent connections to run.

4. Click Next. In the next screen you set time out parameters. These parameters should be changed if the system is slow or overloaded. The parameters are:

   • How long do you want to wait for a new connection to be established? Enter the amount of time you want to wait for a new connection to be established (in seconds).

   • How long do you want to wait for a response that is usually quick? Change this parameter if you have a fast connection. Enter the amount of time to wait for a response (in seconds).

5. Click Next. In the next screen you set security parameters. You should consult with the site security manager before changing these parameters.

   Edit the following parameters in this screen:

   • Enter the operating system account (user name) used to start server instances.

   • Select Allow anonymous users to connect via this workspace, to allow this option.

   • Enter the permissions for the workspace. You can allow All users to access the workspace, or select Selected users only to allow only the users/groups to have exclusive access.

   • Select Do you want to access server instances via specific ports, to allow this option. If this option is cleared, the defaults are used.

     If you select this option, indicate the From port and To port and ensure that you reserve these ports in the TCP/IP system settings.

   Figure 2-37 Site Security

   
   

6. Click Next.

   The summary screen opens.

   Figure 2-38 Workspace Setup Summary

   
   

7. Click Save and then click Finish.

When you complete all the Implementation operations, a check mark (✓) is displayed next to every link. Click Done to return so you can begin Deploying a Change Data Capture.

Continue setting up the staging area Server.

Activating and Deactivating Solution Workspaces

In the Project guide for your OracleAS CDC Adapter solution, click Deploy, then do one of the following to activate or deactivate the workspaces for a solution

• To activate workspaces, under the Control section iclick the Activate Workspaces link.

• To deactivate workspaces, click the Deactivate Workspaces link.

During the activation/deactivation process, you may receive messages indicating that the daemon settings on one or more of the machines involved in your solution have changed. Click Yes to proceed.