This is a discussion on chunks and raw filesystems within the Informix forums, part of the Database Server Software category; --> I've been adding chunks to Informix using the incorrect size to fully use a disk partition. I am going ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I've been adding chunks to Informix using the incorrect size to fully use a disk partition. I am going to start using the correct size now (and correct the old ones at a later date). Now I have 2Gb raw disk partitions. If I want to add an additional chunk to a dbspace do I set the block size as 1024000 to fully use the filesystem? Hope someone can help. |
| |||
| On Wed, 19 Nov 2003 14:55:42 +0000, Geezer From The Freezer <Geezer@Freezer.com> wrote: >I've been adding chunks to Informix using the incorrect size >to fully use a disk partition. I am going to start using the >correct size now (and correct the old ones at a later date). > >Now I have 2Gb raw disk partitions. If I want to add an additional >chunk to a dbspace do I set the block size as 1024000 to fully use >the filesystem? > If I understand you correctly.......8-) In order to use the full 2G rawspace as a chunk for a dbspace, you would use something like . . . onspaces -a (some dbspace_name) -p (path to raw disk partition) -o 0 -s 2048000 This would add a 2G chunk to a dbspace. Remember, onspaces uses K, not pages. HTH JWC |
| |||
| On Wed, 19 Nov 2003 15:42:15 +0000, Geezer From The Freezer <Geezer@Freezer.com> wrote: > > >John Carlson wrote: > >> This would add a 2G chunk to a dbspace. Remember, onspaces uses K, >> not pages. > > >John - what about onmonitor? Ooooooh, good point . . . . I haven't used onmonitor in ages.... According to the onmonitor screen I see in 9.30, it shows KB for offset and size. |
| |||
| John Carlson wrote: > > On Wed, 19 Nov 2003 15:42:15 +0000, Geezer From The Freezer > <Geezer@Freezer.com> wrote: > >John - what about onmonitor? > > Ooooooh, good point . . . . I haven't used onmonitor in ages.... > > According to the onmonitor screen I see in 9.30, it shows KB for > offset and size. hmm mine shows "Pages in chunk" then again I'm on informix 7 |
| |||
| "John Carlson" <john_carlson@whsmithusa.com> wrote in message news:082nrvofm8f0ibnkfi9gkb2ml0584ephga@4ax.com... > On Wed, 19 Nov 2003 14:55:42 +0000, Geezer From The Freezer > <Geezer@Freezer.com> wrote: > > >I've been adding chunks to Informix using the incorrect size > >to fully use a disk partition. > In order to use the full 2G rawspace as a chunk for a dbspace, you > would use something like . . . > onspaces -a (some dbspace_name) -p (path to raw disk > partition) -o 0 -s 2048000 2097150 in fact. |
| ||||
| > In order to use the full 2G rawspace as a chunk for a dbspace, you > would use something like . . . > onspaces -a (some dbspace_name) -p (path to raw disk > partition) -o 0 -s 2048000 > > This would add a 2G chunk to a dbspace. It would add somewhat less than 2GB. The full size is (from memory) 2097150K. If you try too big a number it'll tell you the actual maximum. You'll probably have to deduct 1 - 3k to make the figure it tells you a multiple of page size. Andy |
| Thread Tools | |
| Display Modes | |
|
|