Registry Variable Tuning

The DB2 registry variables have an effect on the entire DB2 instance and all databases within the instance, as well as on all applications that access any of the databases. The following registry variables have the biggest effect on performance of the instance, databases, and applications:

  • DB2_USE_PAGE_CONTAINER_TAG

  • DB2_HASH_JOIN

  • DB2_PARALLEL_IO

  • DB2_NO_PKG_LOCK

  • DB2_NT_NOCACHE

  • DB2_SPIN_LATCHES

DB2_USE_PAGE_CONTAINER_TAG

Background

When a DMS table space is created, the file or raw device containers will be pre-allocated by DB2. Within the first extent of each container, DB2 will create the container tag as it does with SMS table spaces.

In previous versions of DB2 UDB, the container tag was stored in a single page to minimize ...

Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial