Getting table extents from sysmaster
How can I write queries showing which table has extents in which
dbspace through sysmaster? - a bit like an oncheck -pe except I want
to condense the output with aggregate functions.
I can see a table called systabextents but I can't fathom out what I
should join it to.
Thanks
Andy
↪ replying to Andy Kent
On 2 Dec 2003 08:09:09 -0800, andykent.bristol@virgin.net (Andy Kent)
wrote:
>How can I write queries showing which table has extents in which
>dbspace through sysmaster? - a bit like an oncheck -pe except I want
>to condense the output with aggregate functions.
>
>I can see a table called systabextents but I can't fathom out what I
>should join it to.
>
>Thanks
>
>Andy
Try systabnames
where systabnames.partnum = systabextents.te_partnum
Related threads
- the longer you surf, the MORE $$$ you earn !!
- Store procedure
- emulation for Vt100
- extent size questions again ...