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

Table A-1 lists the 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 RDAREAs141Count
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 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 connections112000Count
Maximum number of users that can be created by HiRDB21UnlimitedCount
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 server312,000,000Count
HiRDB file system areaHP-UXLarge file not usedRegular file12,047MB
Character special file12,047MB
Large file usedRegular file1131,071MB
Character special file1131,071MB
SolarisLarge file not usedRegular file12,047MB
Character special file12,047MB
Large file usedRegular file11,048,575MB
Character special file11,048,575MB
AIX 5LLarge file not usedRegular file12,047MB
Character special file12,047MB
Large file usedRegular file (JFS)165,411MB
Regular file (JFS2)11,048,575MB
Character special file11,048,575MB
LinuxLarge file not usedRegular file12,047MB
Character special file12,047MB
Large file usedRegular file11,048,575MB
Character special file11,048,575MB
1 For a configuration with multiple front-end servers, the maximum for number of front-end servers [Figure] value of pd_max_users is 2,000.
2
  • When the Directory Server linkage facility is not used
    The value depends on the size of data dictionary RDAREAs because one row of the data dictionary table (SQL_USERS) is used per user.
  • When the Directory Server linkage facility is used
    For a user with CONNECT privilege only, the value depends on the directory server specifications. For a user with other privileges, the value is same as when the Directory Server linkage facility is not used.
3 However, for the entire system, the maximum is 2,147,483,647.