Re: dbschema and preserving extents and dbspaces.

> > "Rajesh N. Malhotra" <malhotra@eos.ap.org> wrote: > > >InformiXperts, > > > The dbschema utility does not preserve the dbspace in wich the table > >lives, nor the extent sizes of the table. Some time back somebody had > >posted a utility that preserverd these values. Could someone point me to > >that utility? Does this utility take into account that tables might be > >fragmented? 1 - the utility is called pres_ext and live at the archives. ftp.mathcs.emory.edu 2 - It does not preserve fragmentation info because at that release level the utility is moot. The new dbschema is fully capable of retaining that and other information. > > dbschema -ss -t all -p all > myschema.out Hmmm. You might want to tell it what database to use and you don't have to pipe it out, so I would be more inclined to: dbschema -d dbname -ss -t all -p all myschema.out With current Informix utilities like dbschema you can always do: dbxxxxxx -- to get a full usage statement. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@boi.hp.com Currently on loan to PLD/PE _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________