Re: Porting Informix Database

Posted in 1994

Joe Matuscak — Fri, 19 Aug 1994 08:50:24 -0400 — source: Informix-list mailing list archive (1991-1998)

In article <32vpdd$19k@emory.mathcs.emory.edu>, colin@scdipc0.ueci.com (Colin Mcgrath) wrote: > As Oh Wee Tong wrote: > > > I am trying to transfer my database from one server to another using > > dbexport and dbimport. But I discovered that the extent size and the lock > > mode is not preserved. > In the informix archives there is a script written by Jack Parker at HP. It uses awk to massage an sql script to keep entent information and (i think) lock mode. Its called something like pres_ext. Ive used it and it works. Depending on your host, you might need to change the "awk"s to "nawks" and for Ultrix, run it with /bin/sh5. -- Joe Matuscak Rohrer Corporation 717 Seville Road Wadsworth, Ohio 44281 (216)335-1541 Matuscak@Rohrer.com