Informix size & sbspace location for BLOB & BLOBS

Posted in 2009

Mick — Thu, 22 Oct 2009 22:25:07 -0700 (PDT) — source: Usenet: comp.databases.informix

Does anybody know how to get the size and sbspace location of BLOB/ CLOB data using the embedded C functions of ifx_lo_specget_extsz() & ifx_lo_specget_sbspace() ? for an example, who might have a table such as; create table xxx ( first_col integer, sec_col "informix".blob" ); How much disk space is taken up by the BLOB and the sbspace location of the data is the question? Michael

↪ replying to Mick

Nilesh Ozarkar — Fri, 23 Oct 2009 10:13:41 -0500 — source: Usenet: comp.databases.informix

Refer to demo program - $INFORMIXDIR/demo/esqlc/get_lo_info.ec - Nilesh - informix-list-bounces@iiug.org wrote on 10/23/2009 12:25:07 AM: > [image removed] > > Informix size & sbspace location for BLOB & BLOBS > > Mick > > to: > > informix-list > > 10/23/2009 12:30 AM > > Sent by: > > informix-list-bounces@iiug.org > > Does anybody know how to get the size and sbspace location of BLOB/ > CLOB data using the embedded C functions of > ifx_lo_specget_extsz() & ifx_lo_specget_sbspace() ? > > for an example, who might have a table such as; > > create table xxx > ( > first_col integer, > sec_col "informix".blob" > );> > How much disk space is taken up by the BLOB and the sbspace location > of the data is the question? > > > Michael > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Nilesh Ozarkar

Mick — Mon, 26 Oct 2009 16:15:57 -0700 (PDT) — source: Usenet: comp.databases.informix

On Oct 24, 1:13 am, Nilesh Ozarkar <nile...@us.ibm.com> wrote: > Refer to demo program - $INFORMIXDIR/demo/esqlc/get_lo_info.ec > > - Nilesh - > > informix-list-boun...@iiug.org wrote on 10/23/2009 12:25:07 AM: > > > [image removed] > > > Informix size & sbspace location for BLOB & BLOBS > > > Mick > > > to: > > > informix-list > > > 10/23/2009 12:30 AM > > > Sent by: > > > informix-list-boun...@iiug.org > > > Does anybody know how to get the size and sbspace location of BLOB/ > > CLOB data using the embedded C functions of > > ifx_lo_specget_extsz() & ifx_lo_specget_sbspace() ? > > > for an example, who might have a table such as; > > > create table xxx > > ( > > first_col integer,> > sec_col "informix".blob" > > ); > > > How much disk space is taken up by the BLOB and the sbspace location > > of the data is the question? > > > Michael > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list Greate!!! Have compiled the program and have executed it. Just wondering what the size is in (bytes, number of pages ?). Michael Catalog number 6900 Size is 1421, reference count is 1 Time of last access: Mon Oct 26 15:39:06 2009 Time of last change: Mon Oct 26 15:35:38 2009 Time to the second of last modification: Mon Oct 26 15:35:38 2009 Default open flags are: 4640 Estimated size of smart LO is: 1421 Allocation extent size of smart LO is: 0 Create-time flags of smart LO are: 49 Maximum size of smart LO is: No limit Sbspace name is sbs1 here

↪ replying to Mick

Nilesh Ozarkar — Mon, 26 Oct 2009 19:22:12 -0500 — source: Usenet: comp.databases.informix

Size is in bytes (refer - http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.esqlc.doc/sii-xblospec-31261.htm ) - Nilesh - informix-list-bounces@iiug.org wrote on 10/26/2009 06:15:57 PM: > [image removed] > > Re: Informix size & sbspace location for BLOB & BLOBS > > Mick > > to: > > informix-list > > 10/26/2009 06:20 PM > > Sent by: > > informix-list-bounces@iiug.org > > On Oct 24, 1:13 am, Nilesh Ozarkar <nile...@us.ibm.com> wrote: > > Refer to demo program - $INFORMIXDIR/demo/esqlc/get_lo_info.ec > > > > - Nilesh - > > > > informix-list-boun...@iiug.org wrote on 10/23/2009 12:25:07 AM: > > > > > [image removed] > > > > > Informix size & sbspace location for BLOB & BLOBS > > > > > Mick > > > > > to: > > > > > informix-list > > > > > 10/23/2009 12:30 AM > > > > > Sent by: > > > > > informix-list-boun...@iiug.org > > > > > Does anybody know how to get the size and sbspace location of BLOB/ > > > CLOB data using the embedded C functions of > > > ifx_lo_specget_extsz() & ifx_lo_specget_sbspace() ? > > > > > for an example, who might have a table such as; > > > > > create table xxx > > > ( > > > first_col integer,> > > sec_col "informix".blob" > > > ); > > > > > How much disk space is taken up by the BLOB and the sbspace location > > > of the data is the question? > > > > > Michael > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list > > Greate!!! > > Have compiled the program and have executed it. Just wondering what > the size is in (bytes, number of pages ?). > > Michael > > Catalog number 6900 > Size is 1421, reference count is 1 > Time of last access: Mon Oct 26 15:39:06 2009 > Time of last change: Mon Oct 26 15:35:38 2009 > Time to the second of last modification: Mon Oct 26 15:35:38 2009 > > Default open flags are: 4640 > Estimated size of smart LO is: 1421 > Allocation extent size of smart LO is: 0 > Create-time flags of smart LO are: 49 > Maximum size of smart LO is: No limit > Sbspace name is sbs1 > here > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

Glossary

sbspace