Master all aspects of IBM DB2 database administration and prepare to take and pass IBM's Certification Exams 611 and 311: Certified Database Administrator.
Written by Mohankumar Saraswatipura and Robert (Kent) Collins
Editor's note: This article is an excerpt from the new book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.
During normal operation, the DB2 database manager's behavior is controlled, in part, by a collection of values that defines the DB2 operating environment. Some of these values are operating system environment variables, and others are special DB2-specific system-level values known as environment or registry variables. Registry variables provide a way to centrally control the database environment. Four different registry profiles are available, and each controls the database environment at a different level. The registry profiles are as follows: