Re: Online 4.10 Dbexport/Dbimport

>Paul Mahoney writes: >> I need to move databases about. Unfortunately dbexport does not >> record table extent/next extent sizes or the lock mode when it >> creates the sql necessary to recreate the exported database. >> >> Has anyone got tools which do it right? When I asked Informix they >> said no. > saccente,warren j writes: >We are struggling with the same issues right now. I've been working on >an awk script to changes the DBNAME.sql file such that it will put in the lock >modes and extent sizes and change the file so that it will work with isql >rather than dbimport. I haven't spoken with Informix about this yet - but I >suspect that they would consider the extent size issue as a feature rather >than a flaw - and under most circumstances they are right. dbimport will >figure out an extent size such that all data to be loaded will fit into the >first extent. This is usually good - two cases where it is not good is >(1) if you don't have enough available contiguous dbspace to put the entire >table in one extent and (2) if you want the extent size to be less than 16K >(we create our tables as 8K extents because we have many very small tables - >our databases almost double in size when we export and import them). > As I had mentioned in a previous post, dbimport/dbexport was originally designed to allow migration of an SE database to Turbo/OnLine. As lock modes and extent sizes did not exist in SE, there was no support for culling that information from the system catalogs and incorporating it into the sql script produced by dbexport. Note that if you want to dbimport a database from an OnLine to SE server, if that info *was* included, you would have to edit it *out*. >Does anyone know if either of these situation exist post-4.0 or are >these flaws/features fixed? Our 6.0 servers release is scheduled to include an updated dbexport (dbschema as well) utility that will preserve server-specific information (such as lock modes and extent sizes). Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** The heart and the mind on a parallel course, never the two shall meet. -E. Saliers