A046 SQL - DB2 SUBSYSTEM "DSN1" DOES NOT EXIST
Article ID: 132306
Updated On:
Products
Top Secret
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)
A046 SQL - DB2 SUBSYSTEM "DSN1" DOES NOT EXIST
A014 PREMATURE TERMINATION DUE TO PREVIOUS ERROR(S)
Environment
Release:
Component: TSSMVS
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.
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.
Feedback
Yes
No
Powered by
