Maximum Global Size ?
Dear people,
I (really) spent hours on finding the maximum size a Global is allowed to be (for Windows, if that matters). All I seem to run into are database sizes (derived from a max number of blocks and block size), but I refuse to believe that is correct because too small to be realistic.
It will undoubtedly my fault that I don't understand or misread the concepts of "database" vs Globals, envisioning files as such while one set of functional Globals in one file (?!) could comprise of a database, hence it is one file after all, that file (block structure) not able to be larger than 17GB or whatever it is that I (mis)calculate. Anyway, even if one Global would be allowed to be 17GB, it does not exactly feel like "the largest" etc. databases, which is what I see advertised ?
The reason I like to know is because I'm heading for a migration from another DBMS with really multiples of mentioned size per table alone, at ~1500 tables (not all as large) and I would hope that this is possible regarding limits. There would still be some hope because what we currently use (Sybase) is not sparse, but without knowing in advance the net result of that.
N.b.: I read about a possible "spread" of Globals over more than one database, but at this moment this is beyond my comprehension (for possible solution).
Otherwise, if necessary you can talk back in technical contexts; I am from the Mumps era that multiway balanced trees where the best "we" ever created, and I could understand the implication of e.g. too many depth levels and from there a limit. This is 40 years or so ago now and I am more than eager to come back !
Regards and thanks !
Peter