Summary


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.



Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
ISBN: 0130463884
EAN: 2147483647
Year: 2003
Pages: 121

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net