SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 11:45 AM
| ||||
| ||||
 RE: Where are my (simple) BLOBS, really? 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>      |
|
04-20-2008, 11:45 AM
| |||
| |||
| Re: Where are my (simple) BLOBS, really? 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> |
|
04-20-2008, 11:45 AM
| |||
| |||
| Re: Where are my (simple) BLOBS, really? 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> |
|
04-20-2008, 11:45 AM
| ||||
| ||||
| 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/infoce...oc/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> |
Linear Mode
