SQL-Ease : How to correct a SQL-Ease -551 error after attempting to create an explain Table
search cancel

SQL-Ease : How to correct a SQL-Ease -551 error after attempting to create an explain Table

book

Article ID: 127213

calendar_today

Updated On: 03-21-2023

Products

SQL-Ease for DB2 for z/OS

Issue/Introduction

How a -551 SQL-Ease error can be corrected after attempting to create an explain Table.


Environment

Release : R20

DB2 : DB2 for Z/OS

Resolution

A -551 SQL Code is seen 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.

A -551 SQL Code is seen 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 appropriate 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.

Additional Information

Review the Security Authorization Requirements

Db2 Security
SQL-Ease follows the same security as Db2, as summarized in the following sections. For more information about Db2 security, see the IBM Db2 Administrative documentation.
The following rules apply, except where noted:
When the SQL statement is embedded in a program, the privilege set consists of the privileges that the owner of the plan or package designates.
When the statement is executed dynamically, the privilege set is the union of the privileges that are designated by each authorization ID of the process. (That is, the primary and secondary IDs.)

Create Explain Table Security
You can create an explain table when you have at least one of the following authorizations or privileges:
SYSADM authority
DBADM, DBMAINT, or DBCTRL authority on the database containing the explain table
CREATETAB privilege on the database containing the explain table