A046 SQL - DB2 SUBSYSTEM "DSN1" DOES NOT EXIST

book

Article ID: 132306

calendar_today

Updated On:

Products

CA Top Secret CA Top Secret - LDAP

Issue/Introduction

Trying to run the CIARPT01 and getting the error message below.

A046 SQL - DB2 SUBSYSTEM "DSN1" DOES NOT EXIST
A014 PREMATURE TERMINATION DUE TO PREVIOUS ERROR(S)

Environment

Release:
Component: TSSMVS

Resolution

To dynamically pick up the SSID option, please
1) Leave SSID blank in the Options Table (default)
2) Remove SSID from the program
3) Then the JCL must point to a library with the DB2 module called DSNHDECP.

With release Panvalet 6.4, please concatenate the DB2 SDSNEXIT load library ahead of the DB2 SDSNLOAD library so we can get the SSID from the DSNHDECP module in the SDSNEXIT library.

When we don't have the SDSNEXIT library first, we search the SDSNLOAD library, which has a DSNHDECP module, but has the value of DSN at the point we are looking for the SSID.