FW: Refreshing data on a test database
I use tbload/tbunload to move my production to test. It is pretty quick =
and can write to disk as well as tape (just create the file on disk =
before tbunload and then use it in the -t parameter)
----------
From: Cosmo Lee[SMTP:"*N O - S P A M*cosmo"@echonyc.com]
Sent: Monday, September 08, 1997 2:32 AM
To: informix-list@rmy.emory.edu
Subject: Re: Refreshing data on a test database
All your chunk sizes must be identical in order to do a restore. And
the new instance must have the same named (identical paths) pointers
pointing to the same size (although not necessarily identically named)
chunks.
Cosmo
Nigel Gall wrote:
} At 08:01 PM 8/28/97 EDT, you wrote:
} >
} >Neil, Truby wrote:
} >>
} >> Our users have a requirement for a test database, with the data
} regularly
} >> refreshed from production. We achieve this by dbexporting the
} production
} >> database, dropping the test one then using dbimport to re-create
} it.
} >>
} >
} >If your physical layouts are the same, why not restore a production
} backup
} to the test
} >system. That's how we do it. It's a LOT faster than
} dbexport/dbimport.
} >
}
} Is it possible to do this if the chunk names and numbers are the same
} but
} their sizes are different? Our production chunks are larger than our
} test
} environment, but both environments are sufficient in size to cover the
}
} present amount of production data.
}
} Another way of asking this is, what needs to be identical to both
} environments for a restore of a level-0 archive of my production
} system to
} my test system to work?
}
} Thanks for you help.
}
} Best regards,
} Nigel
} +-------------------------------------------------------------+
} |Name : Edmund Nigel Gall Tel: (868) 636 3153 |
} |Title : Information Systems Specialist Fax: (868) 679 3770 |
} |Company: Process Plant Services Limited |
} |Address: Atlantic Avenue, Point Lisas Industrial Estate |
} | Point Lisas, Couva, Trinidad & Tobago, W.I. |
} +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+
--
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply.
Cosmo Lee Multi-User Computer Systems Brooklyn, NY
"JUST SAY 'NO' TO SPAM"
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *