Troubleshooting
Problem
When binding the database utilities to a DB2 for z/OS database with ddcsmvs.lst, some of the bind files may fail with a SQL0562N error message
Symptom
The following is some sample output showing the error (warning) messages that may result when binding ddcsmvs.lst:
bind @ddcsmvs.lst blocking all sqlerror continue grant public
LINE MESSAGES FOR ddcsmvs.lst
--------------------------------------------------------------------
SQL0061W The binder is in progress.
LINE MESSAGES FOR db2ajgrt.bnd
--------------------------------------------------------------------
SQL0562N The specified database privileges cannot be granted
to PUBLIC. SQLSTATE=01560
LINE MESSAGES FOR db2clist.bnd
--------------------------------------------------------------------
SQL0562N The specified database privileges cannot be granted
to PUBLIC. SQLSTATE=01560
LINE MESSAGES FOR db2clpcs.bnd
--------------------------------------------------------------------
SQL0562N The specified database privileges cannot be granted
to PUBLIC. SQLSTATE=01560
Log InLog in to view more of this document
Was this topic helpful?
Document Information
More support for:
Db2 Connect
Software version:
9.7, 9.5, 9.1
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
462429
Modified date:
30 April 2025
UID
swg21570129