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 8 1366
In article <11**********************@u72g2000cwu.googlegroups .com>, vk************@gmail.com says... 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
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>'.
Gert van der Kooij wrote: In article <11**********************@u72g2000cwu.googlegroups .com>, vk************@gmail.com says... 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
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>'.
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!
Gladiator wrote: Gert van der Kooij wrote: In article <11**********************@u72g2000cwu.googlegroups .com>, vk************@gmail.com says... 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
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>'. 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!
Gladiator wrote: Gert van der Kooij wrote: In article <11**********************@u72g2000cwu.googlegroups .com>, vk************@gmail.com says... 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
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>'. thanks gret....
regards kamal
db2dude wrote: 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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
In article <11*********************@g10g2000cwb.googlegroups. com>, ab*******@gmail.com says... 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.
Gert van der Kooij wrote: In article <11*********************@g10g2000cwb.googlegroups. com>, ab*******@gmail.com says... 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..!
Gladiator wrote: Gert van der Kooij wrote: In article <11*********************@g10g2000cwb.googlegroups. com>, ab*******@gmail.com says... 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.... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Robert Ferrell |
last post by:
I have a question about assigning __call__ to an instance to make that
instance callable. I know there has been quite a bit of discussion
about this, and I've read all I can find, but I'm still...
|
by: |
last post by:
Hi
I have a list containing several instance address, for example:
I'd like to invoke a method on each of these instance but I don't know :
1. if its possible
2. how to proceed
|
by: John M. Gabriele |
last post by:
I've done some C++ and Java in the past, and have recently learned
a fair amount of Python. One thing I still really don't get though
is the difference between class methods and instance methods. I...
|
by: Mike |
last post by:
Greetings,
Having a major problem here. running version 8.2 on win2003 server.
The problem I am having is backing up a database seems to get to the
last part of the backup and then fails. This...
|
by: Hemant Shah |
last post by:
Folks,
I need to move HOME directory of an instance to another directory.
What is the best way of doing it?
Is changing password file enough? or dies DB2 store this info in it's own
config?
...
|
by: Dmitry Karneyev |
last post by:
Hi!
I guess this question have been asked a lot of times, but please be tolerant
and if you have any ideas share it.
The question is: how to make availibale only one instance of application and...
|
by: Mesan |
last post by:
Hello everyone,
Thanks to many useful posts in this newsgroup and others, I've been
able to come very close to something I've been wanting to do for a
very long time.
I've figured out how to...
|
by: vijay.db |
last post by:
Hi Team,
Very serious problem with my DB2 V8.1 Fixpack 6 running in AIX 5.1
machine. Every one hour my DB2 instance processes are killed and it's
going down. Several trap files are generated in...
|
by: titan nyquist |
last post by:
I have a class with data and methods that use it. Everything is
contained perfectly
THE PROBLEM: A separate thread has to call a method in the current
instantiation of this class. There is...
|
by: gzeng |
last post by:
I am creating a singleton class in C++. Everything is fine except with the object pointers. I cannot instaniate a regular object. But I can define many pointers *aaaa, *bbbb, etc. to the class and...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |