onload question
Posted in 2005
Topics: Storage & Space Management, Migration, Import/Export & Data Conversion
Informix users,
I have a dilemma. Let's say I have a 5 gig database spread over five 1 gig
dbspaces (db1-db5). I run an onunload (ver 7.31.UD7). I take that onunload
file and bring it to a different server where the dbspace layout is
identical to the original server (5 dbspaces of 1 gig each). I do an onload
and specify a dbspace, but none of my dbspaces are 5 gigs large to
accomodate the onload. How should I get around this without specifying a
different dbspace for each and every table (have lots of tables)?
I can swear an older version of Informix (7.30.uc5) wanted you to have
identical dbspace layouts on the onload portion. In other words, if you had
your db spread over 5 dbspaces at onunload time, you needed 5 dbspaces named
the same upon onload time. This version of Informix tries to put the whole
database in the dbspace you specify at onload time (onload -t <device> -d
<dbspace> database).
Please copy phillip.tien@wholefoods.com in your responses. Thank you.
-Phillip