calculate size of table with BLOB

Yaro

Hi,

I am looking for information how calculate size of table with BLOB
field.

After RUNSTATS command
select fpages * tablespace pagesize - gives me only 16kB (table contain
about 10M)

I am interesting in 2 cases:
1.
create table t1(.....
blobdata BLOB
) IN myregulartablespace
@

2
create table t2(.....
blobdata BLOB
) IN myregulartablespace
LONG IN mylongtablespace
@

or how calculate size of mylongtablespace with BLOB data

Thanks in advance
Yaro

Feb 20 '06 #1

Knut Stolze

Yaro wrote:

Hi,

I am looking for information how calculate size of table with BLOB
field.

After RUNSTATS command
select fpages * tablespace pagesize - gives me only 16kB (table contain
about 10M)

I am interesting in 2 cases:
1.
create table t1(.....
blobdata BLOB
) IN myregulartablespace
@

2
create table t2(.....
blobdata BLOB
) IN myregulartablespace
LONG IN mylongtablespace
@

or how calculate size of mylongtablespace with BLOB data

LIST TABLESPACE ... SHOW DETAIL

But note that this will give you the information for all tables that place
their long data into that tablespace.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Feb 20 '06 #2

Yaro

>> Hi,

I am looking for information how calculate size of table with BLOB
field.
After RUNSTATS command
select fpages * tablespace pagesize - gives me only 16kB (table contain
about 10M)
I am interesting in 2 cases:
1.
create table t1(.....
blobdata BLOB
) IN myregulartablespace
@
2
create table t2(.....
blobdata BLOB
) IN myregulartablespace
LONG IN mylongtablespace
@
or how calculate size of mylongtablespace with BLOB data

LIST TABLESPACE ... SHOW DETAIL
But note that this will give you the information for all tables that place
their long data into that tablespace.

Thanks Knut,

This give me information I was looking for.
Unfortunatelly I need read this information from .NET application and I
can't execute LIST TABLESPACE as BD2Command because of ERROR [42601]
[IBM][DB2/NT] SQL0104N. I suppose that this command can't be executed as
DB2Command.

Maybe you know another solution ( proc, func, select) which give me
cursor for example?

Yaro

Feb 21 '06 #3

Knut Stolze

Yaro wrote:

This give me information I was looking for.
Unfortunatelly I need read this information from .NET application and I
can't execute LIST TABLESPACE as BD2Command because of ERROR [42601]
[IBM][DB2/NT] SQL0104N. I suppose that this command can't be executed as
DB2Command.

LIST TABLESPACES _is_ a DB2 command and but not a SQL statement. You can
find the commands/statements here: http://tinyurl.com/eqa86 and here:
http://tinyurl.com/ftprw

You can use the snapshot table functions to get the information that you
want: http://tinyurl.com/ffsw6 and http://tinyurl.com/h87o8 .

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Feb 21 '06 #4

Yaro

> LIST TABLESPACES _is_ a DB2 command and but not a SQL statement. You can

find the commands/statements here: http://tinyurl.com/eqa86 and here:
http://tinyurl.com/ftprw
You can use the snapshot table functions to get the information that you
want: http://tinyurl.com/ffsw6 and http://tinyurl.com/h87o8 .

Thanks a lot
Yaro

Feb 21 '06 #5