Using TRACKMOD NO in a tablespace definition
The first part of my answer will be a diatribe against defaults - so skip to the next paragraph if you don't want to read that. It is NEVER a good idea to use defaults for ANY parameter or option in DB2. And I almost never say never. The reason for this strong stance is that the defaults are often the wrong choice for general use -- and even when they are correct for many uses the default will be wrong for certain specific instances. Therefore, it is ALWAYS the best approach to know the options that are available for each parameter and specification and then to explicitly choose the proper option by coding it yourself. Even if it means slowing you down by making you open the manual, it is better to know what it is that you are requesting of DB2 than to just blindly accept a default. (Please note, this is directed at the general populace and is not meant to condemn you or your organization for accepting defaults -- this is a general problem throughout the entire industry.)
Whew, I feel better with that off my chest. Now, on to the second part of your question. There will be some minimal overhead for DB2 to track modifications for pages when TRACKMOD is set to YES. If you think about it, there has to be because there will be additional code being issued to keep track and set the change indicators. The benefit of changing existing tablespaces to TRACKMOD NO though will most likely not be worth the additional administrative effort required to make the changes. Furthermore, if you ever intend to take incremental image copies of the tablespace the gain in performance of making those copies is well worth whatever small amount of overhead is required to track the changes. If you are absolutely sure that you will never take incremental image copies, then go ahead and create the tablespace specifying TRACKMOD NO instead of the default of YES.
For More Information
- Dozens more answers to tough DB2 questions from Craig Mullins are available.
- The Best IBM DB2 Web Links: tips, tutorials, scripts, and more.
- Have a DB2 tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical DB2 questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.