By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,883 Members | 955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,883 IT Pros & Developers. It's quick & easy.

calculate size of table with BLOB

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
>> 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

P: n/a
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

P: n/a
> 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

This discussion thread is closed

Replies have been disabled for this discussion.