Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Update to utils2_ak

    Posted Wed February 25, 2026 08:01 PM
    Folks:
    I just uploaded another update to my utils2_ak package:
     
    myschema: Added a new option, --enable-boost, to include SQL API function calls to enable PFSC Boosted Caching of free space in variable length tables when this feature is enabled in the source database for a table. The Boosted Caching improves insert performance for variable length tables when MAX_FILL_DATA_PAGES is enabled.
    Art


    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------


  • 2.  RE: Update to utils2_ak

    Posted Wed February 25, 2026 08:05 PM
    Forgot an example:

    $ myschema -d art -t extents --enable-boost /tmp/f

    $ cat /tmp/f

    CREATE LARGE TABLE "art".extents (
    dbsname "informix".lvarchar(10000),
    tabname "informix".lvarchar(10000),
    chunk INTEGER,
    offset INTEGER,
    size BIGINT,
    truth "informix".boolean
       DEFAULT 't',
    id BIGSERIAL(217329) NOT NULL
    ) IN datadbs_1 EXTENT SIZE 129108 NEXT SIZE 16 LOCK MODE ROW STATCHANGE 0
    ;

    {
    Please review extent sizing and adjust to allow for growth.
    }

    REVOKE ALL ON "art".extents FROM public AS "art";
    CREATE INDEX "art".extents_ix1 ON "art".extents (
    id ASC
    ) USING btree IN datadbs_1;


    CREATE INDEX "art".extents_ix3 ON "art".extents (
    chunk ASC,
    offset ASC,
    size ASC
    ) USING btree IN datadbs_1
    HASH ON (
    dbsname
    ) WITH 4 BUCKETS;


    GRANT SELECT, UPDATE, INSERT, DELETE, INDEX ON "art".extents TO "public" AS "art";
    GRANT ALL ON "art".extents TO "testrole" AS "art";

    EXECUTE FUNCTION sysadmin:task( 'table pfsc_boost enable', 'extents', 'art' );



    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.









Related Content