252 DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
Where INSTHOME is the database instance home directory.
On Intel platforms:
– If the DB2INSTPROF environment variable is not set:
x:\Program Files\IBM\SQLLIB\%DB2INSTANCE%
– If DB2INSTPROF is set:
x:\%DB2INSTPROF%\%DB2INSTANCE%
Where x:\SQLLIB is the drive reference and directory specified in the
DB2PATH registry variable. DB2INSTANCE is the name of the instance owner
and DB2INSTPROF is the name of the instance profile directory.
In most situations, the default paths are adequate and need not be changed.
In DB2DIGA.LOG, you can find information like values of parameters that need
to be increased, or errors that occurred, or lock escalations, and more. The value
of the database ...