ERROR 'SQL0805N Package "DSNTEST.NULLID.SYSSH200.5359534C564C3031" was not found' (4269339)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

ERROR 'SQL0805N Package "DSNTEST.NULLID.SYSSH200.5359534C564C3031" was not found'
Description

When trying to connect to a z/OS DB2 database, the following error is received: 'ERROR 'SQL0805N Package "DSNTEST.NULLID.SYSSH200.5359534C564C3031" was not found'
Cause

The DB2 command line processor is not bound to the database.
Resolution

WORKAROUND:
Do the following steps:
1. Go to the Toad Command Window. IBM DB2 | <<DB2_CLIENT>>| Command Line Tools | Command Window.
2. cd ../bnd (go to the bnd directory).
3. DB2 CONNECT TO SSID USER username USING password.
4. DB2 BIND @DDCSMVS.LST BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC
There may be some warnings. You can ignore the warnings.
5. DB2 CONNECT RESET
6. exit the Toad Command Window.
Additional Information

The bound to the database is usually performed by a Database Administrator (must have SYSADM authority or privileges to perform the Bind).

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title