View Single Post

   
  #2 (permalink)  
Old 04-20-2008, 11:53 AM
Andreas Legner
 
Posts: n/a
Default Re: Where are my (simple) BLOBS, really?

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
Reply With Quote