Home > Articles > Data > DB2

This chapter is from the book

This chapter is from the book

Hierarchy of the DB2 UDB Environment

Since there are multiple places where a variable can be set, DB2 UDB uses a hierarchy to determine where it will look to determine a variable's value. It uses the following search order:

  1. The session's environment variables

  2. DB2 Profile Registry variables set in the instance node-level profile

  3. DB2 Profile Registry variables set using db2set for the session

  4. DB2 Profile Registry variables set at the instance level using the -i option of db2set

  5. DB2 Profile Registry variables set at the global level using the -g option of the db2set command

Although most DB2 UDB environment settings can be set either in the DB2 Profile Registry or in the OS environment, it is strongly recommended that the DB2 Profile Registry be used whenever possible.

  • + Share This
  • 🔖 Save To Your Account