Re: Dumb question again
Susan Elliott (ISG) wrote:
> Could someone please tell me how to find out the actual size of a
> table.. i.e. table fred is 5 gig in size.
> I have looked at oncheck - pT, but it really doesn't make a lot of
> sense..(2 me)
Suze, it sounds like a quite reasonable question to me.
Just to add my $.02 to the mix here, you can edit this query to your own
needs:
select dbsname, owner, tabname, hex(partnum) partition, ti_created,
ti_nextns, ti_nptotal, ti_npused, ti_npdata, ti_nrows,
ti_rowsize, (ti_nrows * ti_rowsize) row_bytes
from sysmaster:systabnames tn, sysmaster:systabinfo ti
where tn.partnum = ti.ti_partnum
order by dbsname, tabname;
This has one advantage over oncheck -pt - it will not lock the table
when other users need to access it. On the down side, because users may
be plugging away at the table, the numbers may not be exactly correct.
But close enough IMO.
--
-- Jake (Pondering the color of an asphyxiated smurf)
+------------------------------------------------------------+
| The expedient performance of a task with excessive concern |
| regarding its duration-to-completion engenders a virtual |
| certainty of diminished benefit therefrom. |
| -- Benjamin Franklin (but he said it in 3 words) |
+------------------------------------------------------------+