2311249 - SQL0551N - DBIF_DSQL2_SQL_ERROR executing program DB6CONV

Symptom

Using DB6CONV to move a table to a different tablespace, a short dump occurs:

======================================================================

Category Installation Errors
Runtime Errors DBIF_DSQL2_SQL_ERROR
Except. CX_SY_NATIVE_SQL_ERROR

Error "-551" has occurred on the current database connection "DEFAULT".
Database error text: SQL0551N The statement failed because the authorization
ID does not have the required authorization or privilege to perform the
operation. Authorization ID: "SAP<sid>". Operation: "READ". Object:
"SAP<sid>.GLOBAL_COMPRESSION_OPTION". SQLSTATE=42501
Triggering SQL statement: "SELECT SUBSTR ( GLOBAL_COMPRESSION_OPTION, 1, 20 )
FROM SVERS"

======================================================================

Environment

DB2 databases for Linux, Unix and Windows

Keywords

Global compression option, GLOBAL_COMPRESSION_OPTION , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.