SEO

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/infoce....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

Blobs can either be in blobspaces or in the table's partition/fragments, so at least you can be confident regarding the 'in table'.

sysblobs might be a bit 'unreliable' regarding your desired information (dbschema should be a better choice), and if there was a
conflict with documented behavior, this could probably count as a bug.

Unfortunately the two places where I find sysblobs explained are a bit vague as well:

"The sysblobs system catalog table contains information about the location of dbspaces and of simple large objects."

.... so what might be the location of a dbspace... ?

Column Type Explanation
spacename VARCHAR(128) Name of partition, dbspace, or family

.... and what a partition's name?

Strange, but I don't think many people would mind.

And as an addtl. hint (how dbschema finds out): if syscolumns.colmin is greater than 0 for a blob columns, it is the blobspace
number for a 'detached' blob column - if it's 0, it's an 'attached' blob.

Regards,
Andreas