What part of the CA Pan/SQL product determines which DB2 subsystem DSN is being used?

Products

• PanAudit Plus
• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

What part of the CA Pan/SQL product determines which DB2 subsystem DSN is being used?

Environment

Release: PSQLOR00200-2.4-Pan/SQL-for Oracle
Component:

Resolution

The CA Pan/SQL products indicates that we are using the module name DSNHDECP as a method of identifying the correct SSID to us.

The DB2 module name to locate is hard coded in the CA Pan/SQL program SMSMDFT2, which is in the CA Pan/SQL load module DQSPSCC.

MVC LOADNAME,=CL8'DSNHDECP' GET DB2 LOAD MODULE THAT 

You can prepare multiple load module libraries containing DQSPSCC, one for each DB2 subsystem.

The name ‘DSNHDECP’ can be altered by the AMASPZAP program in each of the load module libraries to the appropriate target DECP program. 

Your JCL can then be symbolically reference a specific load module library.