Nonstop Database, HiRDB Version 9 Installation and Design Guide

[Contents][Index][Back][Next]

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

Item Minimum value Maximum value Units
Number of servers that can be created per unit 1 34 Count
Number of single servers 1 1 Count
Number of system managers 1 1 Count
Number of front-end servers 1 1,024 Count
Number of dictionary servers 1 1 Count
Number of back-end servers 1 16,382 Count
Total number of RDAREAs 3 8,388,592 Count
Number of master directory RDAREAs 1 1 Count
Number of data directory RDAREAs 1 1 Count
Number of data dictionary RDAREAs 1 59 Count
Number of data dictionary RDAREAs that store database state analyzed tables and database management tables 1 1 Count
Number of user RDAREAs 0 8,388,589 Count
Number of data dictionary LOB RDAREAs 0 2 Count
Number of user LOB RDAREAs 0 8,388,325 Count
Number of registry RDAREAs 0 1 Count
Number of registry LOB RDAREAs 0 1 Count
Number of list RDAREAs 0 8,388,588 Count
Number of HiRDB files per RDAREA 1 16 Count
Number of base tables and sequence generators per RDAREA 0 500 Count
Number of indexes per RDAREA 0 500 Count
Number of lists per RDAREA 0 50,000 Count
Total number of HiRDB files 1 134,217,728 Count
Number of concurrently accessible tables 4 32,000 Count
Maximum number of concurrent connections 1 For a HiRDB single server configuration: 3,000
For a HiRDB parallel server configuration: 2,000#1
Count
Maximum number of users that can be created by HiRDB#2 1 Unlimited Count
Number of users who can own the same list 0 32,767 Count
Number of lists created per user 0 32,767 Count
Number of work tables created per transaction 0 255 Count
Number of global buffers per server#3 1 2,000,000 Count
HiRDB file system area HP-UX Large file not used Regular file 1 2,047 MB
Character special file 1 2,047 MB
Large file used Regular file 1 1,048,575 MB
Character special file 1 1,048,575 MB
Solaris Large file not used Regular file 1 2,047 MB
Character special file 1 2,047 MB
Large file used Regular file 1 1,048,575 MB
Character special file 1 1,048,575 MB
AIX Large file not used Regular file 1 2,047 MB
Character special file 1 2,047 MB
Large file used Regular file (JFS) 1 65,411 MB
Regular file (JFS2) 1 1,048,575 MB
Character special file 1 1,048,575 MB
Linux Large file not used Regular file 1 2,047 MB
Character special file 1 2,047 MB
Large file used Regular file 1 1,048,575 MB
Character special file 1 1,048,575 MB

#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: 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.