Parameter
zcsa/table_buffer_area
Short text
Size of Resident-Table Buffer
Parameter Description
Specifies the size of the resident-table (100%) buffer. This buffer holds entries from tables which have been defined in the Data Dictionary with buffer type X (buffer all entries that belong to active clients) and G (buffer entries according to a generic key specification).
Application Area
System , Tuning
Parameter Unit
Bytes
Default Value
6000000
Who is permitted to make changes?
Customer
Operating System Restrictions
None
Database System Restrictions
None
Are other parameters affected or dependent?
ipc/shm_psize_10, zcsa/db_max_buftab
ipc/shm_psize_10: In standard systems, the resident-table buffer is stored in shared memory pool 10. If you change the size of the buffer, then you must change the amount of memory in pool 10 by the same amount. You can remove the buffer from the pool by setting the parameter ipc/shm_psize_19=0. Removing the buffer from pool 10 simplifies your profile management. The buffer is stored in its own shared memory segment, which is allocated automatically when the server is started. You do not have to change ipc/shm_psize_10 when you change the buffer size. You cannot remove the buffer from pool 10 in AIX systems. In AIX, the number of shared memory pools that can be allocated is limited.
