DBEXPORT PROBLEM

I need some help here. * I am trying to dbexport my database. * I am working on Windows NT. * Database has 60 TABLES , and 250 Stored Procedures * Tables have very little data, basicaly no more than 50 records each. * When I run the dbexport -c -o <path> <dbname> under MS-DOS Command window, I can see how the table schemas are being generated (are shown on the screen) and placed in a file (sql script) ,but when it gets to the Stored procedures, Informix HANGS!!! (It does not show any error) * When I try to run it from the IECC, some stupid error appears. * When I run dbschema, also HANGS!!! (It does not show any error) * Then I have to kill the process with task manager. * When I go to see if the file was created, I open it and only tha table shemas and a couple of SPs are in it. * Had used dbexport before and this did not happend. What can I do? What is going on?? Victor Paredes GINT

Thanks!! But where can I get "myschema.ec" Vic. "Stefan Weideneder" <stefan@weideneder.de> wrote in message news:38E3B34A.B6831AE@weideneder.de... > Victor Hugo Paredes Paz wrote: > > > > I need some help here. > > > > * I am trying to dbexport my database. > > * I am working on Windows NT. > > * Database has 60 TABLES , and 250 Stored Procedures > > * Tables have very little data, basicaly no more than 50 records each. > > * When I run the dbexport -c -o <path> <dbname> under MS-DOS Command window, > > I can see how the table schemas are being generated (are shown on the > > screen) and placed in a file (sql script) ,but when it gets to the > > Stored procedures, Informix HANGS!!! (It does not show any error) > > * When I try to run it from the IECC, some stupid error appears. > > * When I run dbschema, also HANGS!!! (It does not show any error) > > * Then I have to kill the process with task manager. > > * When I go to see if the file was created, I open it and only tha table > > shemas and a couple of SPs are in it. > > * Had used dbexport before and this did not happend. > > > > What can I do? What is going on?? > > The fastest work around might be to download Art S. Kagels > "myschema.ec" and compile the ESQL/C file on your NT platform. > Run "myschema" instead of "dbschema". It will be much faster > and might work better ! > > If you want to know what's going on, monitor the dbschema > session using "onstat -g ses ###" ( ### must be replaced > by the session id of the dbschema process ). > > Regards, > > Stefan > > > > Victor Paredes > > GINT

Victor Hugo Paredes Paz wrote: > > I need some help here. > > * I am trying to dbexport my database. > * I am working on Windows NT. > * Database has 60 TABLES , and 250 Stored Procedures > * Tables have very little data, basicaly no more than 50 records each. > * When I run the dbexport -c -o <path> <dbname> under MS-DOS Command window, > I can see how the table schemas are being generated (are shown on the > screen) and placed in a file (sql script) ,but when it gets to the > Stored procedures, Informix HANGS!!! (It does not show any error) > * When I try to run it from the IECC, some stupid error appears. > * When I run dbschema, also HANGS!!! (It does not show any error) > * Then I have to kill the process with task manager. > * When I go to see if the file was created, I open it and only tha table > shemas and a couple of SPs are in it. > * Had used dbexport before and this did not happend. > > What can I do? What is going on?? The fastest work around might be to download Art S. Kagels "myschema.ec" and compile the ESQL/C file on your NT platform. Run "myschema" instead of "dbschema". It will be much faster and might work better ! If you want to know what's going on, monitor the dbschema session using "onstat -g ses ###" ( ### must be replaced by the session id of the dbschema process ). Regards, Stefan > Victor Paredes > GINT

Victor Hugo Paredes Paz wrote: > Thanks!! > But where can I get "myschema.ec" http://www.iiug.org/ The IIUG (Informix Internation User Group) web site. > "Stefan Weideneder" <stefan@weideneder.de> wrote: > > Victor Hugo Paredes Paz wrote: > > > * I am trying to dbexport my database. > > > [...snip dolorous story...] > > > * Had used dbexport before and this did not happend. > > > > > > What can I do? What is going on?? > > > > The fastest work around might be to download Art S. Kagels > > "myschema.ec" and compile the ESQL/C file on your NT platform. > > Run "myschema" instead of "dbschema". It will be much faster > > and might work better ! > > > > If you want to know what's going on, monitor the dbschema > > session using "onstat -g ses ###" ( ### must be replaced > > by the session id of the dbschema process ). -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Victor Hugo Paredes Paz wrote: > Thanks!! > But where can I get "myschema.ec" [SNIP] myschema is in the package utils2_ak available from the IIUG Software Repository: www.iiug.org/software Art S. Kagel