Environment

Many environment variables apply only to AIX. In the case of NT, they are located in the NT Registry. They are brought into the environment automatically by the REG2ENV procedure. On both AIX and NT, the DB2DBDFT environment variable must be set to the SAP system ID (SID).

AIX environment

Environment variable

DB2DB6_AUDIT_ACTIVE

Default

1

Options

0|1

Purpose

To switch protocolling for DB2 user exit off/on.

Recommendation

Set to "1"

Environment variable

DB2DB6_ERROR_ACTIVE

Default

1

Options

0|1

Purpose

To switch error recording for DB2 user exit off/on.

Recommendation

Set to "1"

Environment variable

DB2DB6_ARCHIVE_PATH

Default

/db2/<SID>/log_archive/<SID>/NODE0000

Options

Any path for which db2<sid> has write access.

Purpose

Directory where DB2 user exit archives log files and where the log file archiving tool (BRARCHIVE) looks for log files to save.

Recommendation

Ensure that you have enough space in a dedicated file system. Wherever possible, do not change.

Environment variable

DB2DB6_RETRIEVE_PATH

Default

/db2/<SID>/log_retrieve/<SID>/NODE0000

Options

Any path for which db2<sid> has write access.

Purpose

Directory for storing restored log files.

Recommendation

Ensure that you have enough space. Do not change.

Environment variable

DB2DB6_AUDIT_ERROR_ATTR

Default

a (=Append)

Options

a(=Append) | w(=Write new file)

Purpose

Create mode for error and protocol files

Recommendation

a

Environment variable

DB2DB6_TEMP_DIR

Default

/tmp/UserExits

Options

Any path for which db2<sid> has write access.

Purpose

Temporary directory for archiving of log files to ADSM

Recommendation

Change so that it is no longer /tmp .

Environment variable

DB2DB6_TRCLEVEL

Default

7

Options

-1 to 5

Purpose

To set the trace level.

Recommendation

See Tracing.

Environment variable

DB2DB6_ADMTRC

Default

not_set

Options

not_set|set

Purpose

To disable/enable tracing for administration tasks.

Recommendation

Change if problems arise.

Environment variable

DB2DB6_TRCPATH

Default

DIAGPATH database parameter

Options

Any path for which db2<sid> has write access.

Purpose

Tracing directory

Recommendation

Do not change.