DBA7908E error upon connection to a new DB2 for z/OS system.
Upon connection to a database using DB2 Control Center from a client machine to a new DB2 for z/OS system error DBA7908E may be returned.
While attempting to connect to a new DB2 for z/OS subsystem database and after creating both DSNUTILS and DSNWZP as required to enable Control Center interface the following errors may be returned:
Some of the functions are not available because a set of stored procedures has not been installed for "Database". The following stored procedures may be missing: ""
[IBM][CLI Driver][DB2] DBRM OR PACKAGE NAME DB.NULLID.SYSSH200.5359534C564C3031 NOT FOUND IN PLAN . REASON
Resolving the problem
The SYSSH200 is a CLI package, the binds need to be run from the client to each subsystem being accessed. Therefore to try and resolve the problem please run the bind list ddcsmvs.lst from the v9.7 client:
1.) db2 connect to <database in question>
2.) cd to the bnd directory
3.) db2 bind <install_path>/firstname.lastname@example.org blocking all sqlerror continue grant public
4.) db2 terminate
Once the above steps are done please try going back into Control Center and attempt to connect to the database in question.
|Information Management||DB2 for Linux- UNIX and Windows||OTHER - Uncategorised||Linux, Windows||9.8, 9.7, 9.5, 9.1||Advanced Enterprise Server, Enterprise Server, Personal, Workgroup Server|
More support for:
Software version: 9.1, 9.5, 9.7
Operating system(s): Linux, Windows
Software edition: Enterprise Server, Personal, Unlimited for System i, Unlimited for System z
Reference #: 1574086
Modified date: 15 December 2016