New blog post and PlanetIDS no more

Posted in 2018

Topics: Storage & Space Management, Server Administration

BENJAMIN THOMPSON — Fri, 13 Jul 2018 17:53:44 — source: IIUG Forums & Mailing Lists

I was slightly surprised to find out that Informix Zone and PlanetIDS are no more: https://herber-consulting.de/informix-zone I found PlanetIDS particularly useful as single point for knowing when someone had blogged about Informix and it's a shame it's gone. Its demise seems to have gone uncommented on in here so far. I used to also use it to publicise my own blog posts. Today I've written a new blog post and here it is: https://informixdba.wordpress.com/2018/07/13/extent-size-doubling/ It was an afternoon's work on something that had been bothering me for a while because I didn't properly understand it. I hope you appreciate it. Ben.

↪ replying to BENJAMIN THOMPSON

ART KAGEL — Wed, 18 Jul 2018 18:51:00 — source: IIUG Forums & Mailing Lists

Great BLOG post Ben. One comment (which I posted to the BLOG as well): Since version 11.70 the limit on the number of extents was increased from roughly 238 (for 2K dbspaces) to 2048 (for all page sizes). With the extent doubling and the 2^24 page limit this is virtually unlimited for tables (although it is theoretically possible for an index to reach the limit as indexes are not restricted to 2^24 pages). -- Art