Re: Cannot read system catalog (systables)

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 > >