Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Sebastien FLAESCH — source: IBM Community (ConnectedCommunity.org) Informix forum
Hello,
Reading:
SMALL and LARGE tables
How can I enable SMALL tables server-wide with an onconfig parameter?
I see there is a session parameter
SET ENVIRONMENT TABLE_SIZE = SMALLBut what if I want to have only SMALL tables?
Seb
------------------------------
Sebastien FLAESCH
------------------------------
↪ replying to Sebastien FLAESCH
Art Kagel — source: IBM Community (ConnectedCommunity.org) Informix forum
Sebastien:
There is an undocumented ONCONFIG parameter (I think that it should be documented) that controls the default table status:
TABLE_SIZE SMALL
the default is:
TABLE_SIZE LARGE
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.