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.
Peter Link — — source: Usenet: comp.databases.informix
I've inherited an IDS 7.31 UD4 database running on AIX 4.3.3 ML10,
which unfortunately was set up 6 years ago with chunks pointing
directly (no symlinks) to the block devices instead of the
character-special devices. This includes the root chunk.
We are working with our application vendor's DBA to move our
badly-interleaved tables to separate dbspaces that are correctly
defined with symlinks, raw disk, properly-sized extents, etc.
My question is: is there a safe way to get the root chunk re-defined
to point to the character-special device instead of the block device,
and better yet, with a symlink?
A secondary question: is it worth the bother to change it now?
Below are a few lines from onstat -d:
Chunks
address chk/dbs offset size free bpages flags pathname
60052210 1 1 125 62500 48881 PO-
/dev/root_chunk
Peter Link
University of Michigan Health System
Ann Arbor, MI USA
↪ replying to Peter Link
David Williams — — source: Usenet: comp.databases.informix
"Peter Link" <plink1@excite.com> wrote in message
news:4a3f2af6.0305121147.43491c91@posting.google.com...
> I've inherited an IDS 7.31 UD4 database running on AIX 4.3.3 ML10,
> which unfortunately was set up 6 years ago with chunks pointing
> directly (no symlinks) to the block devices instead of the
> character-special devices. This includes the root chunk.
Typical crap DBA's!
>
> We are working with our application vendor's DBA to move our
> badly-interleaved tables to separate dbspaces that are correctly
> defined with symlinks, raw disk, properly-sized extents, etc.
Good!
>
> My question is: is there a safe way to get the root chunk re-defined
> to point to the character-special device instead of the block device,
> and better yet, with a symlink?
>
Nope, recreate the instance from scratch!
> A secondary question: is it worth the bother to change it now?
Yep, I'd love to see what happens if your OS ever rebuilds /dev for some
reason!
>
>
> Below are a few lines from onstat -d:
> Chunks
>
> address chk/dbs offset size free bpages flags pathname
>
> 60052210 1 1 125 62500 48881 PO-
> /dev/root_chunk
>
>
> Peter Link
> University of Michigan Health System
> Ann Arbor, MI USA
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.