Update to utils2_ak
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 ------------------------------
Forgot an example:
$ myschema -d art -t extents --enable-boost /tmp/f
$ cat /tmp/fCREATE 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
www.askdbmgt.com
Blog:
http://informix-myview.blogspot.com/
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.