Blobspace question
Posted in 2000
Topics: Storage & Space Management, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Platform-Specific Issues
My system is a sun 4000 solaris 2.6 with 1.5 gig
ram running 7.23 UC11. I have a blobspace
containing several chunks, the blobspace in
question is used by one table. I would like to
copy only those rows (and their blobs) that
contain pointers to certain chunks in the
blobspace (ex 50 chunks allocatted to blobspace,
I need the rows who reference blobs located in
the last five chunks) My question: Is it possible
to write a program ESQL-C or similar that could
isolate rows in the table whose pointers point to
the certain series of chunks and copy to a new
table.
The reason I need to perform this operation is
that several chunks in this blobspace were
accidently allocatted (using onspaces) to another
blobspace in another informix instance, no new
blobs were written, but now the blob free map is
clear even though the blobs still exist.
Any help would be appreciated
Sent via Deja.com http://www.deja.com/
Before you buy.