With CA Database Management Solutions for DB2 for z/OS, how to correct a SQL-Ease -551 error?

Document ID : KB000127213
Last Modified Date : 01/03/2019
Show Technical Document Details
Introduction:
This document states how a -551 SQL-Ease error can be corrected.
Question:
How to correct a SQL-Ease -551 error?
Environment:
z/OS 1.13 and up.
Answer:
When receiving the -551 SQL Code on the "AUDIT Message File" after attempting to query or explain an SQL statement via the "SQL Ease Main menu", EXEC option (5), this error can be corrected by GRANTing SELECT authority on the DB2 Table that the SQL Ease User is working with.

When receiving the -551 SQL Code on the "AUDIT Message File" after attempting to create an explain Table, via the "SQL Ease Main menu", "Create Explain Table(s)" option (10), this error usually occurs when the SQL Ease User doesn't have update authority to the "Database" entry on the "SQL-EASE Explain Table(s) Creation" display. The default value for this database is DSNDB04. This error can be corrected by either:
  1. Granting the SQL Ease User authority to create tables in database DSNDB04.
  2. Or, changing the DFLT_DB entry in the <highlvl>.CDBAPARM PPA member from DSNDB04 to a database that the SQL Ease User has authority to update.