Re: Cannot read system catalog (systables)

It' s been a long time since this happened but I wanted to thank you for all the advice. It was very helpful. I use informix logging mode. Thanks again. :) On 22 May 2006 05:49:17 -0700, Superboer <superboer7@t-online.de> wrote: > Hello Genti, > > what logging mode is used??? > > select * from sysmaster:sysdatabases > where name = <yourdb>> > i'll assume it's informix logging and not ansi.. > > if you do in your code: > > begin work; > create view myview as select * from customer;> ..... do a lot of work and timeconsuming work > then you can cause a lock in the system catalog. > > so if you need a view create it and make sure it's committed > > eq > begin work; > create view myview as select * from customer;> commit work; > > begin work; > do a lot of work here.... (better to keep trx small!!) > > > I am very new to Informix, how can I see the log file (we have RedHat ES 3.0) > > on the cmd line: > > onstat -m will display the last x lines; the filename is on top of the > output;> you can just use vi to see it. > > oncheck is a cmd line tool which is used to verify data;repair if > possible corruption; > view disk structs etc. > > > See you > > Superboer. > > > > > > Gentian Hila schreef: > > > For my own good luck it allowed me to remove that view after a few hours. > > > > Why would that happen ? Is anything like COMMIT that I should enter > > after I create a view ? > > > > The SQL that was included on that view would take a couple of hours to > > display all of the resultset. > > > > Maybe something was running inside ? I am afraid now to create other > > views as the same thing might happen ? > > > > I am very new to Informix, how can I see the log file (we have RedHat ES 3.0) > > > > Thanks for all the help. > > > > Genti > > > > On 5/18/06, Davorin Kremenjas <davorin.kremenjas@alfatec.hr> wrote: > > > Try "oncheck -cc" first. > > > > > > "Gentian Hila" <genti.tech@gmail.com> wrote in message > > > news:mailman.71.1147884695.19084.informix-list@iiug.org... > > > We have IDS 9.40. > > > > > > I created a view called SalesReport for a report that we are creating. > > > It worked ok. After a while we found out that the view needed to be > > > modified. > > > Dropped the view and recreated it. > > > > > > Not I cannot query anymore that queue or delete or replace it. > > > > > > When I try to drop it or read from it, I get the following: > > > > > > Cannot read system catalog (systables). > > > > > > If I try to create the view again I get: > > > > > > Cannot update system catalog (systables) > > > > > > But I can read, write, to any table or view, and can create other > > > views just fine. > > > > > > Also the crystal report when connected to the database shows no Tables > > > or Views at all anymore. However, I am able from the same report to > > > see other db that are on the same server. > > > > > > Please help what to do. > > > > > > Thanks a lot. > > > > > > Genti > > > > > > > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-list@iiug.org > > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >