Re: SMI pseudo tables

Tony_Reynolds(Accounting & Purchasing) wrote: > > 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........... The sysmaster database is a read-only database. It is basically a view of shared-memory structures. So it is a good thing that UPDATE or DELETE, etc are disabled. Each user database has a set of system tables also. These all begin with 'sys..'. Some people update systables and set the owner field. I believe this is not recommended. You should actually drop and re-create each table with the correct owner. Hope this helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+