Recover IBM DB2 Data (Urgent)

[Anantha]

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

[Gert van der Kooij]

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.

[Anantha]

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.