Table size in bytes

[Gregor =?UTF-8?B?S292YcSN?=]

Hi!

How can I see the actual size of a table is bytes?
I could to a count on table and multiply by page size, but we are using
VARCHARs and I'm affraid that is not the correct value.
I could also find the file that a table is stored in, but I don't know where
to find this information. Where is this information stored in a database?

Thanks and best regards,
Kovi

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

[stefan.albert]

On Jan 31, 9:03*am, Gregor Kovaè <[e-mail]:

Hi!

How can I see the actual size of a table is bytes?
I could to a count on table and multiply by page size, but we are using
VARCHARs and I'm affraid that is not the correct value.
I could also find the file that a table is stored in, but I don't know where
to find this information. Where is this information stored in a database?

Of course you can try this with the information taken from the
catalog. But the statistics have to be actual...

db2pd -db DB -tcbstats

gives a more reliable output - you can also specify the tablespace
(and table ?).

The size of the file is also a way - but this works for SMS only:
Derive the containers of the tablespace where your table lives.
Then the files have the tableid in their names in these containers.
There can be different types like *.dat (data) *.INX *.IN1 (indexes)
and others.
They give you the current usage on disk for data and indexes and lobs.

db2pd also gives the sizes of indexes...

[Gregor =?UTF-8?B?S292YcSN?=]

stefan.albert wrote:

The size of the file is also a way - but this works for SMS only:
Derive the containers of the tablespace where your table lives.
Then the files have the tableid in their names in these containers.
There can be different types like *.dat Â*(data) *.INX *.IN1 (indexes)
and others.
They give you the current usage on disk for data and indexes and lobs.

Thanks, this is what I was looking for.

Best regards,
Kovi
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

[Gregor =?UTF-8?B?S292YcSN?=]

I found out that you could get the actual size of a table TABLE1 with this
SQL:

SELECT TABSCHEMA, TABNAME, DATA_OBJECT_P_SIZE + INDEX_OBJECT_P_SIZE +
LONG_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE + XML_OBJECT_P_SIZE AS TOTAL_SIZE
FROM SYSIBMADM.ADMINTABINFO WHERE TABNAME = 'TABLE1'

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-