SMI pseudo tables
I have various large databases with many tables that have been loaded
by various users. I need to make the owner of these tables
consistent so that I can create applications using COGNOS. The sql
in COGNOS queries uses the owner of the table as well as the table
name. So I tried the following sql in the sysmaster database..
update systabnames
set owner =""
where dbsname ="ltdnl"
with the result:
$ finderr 346-346 Could not update a row in the table.
While processing an UPDATE, the database server received
an unexpected error. Check the accompanying ISAM error
code for more detailed information on the cause. Possible
causes include hardware errors and locking conflicts.
$ finderr 158-158 ISAM error: Operation disallowed on SMI pseudo table
You have attempted an SQL operation that is not supported
on SMI pseudo tables. Try another.
Has anyone else had experience of this, I dont really want to
unload and re-load tables with lots of extents just top change the
owner...........
Tony Reynolds, NEC Group, Birmingham , UK 8-))