PanAudit PlusEasytrieve Report GeneratorPAN/SQLEasytrieve Report Generator for Common Services
Issue/Introduction
This is a summary of the possibilities, how a CA Easytrieve application obtains the Db2 for z/OS subsystem ID (SSID) at compile time or runtime.
Environment
Release : 11.6
Component : CA-Pan/SQL (DB2 Interface)
Resolution
The Db2 SSID is obtained either from:
- the Easytrieve options table (SSID option) - the SSID option at the PARM statement in the Easytrieve source - or the PAN$SQL DD when compiling and running an Easytrieve application.
If no SSID is specified at all, the DB2 for z/OS subsystem ID is obtained from the DB2 for z/OS default module DSNHDECP, found through the DB2 for z/OS SDSNLOAD or SDSNEXIT library. The library can be specified at the JOBLIB or STEPLIB DD, or via LINKLIST, for example.
Please be aware that the default DSNHDECP module usually contains the SSID DSN1, which is no valid SSID in most cases and results in errors like:
EZTC0441E >>> $ DB2 subsystem "DSN1" does not exist or A046 SQL - DB2 SUBSYSTEM "DSN1" DOES NOT EXIST