Document Actions

Drop database left some settings befind, so create database can't be executed

Posted by Pawan at May 09. 2008

Hi,
on db2 enterprise v8.2 fp 09 on Linux I have drop the database and it looks like drop database was not correctly done.

When executing command:

Code:


db2 restore database mydb from /backup/ to /workingdir/db into mynewdb

error was returned: SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030

I tried to restore to different directory

Code:


db2 restore database mydb from /backup/ to /workingdir/dbnew into mynewdb

and restore commpleted successfully.

It looks like drop database was not correctly done. How can I "clean up" settings that have been left from drop? I would like to restore database to my original directory?

Thanks & Regards

Pawan

Re: Drop database left some settings befind, so create database can't be executed

Posted by perallis at May 09. 2008

Hello Pawan,

Try to drop manually the files related with the old database in the first director.

Catalog db yourdbname

drop db yourdbname

And execute the restore again"

DBA to DBA

Personal tools

Document Actions

Drop database left some settings befind, so create database can't be executed

Drop database left some settings befind, so create database can't be executed

Re: Drop database left some settings befind, so create database can't be executed

Would you like your company to implement gamification into your security awareness program?