I just posted a new RFE entry. Please vote for it if you think it may be useful:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-375
Here's the description:
Allow specifying a normal dbspace for a BYTE or TEXT column to isolate IOs for the blob data from main row data for the table. This would be logged space just like IN TABLE as opposed to IN blobspace blob pages.
And my suggested syntax:
Perhaps the syntax might be:
colname BYTE IN TABLE USING dbspacename
or
colname BYTE IN TABLE( dbspacename )
or
colname BYTE IN TABLE FRAGMENT IN (dbspace1, dbspace2, dbspace3,...)
The FRAGMENT IN would only be ROUND ROBIN and the default if no dbspace is provided would continue to be the table's home dbspace(s).
With similar syntax for ALTER FRAGMENT ON BYTE/TEXT to allow for reorganization.
------------------------------
Art Kagel
------------------------------
#Informix