Re: tables and dbspaces

Posted in 1997

Nigel Gall — 11 Dec 1997 15:28:23 -0500 — source: Informix-list mailing list archive (1991-1998)

At 03:45 PM 12/11/97 EDT, you wrote: > >I wonder if there is any problem with creating one dbspace per table? >We have about 130 tables, and this grouping can help us to monitor the >I/O requests per table. >I read the guides and I didn't see any warning about applying such a >solution. > >Thanks, >Ronald Velghe. > Hi! Off the top of my head, I think there's very little wrong with doing this, if space allows. In fact, it is suggested by the Performance Tuning Guide written by Elisabeth Suto as one of the ways DBA's can examine I/O at the table level (using tbstat -D in OnLine 5.x). Go brave, I say! 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 -----+