UDS/SQL can manage a maximum of 16777214 database pages in a realm. This gives the following limit values for the maximum file sizes:
Size of database page | Maximum file size in PAM pages |
2 KB | 16777214 |
4 KB | 33554428 |
8 KB | 67108856 |
Table 17: Limit values for file sizes
You can ascertain the logical realm size in the following ways:
The DAL command DISPLAY FPA will output the current logical realm size NR PAGES and the number of free database pages NR FREE PAGES which the realm contains.
The command DISPLAY REALM of the utility routine BSTATUS will display the logical realm size (SPACE USED BY REALM / TOTAL NR OF PAGES) and detailed information on the free space which the realm contains.
The command DISPLAY PAGE ZERO of the utility routine BPRECORD will display the logical realm size (FPA BASE / TOTAL NR PAGES).
Use the BS2000 command SHOW-FILE-ATTRIBUTES to output information on the physical realm size i. e. the number of PAM pages which have already been reserved, and on the current secondary assignment setting (SECONDARY-ALLOCATION) of the realm file. Both these specifications are also up to date for an open realm file.