RE: table extents in what chunks?
Get start in hexadecimal format : hex(start) -> 0xCCCPPPPP. The three first
digits give you the chunk number in the dbspace where the table is (you can
check its name in sysmaster:syschunks).
By using alter fragment you can reorg your table, but you should set next
size to a convenient value in order the table doesnt take small pieces of
disk.
If you dont have enough contiguous free space where to put it, you table
will have many fragments again.
> -----Mensaje original-----
> De: c-eriks@algonet.se [SMTP:c-eriks@algonet.se]
> Enviado el: Mi'rcoles 15 de Noviembre de 2000 03:55 AM
> Para: informix-list@iiug.org
> Asunto: Re: table extents in what chunks?
>
> In article <3A11B74B.3E2AE930@bloomberg.net>,
> kagel@bloomberg.net wrote:
> > c-eriks@algonet.se wrote:
> > SELECT *
> > FROM sysextents
> > WHERE dbsname = "mydatabase" and tabname = "mytable"
> > ORDER BY start;> > Art S. Kagel
> >
>
> How do I find out what chunk the start addresses refers to? What chunk
> will be used for the rebuild (ALTER FRAGMENT .... init mydbspace) of
> the table if the dbspace consists of many chunks?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.