Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / February 2006

Tip: Looking for answers? Try searching our database.

calculate size of table with BLOB

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Yaro - 20 Feb 2006 12:58 GMT
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
Knut Stolze - 20 Feb 2006 17:18 GMT
> Hi,
>
[quoted text clipped - 20 lines]
>
>     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.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Yaro - 21 Feb 2006 08:18 GMT
>> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.