I tried to create a database but couldn’t because of “SQL1005N The database alias “W3IBMDB” already exists in either the local database directory or system database directory.“. I knew I had once such a database, but I thought it existed no more. And indeed “list database directory” didn’t list it. So it was there andContinue reading “Kill a zombie database (not in the directory but can’t create it)”
Tag Archives: db2
DB2: Find out current locks, long transactions etc. [snapshot]
To find out current locks in a DB and other information about its current state, you need to take a “snapshot”: db2 “attach to user using ” db2 “get snapshot for applications on ” > mydatabase_snapshot.txt Look into the resulting mydatabase_snapshot.txt for “Application ID holding” (if there is a lock, this will read the IDContinue reading “DB2: Find out current locks, long transactions etc. [snapshot]”
Moved to https://blog.jakubholy.net/ 
