Informix 12.10.FC14
Solaris 10 1/13
I have an Informix instance that contains several databases. Only one of these databases contains any BLOBs (smart large objects). There are 12 tables that contain, in total, over 650,000 BLOBs (mostly photos).
I wanted to move all the sblobs to a new sbspace. So, I created an SPL that used a FOREACH loop to ripple through every table that had at least one sblob column, and, for that table, executed an UPDATE command that used LOCOPY() to assign the BLOB column(s) to themselves.
At first, I thought it worked like a charm. I used oncheck -pe to count the number of LOs, and there were over 650K.
Just to be sure, I also used the same oncheck command to count the number of LOs that remained in the original sbspace.
I was expecting to find 0. But, there are 76 LOs remaining. They are all very tiny (3 - 5 pages).
So, I have a mystery. Just what are these objects, and what table(s) are referencing them?
Thus, my question: How can I determine a list of table(s)/column(s) that are referencing these mysterious LOs?
IOW, I have some LOs in an sbspace. How do I know what table(s) they "belong to"?
Thank you.
David Grove
------------------------------
David Grove
------------------------------
#Informix