Error accessing DB2 Z/OS tables OR when creating a Cross Connection Query Builder:
ERRORS:
ERROR [42501] [IBM][DB2] SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "<user or schema>". Operation: "SELECT". Object: "SYSIBM.SYSSCHEMAAUTH".
OR
IBM.Data.DB2.DB2Exception: ERROR [42501] [IBM][DB2] SQL0551N "040861" does not have the required authorization or privilege to perform operation "SELECT" on object "SYSIBM.SYSTABLES". SQLSTATE=42501
Stack trace:
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method)
at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
at IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()"
CAUSE 1:
Toad does not support DB2 Z/OS version 10 connections with conversion mode login.
CAUSE 2:
As a minimum requirement to manage a DB2 for z/OS subsystem in Toad, the user ID defined in the Toad connection profile for the subsystem must either have SYSADM privileges or SELECT privileges on the DB2 catalog tables.
If issue is a result of CAUSE 1...
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.
If issue is a result of CAUSE 2...
Grant the user SELECT privileges to the DB2 catalog tables.
