cataloging database after unistalling -> installing db2

[Jagdip Singh]

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

[Phil Sherman]

Re: cataloging database after unistalling -> installing db2

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:[color=blue]
> 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
>
>[/color]

[Jagdip Singh]

Re: cataloging database after unistalling -> installing db2

Hi,
I created instance with same name as old as old instance was not existing

It is listening on same port where old instance was listening( I edited
/etc/services) file

I tried db2 list db directory on /usr/tsample as old database was created
there

I tried cataloging from new instance using catalog db tsample on
/usr/tsample

And tried connecting to tsample

It gave me error SQL5005C System Error.

I really do not know what it could be

Regards,

Jagdip

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