This section explains how to estimate the size of the memory required for each unit constituting a HiRDB parallel server configuration. The topics covered include:

• Memory allocation
• Calculation of required memory
• Formulas for shared memory used by a unit controller
• Formulas for shared memory used by each server
• Formulas for size of shared memory used by global buffers
• Formulas for size of memory required during SQL execution
• Formula for size of memory required during SQL preprocessing
• Formula for size of memory required during BLOB data retrieval or updating (for front-end servers)
• Formula for size of memory required during block transfer or array FETCH (for front-end servers)
• Formula for size of memory required during BLOB data retrieval or updating (for back-end servers or dictionary servers)

Organization of this section

15.2.1 Memory allocation

15.2.2 Calculation of required memory

15.2.3 Formulas for shared memory used by a unit controller

15.2.4 Formulas for shared memory used by each server

15.2.5 Formula for size of shared memory used by global buffers

15.2.6 Formulas for size of memory required during SQL execution

15.2.7 Formula for size of memory required during SQL preprocessing

15.2.8 Formula for size of memory required during BLOB data retrieval or updating (front-end server)

15.2.9 Formula for size of memory required during BLOB data retrieval or updating (back-end server or dictionary server)

15.2.10 Formula for size of memory required during block transfer or array FETCH (front-end server)

15.2.11 Memory required by in-memory data processing