Oninit cdi / Archive
Talk to an expert →

Modifying dbexport's schema file

Posted in 2000

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion, Platform-Specific Issues, Versions, Editions & End-of-Life

Red Valsen — — source: Informix-list mailing list archive (1991-1998)

Can I modify the -ss related options which appear in a dbexport schema file (extent sizes, in particular) and then safely dbimport? We're using IDS 7.24 UC8 on Solaris 6/7.

↪ replying to Red Valsen
Rudy Fernandes — — source: Informix-list mailing list archive (1991-1998)

Red Valsen wrote: > Can I modify the -ss related options which appear in a dbexport schema > file (extent sizes, in particular) and then safely dbimport? We're > using IDS 7.24 UC8 on Solaris 6/7. Extent sizes : Yes. Rudy

↪ replying to Red Valsen
Sergey Turin — — source: Informix-list mailing list archive (1991-1998)

Yes, and I prefer this method to make many changes in database structure (extent sizes,locking mode, user privileges ) at once; but table headers (number of rows, unload file name etc) should not be touched. The limiting factors are disk/tape space and database downtime duration. Hope this helps, Sergey Red Valsen <red_valsen@yahoo.com> wrote in message news:396E072A.D43A1C2C@yahoo.com... > Can I modify the -ss related options which appear in a dbexport schema > file (extent sizes, in particular) and then safely dbimport? We're > using IDS 7.24 UC8 on Solaris 6/7. >

Glossary