Appendix A.1 Maximum and minimum values for the system configuration

The following table lists maximum and minimum values for the HiRDB system configuration.

Table A-1 Maximum and minimum values for the HiRDB system configuration

ItemMinimum valueMaximum valueUnits
Number of servers that can be created per unit134Count
Number of single servers11Count
Number of system managers11Count
Number of front-end servers11,024Count
Number of dictionary servers11Count
Number of back-end servers116,382Count
Total number of RDAREAs38,388,592Count
Number of master directory RDAREAs11Count
Number of data directory RDAREAs11Count
Number of data dictionary RDAREAs159Count
Number of data dictionary RDAREAs that store database state analyzed tables and database management tables11Count
Number of user RDAREAs08,388,589Count
Number of data dictionary LOB RDAREAs02Count
Number of user LOB RDAREAs08,388,325Count
Number of registry RDAREAs01Count
Number of registry LOB RDAREAs01Count
Number of list RDAREAs08,388,588Count
Number of HiRDB files per RDAREA116Count
Number of base tables and sequence generators per RDAREA0500Count
Number of indexes per RDAREA0500Count
Number of lists per RDAREA050,000Count
Total number of HiRDB files1134,217,728Count
Number of concurrently accessible tables432,000Count
Maximum number of concurrent connections1For HiRDB/Single Server: 3,000
For HiRDB/Parallel Server: 2,000#1
Count
Maximum number of users that can be created by HiRDB#21UnlimitedCount
Number of users who can own the same list032,767Count
Number of lists created per user032,767Count
Number of work tables created per transaction0255Count
Number of global buffers per server#312,000,000Count
HiRDB file system area11,048,575MB
Windows file size0263#1Bytes
#1: For a configuration with multiple front-end servers, the maximum for number of front-end servers x value of pd_max_users is 2,000.
#2: The value depends on the size of data dictionary RDAREAs because one row of the data dictionary table (SQL_USERS) is used per user.
#3: However, for the entire system, the maximum is 2,147,483,647.