search cancel

CA Easytrieve - how to provide the Db2 SSID

book

Article ID: 189843

calendar_today

Updated On:

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 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