Adaptive Server versions 15.7 ESD #2 and later expand the maximum size of a database to approximately 64 terabytes by converting the logical page number from a signed integer to an unsigned integer.
Versions of Adaptive Server earlier than 15.7 ESD #2 allowed for a maximum database size of approximately 32 terabytes.
The maximum size of a database depends on its logical page size:
2K page server = 8TB
4K page server = 16TB
8K page server = 32TB
16K page server = 64TB
Because Adaptive Server reserves 256 logical page IDs—which cannot be allocated or used—at the high end of the logical page range, the sizes listed above are slightly higher than the actual amount of space available for use. This overhead reduces the actual amount of space available by 256 times the logical page size for each listed page size (for example, the actual available size for a 2K server is 8TB – (256 x 2K)).
Expanding the maximum size of a database requires you to change the datatypes for these columns from int to unsigned int:
sysusages – lstart, size, and unreservedpgs
sysaltusages – lstart and size
syspartitions – firstpage, rootpage, dataoampage, and indoampage
systabstats – leafcnt, pagecnt, emptypgcnt, warmcachepgcnt, unusedcnt, and oampgct
syslocks – page
syslogshold – page
systhresholds – free_space
You must change the expected result for any queries that rely on the columns listed above from an int to an unsigned int.
These functions now return an unsigned int result instead of an int:
curunreservedpgs
used_pages
data_pages
reserved_pages
lct_admin