
Signature
Knut Stolze
DB2 Information Integration Development
IBM Germany
>> Hi,
>> I am looking for information how calculate size of table with BLOB
[quoted text clipped - 18 lines]
> 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
Knut Stolze - 21 Feb 2006 10:07 GMT
> 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 .

Signature
Knut Stolze
DB2 Information Integration Development
IBM Germany
Yaro - 21 Feb 2006 12:03 GMT
> 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