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

book

Article ID: 127213

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

This document states how a -551 SQL-Ease error can be corrected.

How to correct a SQL-Ease -551 error?

Environment

z/OS 1.13 and up.

Resolution

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.