Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Bufferpools for system catalog

A quick performance tip for DB2.

If you create a new 4k bufferpool with about 10000 pages, you can then assign it to the tablespace syscatspace....

This will increase the performance of your system. It will no longer need to ready you system catalog from DISK each time. Also, since it's in its own bufferpool, the data will always be in memory. You may need to change the pages size, and check the buffer pool hit ratio as needed.

For More Information

This was last published in February 2002

Dig Deeper on DB2 UDB (universal databases)

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.