Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
As this chapter has explained, for partitioned database systems, the FCM requires substantial memory space, especially if the value of FCM_NUM_BUFFERS is large. For configuring the FCM, start with the default value for the number of FCM buffers (FCM_NUM_BUFFERS) and use the database system monitor to monitor the low water mark for the free buffers, tuning this parameter as needed. |