myschema utility

Art, got a coredump trying to dump the schema for an entire db (580 tables?). Something that's fixed in your 10/2006 version? I tried it with dbschema and it did get all the tables, but it doesn't do extent sizing like yours! I'm trying to copy a db (move schema and data) from 7.31(server A) to 10.00.UC6 (server B). hp1.ifx> myschema -V myschema: Features Version 6.29, Source Revision: 2.142 ! Copyright 1992-2004 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploitation rights are reserved. hp1.ifx> onstat -V Informix Dynamic Server Version 7.31.FC2 Software Serial Number AAC#J999999 hp1.ifx> hp1.ifx> uname -a HP-UX hp1 B.11.00 U 9000/899 9999999999 unlimited-user license hp1.ifx> hp1.ifx> esql -V INFORMIX-ESQL Version 9.21.HC1 Software Serial Number AAC#A999999 hp1.ifx> ******** hp1.ifx> hp1.ifx> myschema -d maintprod -k -m -n 20 mntprod_tbl.sql mntprod_idx.sql Writing schema primary DDL to: mntprod_tbl.sql Writing schema secondary DDL to: mntprod_idx.sql Memory fault(coredump) hp1.ifx> Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com

SOunds familiar. Try the latest release. If that doesn't work let me know, I have a later release ready to upload, but there aren't any bug fixes in there that I know about. Art ----- Original Message ----- From: Robert Roussey <ids@iiug.org> At: 3/14 16:21:14 Art, got a coredump trying to dump the schema for an entire db (580 tables?). Something that's fixed in your 10/2006 version? I tried it with dbschema and it did get all the tables, but it doesn't do extent sizing like yours! I'm trying to copy a db (move schema and data) from 7.31(server A) to 10.00.UC6 (server B). hp1.ifx> myschema -V myschema: Features Version 6.29, Source Revision: 2.142 ! Copyright 1992-2004 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploitation rights are reserved. hp1.ifx> onstat -V Informix Dynamic Server Version 7.31.FC2 Software Serial Number AAC#J999999 hp1.ifx> hp1.ifx> uname -a HP-UX hp1 B.11.00 U 9000/899 9999999999 unlimited-user license hp1.ifx> hp1.ifx> esql -V INFORMIX-ESQL Version 9.21.HC1 Software Serial Number AAC#A999999 hp1.ifx> ******** hp1.ifx> hp1.ifx> myschema -d maintprod -k -m -n 20 mntprod_tbl.sql mntprod_idx.sql Writing schema primary DDL to: mntprod_tbl.sql Writing schema secondary DDL to: mntprod_idx.sql Memory fault(coredump) hp1.ifx> Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

I cheated. I took the version I have to the new server, recompiled it, and ran it remotely against the old server with a tcp connection. Worked like a charm! I will pull down the new version as soon as I can. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN Sent: Wednesday, March 14, 2007 4:26 PM To: ids@iiug.org Subject: Re: myschema utility [8670] SOunds familiar. Try the latest release. If that doesn't work let me know, I have a later release ready to upload, but there aren't any bug fixes in there that I know about. Art ----- Original Message ----- From: Robert Roussey <ids@iiug.org> At: 3/14 16:21:14 Art, got a coredump trying to dump the schema for an entire db (580 tables?). Something that's fixed in your 10/2006 version? I tried it with dbschema and it did get all the tables, but it doesn't do extent sizing like yours! I'm trying to copy a db (move schema and data) from 7.31(server A) to 10.00.UC6 (server B). hp1.ifx> myschema -V myschema: Features Version 6.29, Source Revision: 2.142 ! Copyright 1992-2004 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploitation rights are reserved. hp1.ifx> onstat -V Informix Dynamic Server Version 7.31.FC2 Software Serial Number AAC#J999999 hp1.ifx> hp1.ifx> uname -a HP-UX hp1 B.11.00 U 9000/899 9999999999 unlimited-user license hp1.ifx> hp1.ifx> esql -V INFORMIX-ESQL Version 9.21.HC1 Software Serial Number AAC#A999999 hp1.ifx> ******** hp1.ifx> hp1.ifx> myschema -d maintprod -k -m -n 20 mntprod_tbl.sql mntprod_idx.sql Writing schema primary DDL to: mntprod_tbl.sql Writing schema secondary DDL to: mntprod_idx.sql Memory fault(coredump) hp1.ifx> Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.