Offset

I have a database that i need to reorganize on 2 very large raw chunks. Presently the database is spread over 9 chunks. What is the concept using offset. How do i know where to start another dbspace. Is there a rule? marie

The rule that you are most likely to fall foul of is that the chunksize + offset must be less than 2GBytes. So, if you have only two chunks, you are limited to a 4GByte database server. Better get that sys admin manual out ....! Neil Truby Londis Stores Hampton Hill, UK Marie Usher wrote in message <7p4m8v$99u$1@news.xmission.com>... > >I have a database that i need to reorganize on 2 very large raw chunks. >Presently the >database is spread over 9 chunks. What is the concept using offset. How >do i know where to start another dbspace. Is there a rule? > >marie >

The 2 Gigabyte rule does not apply to ALL systems. AIX will support 4 Gigabytes as well as others. I would suggest contacting your OS Vendor or INFORMIX Technical Support if you are unsure ... or play it safe with the 2 Gig boundary. All true 64-bit systems should support 4 Gigabyte limits BUT don't at this time. The current limit may be lifted in the 9.2+ versions of the product, though I have not heard if this is true. Regarding offsets, some O/S (such as AIX) require an offset of 4 KB be specified within the INFORMIX Dbspace onspaces command. Check with your system administrator on the size of the logical partitions before creating your dbspaces. When assigning multiple dbspaces within the same logical, remember to use the same pathname for the logical partition for each dbspace created within. The pathname being the same is critical for INFORMIX to assist you in preventing you from creating a dbspace which overlaps that of another dbspace. If you do not have the Administration Manuals, you can view, search and download them from http://www.informix.com/answers. The onspaces command is listed in Volume 2 of both the 7.2 and 7.3 manuals. You can also use onmonitor to create your dbspaces. Last by not least, if you have to use some of the same drives you have now for the new location, use the output of an oncheck -pe to determine the contents of your dbspaces and relocate the data from the latter dbspaces first, thus allowing you to drop those chunks and reassign them to future use. Take care. =============================================== Clifton M. Bean cmbean@msn.com SAP/Informix Database Administrator Informix Certified Database Specialist Informix 4GL-Certified Informix D4GL-Certified Tekmetrics Certified Informix DBA Tekmetrics Certified RDBMS Developer =============================================== Neil Truby <ntruby@netcomuk.co.uk> wrote in message news:7p50nf$87k$1@taliesin.netcom.net.uk... > The rule that you are most likely to fall foul of is that the chunksize + > offset must be less than 2GBytes. So, if you have only two chunks, you are > limited to a 4GByte database server. > > Better get that sys admin manual out ....! > > Neil Truby > Londis Stores > Hampton Hill, UK > > Marie Usher wrote in message <7p4m8v$99u$1@news.xmission.com>... > > > >I have a database that i need to reorganize on 2 very large raw chunks. > >Presently the > >database is spread over 9 chunks. What is the concept using offset. How > >do i know where to start another dbspace. Is there a rule? > > > >marie > > > >