1. Home
  2. Certification
  3. Advanced DBA Certification Guide and Reference

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.



    		IBM Press Series?Information Management
    		About Prentice Hall Professional Technical Reference
    		Foreword
    		Preface
    		Chapter 1. Data Storage
    		Chapter 2. Data Manipulation
    		Chapter 3. Database Availability
    		Chapter 4. Database Security
    		Chapter 5. Multi-Dimensional Clustering
    		Chapter 6. The DB2 Optimizer
    		Chapter 7. Federated Database Access
    		Chapter 8. Performance Tuning
    		Chapter 9. Database Communications
    		Database Partition Configuration File (db2nodes.cfg)
    		Default Port Range
    		Non-Partitioned Database Environment
    		Installing the DB2 Server
    		Partitioned Database Environment
    		Post-Installation Setup
    		Installing and Configuring DB2 Client to DB2 Server Communications
    		Installing and Configuring DB2 Client to DB2 Host Communications
    		Installing DB2 Connect Personal Edition
    		Configuring DB2 Clients in a Two-Tier Environment
    		Configuring DB2 Clients in a Three-Tier Environment
    		FCM Communication Buffers Considerations
    		Summary
    		Chapter 10. Performance Tuning Examples
    		Appendix A. Useful DB2 Commands
    		Appendix B. parseSQL.pl
    		Appendix C. exfmtDIF.pl
    		Appendix D. Comparing Index Advisor Recommended Indexes with Existing Indexes
    		Appendix E. Configuration Parameters That Can Be Changed Online
    		Appendix F. Explain Tools
    		Appendix G. Starting and Stopping a DB2 Instance
    		Appendix H. LDAP Integration in DB2 UDB Using Microsoft Active Directory
    		Appendix I. Tuning DB2 UDB in the IBM LDAP Environment
    		Appendix J. DB2 Support Information
    		Appendix K. DB2 Connect Implementation
    		Appendix L. Sample Questions
    		Appendix M. Answers to Sample Questions
    		About the CD-ROM
    		Article