A relatively simple approach is:
1. Create another instance matching the old, not in use, instance name
2. Using tihs secondary instance; catalog the database
3. Back up the database
4. Restore the database backup to the "new" instance owner
Of couse, being a farsighted administrator; you DID backup the database
before uninstalling. You can skip steps 1-3 above and just do step 4
with your existing backup.
Directly cataloging the original database to a new instance owner is
difficult because:
1. The old database's location does not match the location that is used
for storing the new instance's databases.
2. Ownership of the databases physical datasets should also be an issue
especially on Unix-like systems.
Jagdip Singh wrote:
Hi all,
I uninstalled db2 without dropping old instance. I have one database which i
want to access again through new db2 i installed.
I opted for fresh db2 directory while installing instead keeping old
directory.
I created new instance during installation of db2 which is different from
old one.
I tried catalog database for old database from new instance but did not able
to access database
Is there any one who has similar problem, can help me?
Warm regards,
Jagdip Singh