 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / June 2006Instance
hai everyone... i have a scenario here....... i have a database in a instance......... mistakenly i dropped the instance . i have all the database files...... can i bring back the database again...... if yes can u pls explain how i can do tht..... regards, kamal > hai everyone... > [quoted text clipped - 5 lines] > regards, > kamal Create the instance again with db2icrt and catalog the databases with the 'catalog db <dbname> on <drive/path>'. To find out which databases you must catalog you can use the command 'list db directory at <drive/path>'. > > hai everyone... > > [quoted text clipped - 10 lines] > To find out which databases you must catalog you can use the command > 'list db directory at <drive/path>'. thanks gret.... regards kamal I dont think that would work, you need to recreate the instance using db2icrt then attach to that isntance.Once you are attached to the instance you need to restore your database into the new instance. Hope that helps! > > > hai everyone... > > > [quoted text clipped - 15 lines] > regards > kamal > I dont think that would work If the directory where the db is located is unchanged after dropping the instance cataloging the database for sure will be enough to get it back. I've done it a couple of times when I wanted to move the instances to another directory, I'm sure it works. > > I dont think that would work > > If the directory where the db is located is unchanged after dropping the > instance cataloging the database for sure will be enough to get it back. > I've done it a couple of times when I wanted to move the instances to > another directory, I'm sure it works. \ Ya its working.....what gert said is true...... regards... kamal.... Sorry my bad...I thought of it as dropping the database and not the instance..! > > > I dont think that would work > > [quoted text clipped - 8 lines] > regards... > kamal.... I dont think that would work, you need to recreate the instance using db2icrt then attach to that isntance.Once you are attached to the instance you need to restore your database into the new instance. Hope that helps! > > > hai everyone... > > > [quoted text clipped - 15 lines] > regards > kamal > I dont think that would work, you need to recreate the instance using > db2icrt then attach to that isntance.Once you are attached to the > instance you need to restore your database into the new instance. > Hope that helps! Why do you think that? Cheers Serge  SignatureSerge Rielau DB2 Solutions Development IBM Toronto Lab IOD Conference http://www.ibm.com/software/data/ondemandbusiness/conf2006/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.