Re: Online 5.0: using cooked UNIX files and raw disk slices

Suresh writes ... > >We are using Online 5.0 and I-SQL 4.11. We need to add a new dbspace >on a machine that's been running for a while. Instead of backing up the >entire machine, and reformatting the disk to add this dbspace, we are >thinking about using cooked UNIX files to store this dbspace. The data >in this dbspace is not too critical and the performance hit should also >not be a problem. > >Now, given this scenario, does anybody have any words of wisdom?? Are >there any "gotcha's" out there that we should be aware of?? Please reply >by email to sur@hogpa.ho.att.com > > There are a couple of things to remember when adding a new db/dobjspace and using a UNIX file as a chunk: 1. The file must first be created, for example, touch infx_chunk 2. The file must be owned by informix, group informix, and permissions 0660 3. The file system holding the file must have enough room for the size of the requested initial chunk for your dbspace. For example, If you create a dbspace called "unixdbs" and add a 500MB chunk as the initial chunk for the dbspace, Informix will attempt to increase the size of the chunk file to 500MBytes. 4. Your performace will only be as good as your "cooked" UNIX bufferring for file system I/O. Good luck (o o) +--------------oOOO--(_)------------------------+ | Imaging Business Consultants Incorporated | | San Jose, California 95124, USA | | Phone: 408 369-9220 | | Fax: 408 369-9223 | | Internet: mktg@imagepro.com | | URL: http://www.best.com/~rjc | +---------------------------oOOO----------------+ |__|__| || || ooO Ooo