CA Easytrieve - how to provide the Db2 SSID

Products

• PanAudit Plus
• Easytrieve Report Generator
• PAN/SQL
• Easytrieve 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 "xxxx", which is no valid SSID in most cases and results in errors like:

EZTC0441E >>>      $ DB2 subsystem "xxxx" does not exist
or
A046 SQL - DB2 SUBSYSTEM "xxxx" DOES NOT EXIST