Creating Metadata for VSAM Logs

How to:

In addition to the synonym that describes the VSAM cluster itself, a synonym is required for the log. For complete information about the creation of a synonym for VSAM data sets, refer to the chapter Using the Adapter for VSAM in the Adapter Administration for UNIX, Windows, OpenVMS, IBM I, and z/OS manual.


Top of page

x
Procedure: How to Create Synonyms for VSAM Logs

To create a synonym for a log table in the DMC:

  1. Right-click an application directory in the navigation pane and click New, then click Synonym. The Select Adapter window opens.
  2. Click VSAM and click OK. The Select Metadata and Data File for VSAM window opens, as shown in the following image.

    Select metadata for VSAM Synonym window

  3. Enter or select the name of the COBOL FD (File Description) for the VSAM cluster.
  4. Enter the fully qualified VSAM Cluster Name for a data set that is associated with the CDC subsystem as qualified.dataset.name.
  5. Click Next.

    The Create Synonym for VSAM window opens, as shown in the following image.

    Create Synonym for VSAM window

  6. Check the CDC enable check box.
  7. Change the synonym name for the log to distinguish it from the synonym used for the VSAM cluster itself. For example, add _log to the end of the name.
  8. Optionally, select a different Application directory. Then click Create Synonym. The Create Synonym for VSAM status window opens.
  9. Click Open First Synonym. The synonym opens by default with the Field view. If it does not, click the tab to switch to that view. The segment name SEG1 should be selected. If SEG1 is not selected, select it. The window should look similar to the following image.

    Synonym window

    Note the first three columns that are used for DataMigrator IUD processing are added automatically:

    • CDC_OPER - Operation type (Update or Delete)
    • CDC_TID - Transaction ID
    • CDC_TIMES - Time stamp
  10. Optionally, you can enter CDC configuration settings. These settings are described inChange Data Capture (CDC) Configuration.

iWay Software