I recently uninstall DB2 10.1 and reinstall DB2 10.5 Beta since DB2 10.5 Beta doesn't support upgrade. But I forgot to delete the database that my application (TSM server)I created "TSMDB1" before upgrading to 10.5.
After reinstalling, my application (TSM server) tried to use the DB but it complained the DB not found. So I tired to create the DB using sqlecrea api and it returned SQLE_RC_DUPALIAS. I tried to delete the DB using sqledrpd and it returned SQLE_RC_NODB. I tried to drop DB using DB2 droup command, it complained the DB not found.
I tried to manually create server1 instance and set db2instance=server1
I tried to catalog the DB, but it complained the DB doesn't exist.
I guess the DB is deleted but somehow there is some residual that affects sqlecrea to create the DB. Any idea how to clean up the residual?