By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,011 Members | 1,000 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,011 IT Pros & Developers. It's quick & easy.

Recover IBM DB2 Data (Urgent)

P: n/a
Dear all,

We are facing problem with our production server. We have IBM DB2 7.2
running on Windows 2000 Server. Day before OS is crashed and the NT
admin has re-installed the whole OS again on C:\ dirve by formatting.
Luckliy we have DB2 Installation on F:\websphere\sqllib. and data file
are in F:\DB2 and F:\DBCTLSV directory. We have nearly 3 important
database running on this machine.

1. So could you please tell us the procedure to recover the DB2
installation and database file as it is, like before.

2. Otherwise we have backup image of database, How do i restore into
another machine. The backup is offline backup only we have.

I hope above information helps to find the solutions, if not please
mail for more information.

I am really stuck with this. I wanted to do this asap.
Thanks in advance.
Ananth

Mar 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In article <11*********************@p10g2000cwp.googlegroups. com>,
sm**********@gmail.com says...
Dear all,

We are facing problem with our production server. We have IBM DB2 7.2
running on Windows 2000 Server. Day before OS is crashed and the NT
admin has re-installed the whole OS again on C:\ dirve by formatting.
Luckliy we have DB2 Installation on F:\websphere\sqllib. and data file
are in F:\DB2 and F:\DBCTLSV directory. We have nearly 3 important
database running on this machine.


What you need to do is:

- save your user defined stored procedures and types which are in the
sqllib/function/ directory
- remove the f:\websphere\sqllib directory
- install exactly the same level of software in this directory again and
don't create the default DBCTLSV database. AFAIK you only need this
database if you use the DB2 'satellite' software but it will be
recatalog during the following steps
- copy back your saved stored procedures etc.
- list the old databases with the db2 "list db directory on f:" command
- catalog each database with the command db2 "catalog db <dbname> on f:"
- connect to each database so the crash recovery can put your database
in a consistent state
- test the stored procedures. If something went wrong you might need to
recreate them.
- create a new backup of your databases, just to be sure.

Document each step and save the output messages in case you need some
trouble shooting afterwards.
Mar 18 '06 #2

P: n/a
Thanks for the help and support, I will try this out and let you know
when I am done.

Once again Thanks, I got the confident now that I can bring back the
server.

Mar 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.