Informix

nested-group-icon.png

DB2

New RFE entry

  • 1.  New RFE entry

    Posted Tue June 02, 2020 02:06 PM

    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
    ------------------------------