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"
======================================================================
Read more...
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.