Data Connect does not allow OPEN of host VSAM alternate index

0 Likes

Problem:

Cannot access the Alternate Index of a host VSAM file.

Resolution:

   In order to access a host VSAM Alternate Index, one has to do some setup work on the host and on the PC.

On the host:

   - by default the MFA install should have created a PDS with a name

     ending in VCTL  (something like VAN.BMW.MFA.VCTL)

   - create a member in this PDS with a name starting with a '$'

      (anyname, for example, $VSAMALT)

   - in the PDS member enter something like this:

        VSAM=USRGP1.TEST55.SPDPART

        AIX1=USRGRP1.TEST55.PATHNAME

     you can have up to 8 of these (AIX1 -> AIX8), but they must name

     the VSAM pathname, not the actual dataset and the order must

     match the Cobol FD. For your example, you only have one alternate

     index so it doesn't matter.

   - ensure that the JCL starting MFA has a DD named VSAMCTL and

     that it points to the VCTL PDS

        //VSAMCTL  DD DSN=VAN.BMW.MFA.VCTL, DISP=SHR

In the MFE project:

   - setup the VSAM base cluster as you normally do pointing to the

     host dataset

   - make an entry in the MFE Catalog for the Alternate Index by using

     a definition of '$$server\$vsamalt    <- that second part of the name

     MUST match the PDS member name used on the host in the VCTL

     PDS

   - ensure that the JCL used in MFE has a DD for each alternate index

     in this case only need one for SPDPART1

        //SPDPART1  DD DSN=USRGRP1.TEST55.SPDPART.INDEX, DISP=SHR

Old KB# 6682
Comment List
Related
Recommended