PowerExchange IMS Data Map Creation

PowerExchange IMS Data Map Creation

Step 2. Add a Data Map

Step 2. Add a Data Map

Enter a short description of the task here (optional).
  1. Start the PowerExchange Navigator.
  2. On the
    Resources
    tab, right-click
    Data Maps
    and select
    Add Data Map
    .
    The following image shows this right-click menu:
    The wizard for creating a data map starts and displays the
    Name
    dialog box:
  3. Enter the following information:
    1. In the
      Schema Name
      field, enter a user-defined name of up to 10 characters in length.
      You can initially use the name of the data map developer as the schema name. After the data map has been created and tested, you can change the schema name to a schema name that you use for other data maps. Often, the schema name represents the PWXPC application.
    2. In the
      Access Method
      list, select
      DL/1 BATCH
      . This setting enables you to use either DL/I or BMP batch access to an IMS database. Both of these access types require that you configure a netport job.
      You can select
      IMS ODBA
      if ODBA is activated for the IMS database. However, subsequent steps in this article assume that you select
      DL/1 BATCH
      .
    3. In the
      Data Map Name
      field, enter a user-defined name for the data map of up to 10 characters in length. This name must begin with a letter.
      Usually, this name matches the NAME parameter value in the DBD statement in the DBD file. For example, the following DBD statement specifies a NAME value of IMSSAMDB:
      DBD NAME=IMSSAMDB,ACCESS=(HIDAM,VSAM)
      Based on this example, you would enter a data map name of IMSSAMDB.
    4. Select
      Import Record Definitions
      to be able to import a DBD and copybooks into the data map.
  4. Click
    Next
    .
    The
    DL/1 Batch Access Method
    dialog box appears:
  5. Enter the following information:
    1. In the
      IMS SSID
      field, enter an IMS subsystem ID, such as IMS9. Maximum length is four characters.
      For DL/1 BATCH access, this value is a logical SSID that matches the SSID that is specified in an IMSID statement in the DBMOVER configuration member and in the registration group. This logical SSID is not used for DL/I access to the IMS database.
    2. In the
      DBD Name
      field, enter a DBD name.
    3. In the
      PCB Number
      field, enter the relative PCB number for the DBD in the PSB. If the PSB specifies COMPAT=YES, add 1 to the PCB number.
      A PCB number is required for DL/I and BMP access to IMS data. The PSB that is specified in the NETPORT statement in the DBMOVER member on z/OS must contain a PCB entry for the DBD.
      You can override the IMS PSB name in the NETPORT statement in one of the following ways:
      • Explicitly declare it as follows:
        PSB=<psb_name>
      • In the netport JCL, specify the following input substation variable to pass a PSB name override at execution time:
        PSB=%PSBNAME
        The PSB name override is specified in the PowerCenter
        IMS PSBNAME Override
        session property for a source or target or in the PowerExchange Navigator
        PSB Name
        advanced parameter for a database row test. The override value replaces the substitution variable for the session or row test. By using the substitution variable with an override, you can use the same JCL and same set of NETPORT and LISTENER statements for multiple PSBs
    4. In the
      Default Codepage
      and
      Skip First
      fields, accept the
      Default
      values.
  6. Click
    Finish
    .
    If you selected the
    Import Record Definitions
    option, the
    Import Copybook - Source Details
    dialog box appears.

0 COMMENTS

We’d like to hear from you!