IBM Support

Error "Namekey conflict with lock-file /tmp/SQLDIR.LK0. Trying another lock" in db2diag log file

Troubleshooting


Problem

What does error "Namekey conflict with lock-file /tmp/SQLDIR.LK0. Trying another lock" mean?

Symptom

Error in the db2diag log file:

2014-08-27-06.02.04.648053-300 I1179182E582  LEVEL: Error
PID : 9486 TID : 139909847312128  PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000    DB : SAMPLE
APPHDL : 0-20305     APPID: *LOCAL.db2inst1.140827110204
AUTHID : DB2INST1
EDUID : 23802      EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:910
MESSAGE : ZRC=0x800F00AD=-2146500435=SQLO_NLCK_NAMEKEY_CONFLICT
-Unknown-
DATA #1 : <preformatted>
Namekey conflict with lock-file /tmp/SQLDIR.LK0. Trying another lock.

Cause

The SQLDIR.LK0 file is used by DB2 to serialize access to all the filesystems when creating/deleting directories.

It only can be deleted while the instance is down (and *only* when the instance is down). However, as a general rule, we should not need to access/modify/delete the directory anyway.

This can usually occur after an installation or upgrade fails to clean up the SQLDIR.LK0 file from the /tmp directory.

Resolving The Problem

1. Bring down all DB2 instances on the server.
db2stop

2. Check the /tmp directory for the SQLDIR.LK0 file. Remove the file if it exists in the directory .

3. Bring the instance back up and monitor to see if the error comes back.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Fixpak","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21683234