IBM Support

Deregistering DB2 performance counter may result in an error "ERROR : Unable to successfully execute UnLodCtr.EXE"

Troubleshooting


Problem

While doing db2perfi -u you may get an error: "ERROR : Unable to successfully execute UnLodCtr.EXE".

Symptom

In Windows event viewer you may see error like below:

The description for Event ID 1023 from source Perflib cannot be found.
Either the component that raises this event is not installed on your
local computer or the installation is corrupted. You can install or
repair the component on the local computer.
If the event originated on another computer, the display information had
to be saved with the event.
.
The following information was included with the event:
.
DB2_NT_Performance

Cause

It could happen due to corrupted registry key.

Resolving The Problem

Make sure there is just one db2perf.dll on the system present in SQLLIB\BIN directory.

Below registry key holds the information about performance counters.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DB2_NT_Performance\

Make a copy of it and then delete it and reboot the machinererun db2perfi -u. It should create a new registry key and resolve the original problem

Related Information

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - Troubleshooting","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21883475