Re: blobs used space in a database
A user on IDS 9.40 (AIX) asked how to find out how much space blobs occupy in a database. Art Kagel answered: for blobspace blobs, run 'onstat -d update', which reports free/used blobspace; for tablespace blobs, use SQL such as 'select sum(length(blobcol)) from mytable', noting that length() gives actual data size, so you should round each value up to the page size (2K or 4K, platform dependent) before summing. The rest of the thread is off-topic traffic from someone trying to unsubscribe from the IIUG list.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
If they are blobspace blobs the onstat -d update will tell you how much
blobspace is unused. If they are tablespace blobs you'll have to:
select sum(length(blobcol)) from mytable;
But that's actual size so you may want to adjust the value that length()
returns to the next pagesize (2K or 4K depending on platform) before
summing it.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Wed, Jul 16, 2014 at 11:51 AM, GILLES TCHAPPI <giltfr@yahoo.fr> wrote:
> Hi to all,
>
> Can someone tell me if there is a way to know space occupied by
> blobs in a database
>
> I'm running a dataserver version 9.40 on AIX
> Thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113370eaac934904fe5264da
Hello all, Can you remove me from this comunity. Regards! Anil K Soni ID Administration IBM Global Business SO Delivery, Security & Risk Mgm Phone: (303)-924-475-4571 E-Mail: asoni@us.ibm.com
Go to the IIUG website and change your mailing list preferences. You can unsubscribe there. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Anil Soni > Sent: Wednesday, July 16, 2014 12:27 PM > To: ids@iiug.org > Subject: Re: blobs used space in a database [33409] > > Hello all, > > Can you remove me from this comunity. > > Regards! > Anil K Soni > ID Administration > IBM Global Business > SO Delivery, Security & Risk Mgm > Phone: (303)-924-475-4571 > E-Mail: asoni@us.ibm.com > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.
Anil: Just go to the IIUG website, login as a member, and go to the forum/sig pages and you can unsubscribe yourself. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jul 16, 2014 at 1:27 PM, Anil Soni <asoni@us.ibm.com> wrote: > Hello all, > > Can you remove me from this comunity. > > Regards! > Anil K Soni > ID Administration > IBM Global Business > SO Delivery, Security & Risk Mgm > Phone: (303)-924-475-4571 > E-Mail: asoni@us.ibm.com > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c34bd0a5982204fe55d18c
Hello Art, Can you send me the link of IIUG website to unsubscribe. Regards! Anil K Soni ID Administration IBM Global Business SO Delivery, Security & Risk Mgm Phone: (303)-924-475-4571 E-Mail: asoni@us.ibm.com From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 07/16/2014 03:01 PM Subject: Re: blobs used space in a database [33411] Sent by: ids-bounces@iiug.org Anil: Just go to the IIUG website, login as a member, and go to the forum/sig= pages and you can unsubscribe yourself. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinion= s and do not reflect on the IIUG, nor any other organization with which I= am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.= On Wed, Jul 16, 2014 at 1:27 PM, Anil Soni <asoni@us.ibm.com> wrote: > Hello all, > > Can you remove me from this comunity. > > Regards! > Anil K Soni > ID Administration > IBM Global Business > SO Delivery, Security & Risk Mgm > Phone: (303)-924-475-4571 > E-Mail: asoni@us.ibm.com > > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c34bd0a5982204fe55d18c ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
www.iiug.org > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Anil Soni > Sent: Wednesday, July 16, 2014 5:09 PM > To: ids@iiug.org > Subject: Re: blobs used space in a database [33412] > > Hello Art, > > Can you send me the link of IIUG website to unsubscribe. > > Regards! > Anil K Soni > ID Administration > IBM Global Business > SO Delivery, Security & Risk Mgm > Phone: (303)-924-475-4571 > E-Mail: asoni@us.ibm.com > > From: "Art Kagel" <art.kagel@gmail.com> > To: ids@iiug.org > Date: 07/16/2014 03:01 PM > Subject: Re: blobs used space in a database [33411] Sent by: ids- > bounces@iiug.org > > Anil: > > Just go to the IIUG website, login as a member, and go to the > forum/sig= > > pages and you can unsubscribe yourself. > > Art > > Art S. Kagel, Principal Consultant > ASK Database Management > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own > opinion= s and do not reflect on the IIUG, nor any other organization > with which I= am associated either explicitly, implicitly, or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves.= > > On Wed, Jul 16, 2014 at 1:27 PM, Anil Soni <asoni@us.ibm.com> wrote: > > > Hello all, > > > > Can you remove me from this comunity. > > > > Regards! > > Anil K Soni > > ID Administration > > IBM Global Business > > SO Delivery, Security & Risk Mgm > > Phone: (303)-924-475-4571 > > E-Mail: asoni@us.ibm.com > > > > > > > > > *********************************************************************** > = > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c34bd0a5982204fe55d18c > > *********************************************************************** > = > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.
www.iiug.org and click on login. You can use your login name or member # to login and there is a link to recover your member #. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jul 16, 2014 at 6:08 PM, Anil Soni <asoni@us.ibm.com> wrote: > Hello Art, > > Can you send me the link of IIUG website to unsubscribe. > > Regards! > Anil K Soni > ID Administration > IBM Global Business > SO Delivery, Security & Risk Mgm > Phone: (303)-924-475-4571 > E-Mail: asoni@us.ibm.com > > From: "Art Kagel" <art.kagel@gmail.com> > To: ids@iiug.org > Date: 07/16/2014 03:01 PM > Subject: Re: blobs used space in a database [33411] > Sent by: ids-bounces@iiug.org > > Anil: > > Just go to the IIUG website, login as a member, and go to the forum/sig= > > pages and you can unsubscribe yourself. > > Art > > Art S. Kagel, Principal Consultant > ASK Database Management > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinion= > s > and do not reflect on the IIUG, nor any other organization with which I= > am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves.= > > On Wed, Jul 16, 2014 at 1:27 PM, Anil Soni <asoni@us.ibm.com> wrote: > > > Hello all, > > > > Can you remove me from this comunity. > > > > Regards! > > Anil K Soni > > ID Administration > > IBM Global Business > > SO Delivery, Security & Risk Mgm > > Phone: (303)-924-475-4571 > > E-Mail: asoni@us.ibm.com > > > > > > > > > ***********************************************************************= > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c34bd0a5982204fe55d18c > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3c964d3751e04fe5793e4
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape