Update Statistics Problem

Hi, We have a installation in a client that have many databases, these databases have the origin in a Informix SE, v 2.10 ¿?, more than 20 years ago, we have migrated S.O. and Informix several times in this time... From SE we migrate to Online 9.40.UCx with dbexport/dbimport, then to 11.10.UCx and finally to 11.50.FC6. I have noticed that the auto update statistics have a problem, in the online.log apears this line every day: 01:00:11 SCHAPI: [Auto Update Statistics Evaluation 18-nnn] Error -272 No SELECT permission for sysdistrib.smplsize. I check the permissions on these table an efectively the column "smplsize" (and a few more) isn't in the columns with select permission for public in any of the databases except in the sysmaster, I have tried to grant access to public for these columns but could not change the permissions of the system tables. How could I set the permissions so the auto update statistics run well? There is over 18Gb in these databases and I guess that the performance is not optimal, although users have not complained. Thanks in advance, Jero p.d. apologize my bad english

Hi, What output does this give: select * from syscolauth where tabid=(select tabid from systables wheretabname='sysdistrib') and colno=(select colno from syscolumns where colname='smplsize' and tabid=(select tabid from systables where tabname='sysdistrib')); Run it in all your databases in that instance. It should give one line of output in each, e.g.: grantor informix grantee public tabid 24 colno 10 colauth s-- I know there is an 11.50 -> 11.70 conversion bug where syscolauth entries are not added for four sysdistrib columns new in 11.70. I am not sure if a similar bug exists in older conversions. Ben.

Hi, This does not output nothing, I have also reviewed the permissions from the dbaccess and is missing the permissions of 4 columns. In a test instance that has the same problem I observed that I can't "grant select" to this column, return a -511 error, but I have managed to insert the record with a insert instruction into syscolauth from user informix... Could be this a "valid" solution for this problem? Or can I have a colateral effect? Regards, Jero -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de BENJAMIN THOMPSON Enviado el: jueves, 05 de septiembre de 2013 18:34 Para: ids@iiug.org Asunto: Re: Update Statistics Problem [31368] Hi, What output does this give: select * from syscolauth where tabid=(select tabid from systables wheretabname='sysdistrib') and colno=(select colno from syscolumns where colname='smplsize' and tabid=(select tabid from systables where tabname='sysdistrib')); Run it in all your databases in that instance. It should give one line of output in each, e.g.: grantor informix grantee public tabid 24 colno 10 colauth s-- I know there is an 11.50 -> 11.70 conversion bug where syscolauth entries are not added for four sysdistrib columns new in 11.70. I am not sure if a similar bug exists in older conversions. Ben. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, Yes, you will have to insert the rows manually into the sysdistrib table as user 'informix'. There should be an entry giving permissions to 'public' for every column except 'encdat'. Afterwards you will need to do 'update statistics for table sysdistrib'. If you're not sure what you need, initialise a new 11.50 instance somewhere else and look at what is in the 'syscolauth' table. Ben.