Condition | Appropriate global buffer sectors count |
---|
Global buffer to which specification of -r or -o option is applicable#1 | HiRDB single server configuration | Number of concurrently occurring SQL processing requests number of pages used by one SQL statement (roughly 3 to 6) |
HiRDB parallel server configuration | Number of concurrently executing users average number of concurrently accessed tables per transaction 3 n#2 |
Global buffer to which specification of -b option is applicable | Number of data pages stored in LOB RDAREA residency degree#3 (%) |
Global buffer to which specification of -i option is applicable#1 | Number of pages storing index residency degree#4 (%) |