Tables for a chunk
Enrico asked how to find the tables in a chunk using SMI tables. Phillip suggested oncheck -pe. Norman Erickson Lugtu gave a sysmaster query joining sysextents with syschunks on hex values. Enrico confirmed it worked after changing the join condition to use hexnum[1,5] instead of [3,5]. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello, I need to find the tables for a chunk. Is it possible with SMI tables? Regards Enrico Sent via Deja.com http://www.deja.com/
you can run an oncheck -pe to find the tables in a chunk. I'm sure you
could do it via SQL hitting the SMI tables but I think this is easier.
eonder@my-deja.com wrote:
> Hello,
>
> I need to find the tables for a chunk. Is it possible with SMI tables?
>
> Regards Enrico
>
> Sent via Deja.com
> http://www.deja.com/
--
Phillip Tien
Database Administrator
Whole Foods Market, Inc.
Most of the time it was probably real bad being stuck down in a dungeon.
But some days, when there was a bad storm outside, you'd look out your
little window and think, "Boy, I'm glad I'm not out in that."
Its possible,try this,
database sysmaster
;
select hex(start) hexnum,dbsname,tabname
from sysextents
into temp tempext
;
select unique fname, dbsname,tabname
from tempext a, syschunks b
where hex(a.hexnum[3,5]) = hex(b.chknum);
Give me feedback.
Erickson
In article <91netc$hu5$1@nnrp1.deja.com>,
eonder@my-deja.com wrote:
> Hello,
>
> I need to find the tables for a chunk. Is it possible with SMI tables?
>
> Regards Enrico
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Thank you, it is all right;
I have apported only a little modication to a condition of a second
query:
From: where hex(a.hexnum[3,5]) = hex(b.chknum)
To: where hex(a.hexnum[1,5]) = hex(b.chknum)
This modication is necessary for a corret link between two hexadecimal
numers (the link was from a text with a hexadecimal).
Regards Enrico
In article <91o4bj$3ur$1@nnrp1.deja.com>,
Norman Erickson Lugtu <elugtu@my-deja.com> wrote:
> Its possible,try this,
>
> database sysmaster
> ;
> select hex(start) hexnum,dbsname,tabname
> from sysextents
> into temp tempext
> ;
> select unique fname, dbsname,tabname
> from tempext a, syschunks b
> where hex(a.hexnum[3,5]) = hex(b.chknum)
where hex(a.hexnum[1,5]) = hex(b.chknum)
> ;
>
> Give me feedback.
>
> Erickson
>
> In article <91netc$hu5$1@nnrp1.deja.com>,
> eonder@my-deja.com wrote:
> > Hello,
> >
> > I need to find the tables for a chunk. Is it possible with SMI
tables?
> >
> > Regards Enrico
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/