Jump to content
Gidget

Cannot recreate DB2 database after dropping

Recommended Posts

I am in kind of a bind. Every week I restore our production Database into a different database on a different Server for viewing by the users. Both Server are Windows boxes running V9.5

 

Usually a just do a redirected restore but the datbase is growing by eaps and bounds so this week I decided to drop the target database and then recreate it fresh, set the tablespace and then restore.

 

I dropped the target database and now I cannot recreate it in that instance. when i try and recreate it I get this error:

 

SQL1005N The database alias "dutdm" already exists in either the

local database directory or system database directory.

 

I have tried catloging and uncataloging the target database in the instance.. whatever I try it just says the database does not exist. Can anyone help?????

Share this post


Link to post
Share on other sites

I call foul with this post....

 

You seem to be copy/pasting from a bunch of random sites. For example, this post is VERY similar to

I am in kind of a bind. Every week I restore our production Database into a different database on a different Server for viewing by the users. Both Server are Windows boxes running V9.5

 

Usually a just do a redirected restore but the datbase is growing by eaps and bounds so this week I decided to drop the target database and then recreate it fresh, set the tablespace and then restore.

 

I dropped the target database and now I cannot recreate it in that instance. when i try and recreate it I get this error:

 

SQL1005N The database alias "dutdm" already exists in either the

local database directory or system database directory.

 

 

I have tried catloging and uncataloging the target database in the instance.. whatever I try it just says the database does not exist. Can anyone help?????

 

 

And here is the link to the ORIGINAL source: http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14275798

 

 

What's the reason for this?

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

×