Using the IMS DBD Metadata wizard

Edit online

Use the New IMS DBD Metadata Wizard to create DBD server metadata.

About this task

This wizard is used to create server metadata containing information extracted from the selected DBD source. This DBD metadata is a prerequisite for creating IMS virtual tables. The name of each DBD map will be determined from the contents of the DBD source.

Procedure

  1. On the New DBD Metadata page, complete the following fields and click Next:
    FieldAction
    Metadata Library From the drop-down list, select the target library where the DBD metadata will be stored (for example, hlq.USER.MAP). The target libraries are specified in the server's started task JCL.
    Schema Name From the list of defined Schemas, select a Schema for the virtual table.
    Description Enter an optional description.
  2. On the Source Download page, completethe following fields and click Next:
    FieldAction
    Available Source Libraries From the list of Available Source Libraries, select the virtual source library that contains the DBD source member.
    Source Library Members Select the DBD that you want to use and click Download to copy the member from the mainframe to your desktop. Use Filter patterns to filter the list.
    Downloaded Source Files Review the list of downloaded members and ensure that the check box for the DBD that you want to use has been selected.
  3. On the Data Layout page, complete the following fields and click Next:
    FieldAction
    Source Expand the source file to verify that it displays the expected database definition (DBD).
    Start Field Accept the default root start field, or if multiple DBD nodes are present in the source tree, you can click on one of the DBD nodes to indicate that you only want to map that one DBD.
    End Field End Field selection is disabled when extracting DBD source.
  4. On the IMS Server configuration page, complete the following fields:
    FieldAction
    • Use IMS/DBCTL (read/write, transactional integrity)
    • Use IMS-Direct (read-only, high performance bulk data access)
    		 Select the IMS protocol to use.

    Choose Use IMS/DBCTL (read/write, transactional integrity) to use IMS API calls.

    Choose the default option Use IMS-Direct (read-only, high performance bulk data access) to enable IMS Direct for the DBD. To use this feature, IMS Direct must also be enabled in the Data Virtualization Manager server IN00 file. You must select this option for the DBD to be able to enable IMS Direct for a virtual table.
    IMS ID Override (used with IMS-Direct only) Specify the IMS ID of the IMS subsystem to use when multiple IMS subsystems are defined for use with IMS Direct. This value will override the default IMS ID in the DBD map.
    Advanced When reading large volumes of data from tables, click Advanced to display and configure the MapReduce feature. The MapReduce feature enables you to divide the data into logical partitions and process those partitions in parallel using the Thread Count value. At runtime, the number of zIIP processors is verified and one thread is used for each zIIP processor; resulting in improved performance. The Thread Count value you specify overrides the default value (2) and the discovered value. To disable MapReduce, select the Disable MapReduce check box.
  5. Click Finish.

What to do next

Return to the New IMS Virtual Table(s) page and define the IMS PSB. See Creating virtual tables for IMS data.