Formatting Event Log messages

Ensure that messages written by the server to the Event Log on Windows are formatted correctly by creating a registry key.

Prerequisites

There are no prerequisites for this task.

Task

Create the registry key.

For the 32-bit version of the server, create the following key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 16.0

For the 64-bit version of the server, create the following key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY64 16.0

Within this key, add a REG_SZ value named EventMessageFile and assign it the data value of the fully qualified location of dblgen16.dll, such as C:\Program Files\SQL Anywhere 16\Bin32\dblgen16.dll.

The following specifies the EventMessageFile key to the c:\\sa16\\bin32\\dblgen16.dll directory:
"EventMessageFile"="c:\\sa16\\bin32\\dblgen16.dll"
The English language version of the DLL, dblgen16.dll, can be specified regardless of the deployment language.

Create the registry key to ensure that messages written by MESSAGE...TO EVENT LOG statements to the Event Log are formatted correctly.

For the 32-bit version of the server, create the following key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 16.0 Admin

For the 64-bit version of the server, create the following key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY64 16.0 Admin

Within this key, add a REG_SZ value named EventMessageFile and assign it the data value of the fully qualified location of dblgen16.dll, such as C:\Program Files\SQL Anywhere 16\Bin32\dblgen16.dll.

For example, the following specifies the EventMessageFile key to the c:\sa16\bin32\\dblgen16.dll directory:
"EventMessageFile"="c:\\sa16\\bin32\\dblgen16.dll"
The English language version of the DLL, dblgen16.dll, can be specified regardless of the deployment language.
Create the following registry key to control log entry suppression:
Software\Sybase\SQL Anywhere\16.0\EventLogMask
The key can be placed in the HKEY_CURRENT_USER or HKEY_LOCAL_MACHINE hive.

Create a REG_DWORD value named EventLogMask and assign a bit mask value containing the internal bits for the different Windows event types.

The following bit types are used by the SQL Anywhere database server:

EVENTLOG_ERROR_TYPE        0x0001
EVENTLOG_WARNING_TYPE      0x0002
EVENTLOG_INFORMATION_TYPE  0x0004

For example, if the EventLogMask key is set to zero, no messages appear at all. A better setting would be 1, so that informational and warning messages don't appear, but errors do. The default setting (no entry present) is for all message types to appear. Here is a sample registry setting:

"EventLogMask"=dword:00000007

Results

Event Log messages are formatted in the desired language, and are reported according to the bit mask value assigned to the EventLogMask registry key.

Example

The following example illustrates a sample registry file that formats Event Log messages sent by the 32-bit version of the server:

REGEDIT4
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 16.0]
"EventMessageFile"="c:\\sa16\\bin32\\dblgen16.dll"

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 16.0 Admin]
"EventMessageFile"="c:\\sa16\\bin32\\dblgen16.dll"

[HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\SQL Anywhere\16.0]
"EventLogMask"=dword:00000003

In this example, the English version of the DLL, presumed to be located in c:\\sa16\\bin32\\dblgen16.dll, is used to format Event Log messages. The bit mask value of the EventLogMask indicates that only errors and warnings should be recorded, not informational messages.

Discuss this page in DocCommentXchange.