4
Kill a zombie database (not in the directory but can’t create it)
source link: https://blog.jakubholy.net/2006/11/02/kill-a-zombie-database-not-in-the/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Kill a zombie database (not in the directory but can’t create it)
November 2, 2006
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 and it wasn't there.
It seems that DB2 remembers the old databases if you don't remove them in the correct way (whatever that is). The steps to fix this were:
It seems that DB2 remembers the old databases if you don't remove them in the correct way (whatever that is). The steps to fix this were:
- catalog db w3ibmdb
- check "list database directory" to verify that it is listed now
- drop database W3IBMDB
- create database W3IBMDB -- Voila - no more error messages
Are you benefitting from my writing? Consider buying me a coffee or supporting my work via GitHub Sponsors. Thank you! You can also book me for a mentoring / pair-programming session via Codementor or (cheaper) email.
Allow me to write to you!
Let's get in touch! I will occasionally send you a short email with a few links to interesting stuff I found and with summaries of my new blog posts. Max 1-2 emails per month. I read and answer to all replies.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK