470,835 Members | 1,838 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,835 developers. It's quick & easy.

calculate size of table with BLOB

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
4 9540
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
>> 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
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
> 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.

Similar topics

2 posts views Thread by Stanley Sinclair | last post: by
2 posts views Thread by Kums | last post: by
2 posts views Thread by Sue | last post: by
7 posts views Thread by johnm | last post: by
2 posts views Thread by deepgun74 | last post: by
2 posts views Thread by pike | last post: by
4 posts views Thread by carlbernardi | last post: by
6 posts views Thread by shawno | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.