Mapping a single multi-member source table using LiveAudit for IBM i

You can use a wizard to map a single IBM® i multi-member source table to a single target table using the LiveAudit feature.

Procedure

  1. Ensure that a CDC Replication Engine for Db2® for i is installed on both source and target.
  2. Click Configuration > Subscriptions.
  3. Select a subscription, right-click and select Map Tables.
  4. Select Custom Table Mapping > LiveAudit and click Next.
  5. Review the following audit columns. You can choose to add, modify, or delete audit columns to the target table. Click Next:
    AudTime
    Stores the &TIMSTAMP journal control field which indicates date and time changes are made to the source.
    AudType
    Stores the &ENTTYP journal control field which indicates the type of change made to the source.
    AudUser
    Stores the &USER journal control field which indicates the ID of the user who made the change to the source.
  6. Expand the database, schema, or table from the Source Tables list to view tables from your database that are available for mapping. Right-click the database user or schema and click Refresh if you do not see your table listed.

    You may be prompted to filter databases, schemas, or tables if Automatically prompt for filter when expanding nodes is enabled in your preferences. For more information see, Setting advanced preferences. To manually define a filter, select a datastore, database, or schema and click Specify Filter.

  7. Enable the table to map from the Source Table list. If you do not see your table listed, right-click the database user or schema and select Refresh.
  8. If you want to hide columns so that the target is not aware of them, select a source table and click Filter Columns. Clear the check box for the column you want to hide and click OK.
  9. Click Next.
  10. Expand the database, schema, or table from the Target Tables list to view tables from your database that are available for mapping. Right-click the database user or schema and click Refresh if you do not see your table listed.
  11. Select a target table to map from the Target Table list and choose one of the following options.
    • Source and Target Files are Single Member—Merges all members from the source table to a single-member target table.
    • Use Source member Structure on Target—Maintains the same multi-member structure on the target table as the one on the source table. Each source member is mapped to the corresponding target member.
    • Merge Source Members into One Target Member—Merges all members from the source table to a single member in a multi-member target table.
  12. Review the mapping settings.
  13. Choose one of the following options and click Finish:
    Define column mappings
    Continues with the column mapping.
    Create a new table mapping
    Allows you to start a new table mapping.
    Return to current view
    Returns you to the current view.