Kill a zombie database (not in the directory but can’t create it)

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)”

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]”