Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
The first 12 bits (3 nibbles or hex digits) represent the chunk number.
If you reorg extents are allocated from the lowest numbered chunk in the
dbspace that has a large enough freespace to accomodate the FIRST EXTENT and
NEXT EXTENT sizes. Prior to reorging with ALTER FRAGMENT...INIT IN... you
should reset the NEXT SIZE with ALTER TABLE tabname NEXT SIZE ....
Art S. Kagel
c-eriks@algonet.se wrote:
>
> 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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.