ERROR[9200] and ERROR[1230] during update stats in private schema

[Paul Low]

User creates private schema and table. Update stats on the table returns an error. There is a second error that returns saying the object owner must be the schema owner, but the user is the schema owner.

SQL>connect USERNAME1/PASSWORD1
Connected to Trafodion

SQL>create schema schema801;

--- SQL operation complete.

SQL>set schema schema801;

--- SQL operation complete.

SQL>create table tab8(a int not null primary key,b int)no partition;

--- SQL operation complete.

SQL>update statistics for table tab8 on every column;

*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.SCHEMA801.TAB8 encountered an error (1230) from statement Create SeaBase histograms table.
*** ERROR[1230] Object owner must be the schema owner in private schemas.

SQL>showstats for table tab8 on every column;

*** ERROR[1] The message id: problem_with_server_read
*** ERROR[1] The message id: header_not_long_enough
*** ERROR[1] The message id: problem_with_server_read
*** ERROR[1] The message id: header_not_long_enough

SQL>