RE: Where are my (simple) BLOBS, really?

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML DIR=ltr><HEAD></HEAD><BODY> <DIV id=idOWAReplyText34554 dir=ltr> <DIV dir=ltr><FONT face=Arial color=#000000 size=2>Er, um eratta:</FONT></DIV> <DIV dir=ltr><FONT face=Arial size=2></FONT>&nbsp;</DIV> <DIV dir=ltr><FONT face=Arial size=2>&gt;&gt;<FONT face="Courier New">I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers.</FONT></FONT></DIV> <DIV dir=ltr><FONT face="Courier New" size=2></FONT>&nbsp;</DIV> <DIV dir=ltr><FONT face="Courier New" size=2>I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the&nbsp;BLOBS through the buffers.</FONT></DIV> <DIV dir=ltr><FONT face="Courier New" size=2></FONT>&nbsp;</DIV> <DIV dir=ltr><FONT face="Courier New" size=2>(But you knew what I meant)..</FONT></DIV></DIV> <DIV dir=ltr><BR> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> informix-list-bounces@iiug.org on behalf of Southwell Schuyler<BR><B>Sent:</B> Sun 8/6/2006 8:08 AM<BR><B>To:</B> informix-list@iiug.org<BR><B>Subject:</B> Where are my (simple) BLOBS, really?<BR></FONT><BR></DIV> <DIV dir=ltr> <DIV><FONT face="Courier New" color=#000000 size=2>Environment:&nbsp; HP_UX 11.11&nbsp;&nbsp; IDS 10.00.FC4X2</FONT></DIV> <DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV> <DIV><FONT face="Courier New" size=2>--</FONT></DIV> <DIV><FONT face="Courier New" color=#000000 size=2></FONT>&nbsp;</DIV> <DIV><FONT face="Courier New" color=#000000 size=2>I have a need (HDR) to re-attach my TEXT/BYTE blobs to my tables.</FONT></DIV> <DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV> <DIV><FONT face="Courier New" size=2>I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers.</FONT></DIV> <DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV> <DIV><FONT face="Courier New" size=2>After recreating the tables, a 'dbschema' seems to show the blob column is with/IN the table, as in:</FONT></DIV> <DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>&lt;snip&gt;<FONT face="Courier New" size=2></DIV></FONT></DIV></BODY></HTML>

Did you do a dbschema -d <database> -t <table> -ss I think the ss is important without it you get simple schema without the storage options. It looks like what you did because you didn't get the extent or the locking mode of the table. Southwell Schuyler wrote: > Er, um eratta: > > >>I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers. > > I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the BLOBS through the buffers. > > (But you knew what I meant).. > > > -------------------------------------------------- > *From:* informix-list-bounces@iiug.org on behalf of Southwell Schuyler > *Sent:* Sun 8/6/2006 8:08 AM > *To:* informix-list@iiug.org > *Subject:* Where are my (simple) BLOBS, really? > > > > Environment: HP_UX 11.11 IDS 10.00.FC4X2 > > -- > > I have a need (HDR) to re-attach my TEXT/BYTE blobs to my tables. > > I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers. > > After recreating the tables, a 'dbschema' seems to show the blob column is with/IN the table, as in: > > > <snip>

Ooops, I wasn't looking very carefully and my answer was complete trash. bozon wrote: > Did you do a dbschema -d <database> -t <table> -ss > > I think the ss is important without it you get simple schema without > the storage options. > > It looks like what you did because you didn't get the extent or the > locking mode of the table. > > Southwell Schuyler wrote: > > Er, um eratta: > > > > >>I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers. > > > > I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the BLOBS through the buffers. > > > > (But you knew what I meant).. > > > > > > -------------------------------------------------- > > *From:* informix-list-bounces@iiug.org on behalf of Southwell Schuyler > > *Sent:* Sun 8/6/2006 8:08 AM > > *To:* informix-list@iiug.org > > *Subject:* Where are my (simple) BLOBS, really? > > > > > > > > Environment: HP_UX 11.11 IDS 10.00.FC4X2 > > > > -- > > > > I have a need (HDR) to re-attach my TEXT/BYTE blobs to my tables. > > > > I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers. > > > > After recreating the tables, a 'dbschema' seems to show the blob column is with/IN the table, as in: > > > > > > <snip>

Here is a much less stupid answer CREATE TABLE resume ( fname CHAR(15), lname CHAR(15), phone CHAR(18), recd_date DATETIME YEAR TO HOUR, contact_date DATETIME YEAR TO HOUR, comments VARCHAR(250, 100), vita TEXT IN TABLE, photo BYTE IN photo_space ) IN employ notice they say text in table. Which I found at: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls986.htm bozon wrote: > Did you do a dbschema -d <database> -t <table> -ss > > I think the ss is important without it you get simple schema without > the storage options. > > It looks like what you did because you didn't get the extent or the > locking mode of the table. > > Southwell Schuyler wrote: > > Er, um eratta: > > > > >>I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers. > > > > I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the BLOBS through the buffers. > > > > (But you knew what I meant).. > > > > > > -------------------------------------------------- > > *From:* informix-list-bounces@iiug.org on behalf of Southwell Schuyler > > *Sent:* Sun 8/6/2006 8:08 AM > > *To:* informix-list@iiug.org > > *Subject:* Where are my (simple) BLOBS, really? > > > > > > > > Environment: HP_UX 11.11 IDS 10.00.FC4X2 > > > > -- > > > > I have a need (HDR) to re-attach my TEXT/BYTE blobs to my tables. > > > > I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers. > > > > After recreating the tables, a 'dbschema' seems to show the blob column is with/IN the table, as in: > > > > > > <snip>

Thanks. That is the way I CREATE the table, and running a dbschema afterward seems to verify that the text/blob column is indeed IN TABLE. On the appearance of the dbschema output, everything looks exactly as I would expect. However, to track how I am progressing, I run a 'sanity query' against the sysblobs table, looking for blobs that are NOT in my new dbspace. Instead of showing the dbspace of the table, it (sysblobs) shows my blob is now in the default dbspace for my database. I COULD load some data and see which dbspace begins to use space, but I would rather understand why I am observing this behavior. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of bozon Sent: Monday, August 07, 2006 9:01 AM To: informix-list@iiug.org Subject: Re: Where are my (simple) BLOBS, really? Here is a much less stupid answer CREATE TABLE resume ( fname CHAR(15), lname CHAR(15), phone CHAR(18), recd_date DATETIME YEAR TO HOUR, contact_date DATETIME YEAR TO HOUR, comments VARCHAR(250, 100), vita TEXT IN TABLE, photo BYTE IN photo_space ) IN employ notice they say text in table. Which I found at: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/co m.ibm.sqls.doc/sqls986.htm bozon wrote: > Did you do a dbschema -d <database> -t <table> -ss > > I think the ss is important without it you get simple schema without > the storage options. > > It looks like what you did because you didn't get the extent or the > locking mode of the table. > > Southwell Schuyler wrote: > > Er, um eratta: > > > > >>I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers. > > > > I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the BLOBS through the buffers. > > > > (But you knew what I meant).. > > > > > > -------------------------------------------------- > > *From:* informix-list-bounces@iiug.org on behalf of Southwell Schuyler > > *Sent:* Sun 8/6/2006 8:08 AM > > *To:* informix-list@iiug.org > > *Subject:* Where are my (simple) BLOBS, really? > > > > > > > > Environment: HP_UX 11.11 IDS 10.00.FC4X2 > > > > -- > > > > I have a need (HDR) to re-attach my TEXT/BYTE blobs to my tables. > > > > I have a new 6K bufferpool for those few tables affected, to minimize the impact of now passing the logs through the buffers. > > > > After recreating the tables, a 'dbschema' seems to show the blob column is with/IN the table, as in: > > > > > > <snip> _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list