Anyone has done that before please help to follow the correct procedure to do that so it should not break anything.
It will be greatly appreciated.

TIA.

I would create a new instance and then use db2relocatedb to move the database from one instance to another ..

Cheers
Sathyaram

Thanks for prompt reply Sathyaram!

Isn't there any other or shorter way as using db2relocate db needs a longer time to do and we do not have that bigger window to achieve that.

We want to consider all the options.

If you or anyone else have other options and if successfully done before please share your thoughts.

Thanks in Advance again!

Assuming you have enabled archival logging and have enough disk space ,
a) Create new instance
b) Online Backup database on old
c) Restore database on new, but leave rollforward pending
d) Apply logs from old to new continually, leaving the new in pending state
e) Stop the old instance
f) Get the latest logs and apply it on new, and rollforward complete

If you wish the clients to access the database without any changes to their config, then change the SVCENAME of the new instance to same as old ...

HTH
Sathyaram

This 'd be a great help.

Anything without creating second instance ??

Sorry .. just curious..

TIA.

AFAIK, it is not possible