NT Registry

Structure

HKEY_LOCAL_MACHINE\Software\SAP\<SID>\Environment

Parameter

DB2DB6_AUDIT_ACTIVE

Default

1

Options

0|1

Purpose

To switch logging for DB2 user exit off/on.

Recommendation

Set to "1".

Parameter

DB2DB6_ERROR_ACTIVE

Default

1

Options

0|1

Purpose

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

Recommendation

Set to "1".

Parameter

DB2DB6_ARCHIVE_PATH

Default

<drive>:\db2\<SID>\log_archive

Options

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

Purpose

The 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.

Parameter

DB2DB6_RETRIEVE_PATH

Default

\\<hostname>\sapdb2\log_archive

Options

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

Purpose

Directory for storing restored log files

Recommendation

Ensure that there is enough space - leave unchanged.

Parameter

DB2DB6_AUDIT_ERROR_ATTR

Default

a

Options

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

Purpose

Create mode for error and protocol files

Recommendation

a

Parameter

DB2DB6_TEMP_DIR

Default

<drive>:\db2d3n\db2UserExits

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 .

Parameter

DB2DBDFT

Default

<SID>

Options

Must match the DB2DBDFT environment variable.

Purpose

Like DB2DBDFT environment variable

Recommendation

Do not change.

Parameter

DB2INSTANCE

Default

DB2<SID>

Options

 

Purpose

R/3 database instance owner

Recommendation

Do not change.

Parameter

DB2DB6EKEY

Default

<SID><DB-server-hostname>

Options

 

Purpose

Password service encryption key

Recommendation

Must match the encryption key on application and database servers. In order to avoid mismatches between the servers, take care when changing the entry!

Parameter

DSCDB6HOME

Default

<hostname>

Options

Set during installation.

Purpose

Host where the password file is located.

Recommendation

Do not change.

Parameter

INSTHOME

Default

<drive>:\DB2<SID>

Options

In place of a drive, a share can be specified.

Purpose

Contains db2admin and diagnostic files and paths (for example, errors and saparch).

Recommendation

Do not change.

Parameter

SAPEXE

Default

<drive>:\usr\sap\<SID>\SYS\exe\run

Options

In place of a drive, a share can be specified.

Purpose

Directory where SAP executables are located.

Recommendation

Do not change.

Parameter

SAPMNT

Default

<drive>:\usr\sap\<SID>

Options

In place of a drive, a share can be specified.

Purpose

Directory where SAP executables, profiles, and so on are located.

Recommendation

Do not change.