473,549 Members | 2,679 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

cataloging database after unistalling -> installing db2

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
Nov 12 '05 #1
2 2267
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


Nov 12 '05 #2
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" <ps******@ameri tech.net> wrote in message
news:<E5******* *************** @newssvr28.news .prodigy.com>.. .
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


Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3189
by: Monica Roman | last post by:
Hello, Disclaimer: I'm a TOTAL rookie. I just went through unistalling Oracle to be able to install Discoverer, which was succesful. (Our in-house Oracle support person said that if I did the Oracle_home renaming workaround, Oracle would not support it.) Now I just tried re-installing Oracle 9i and I encountered the same problem: it...
5
8660
by: Pongthai | last post by:
Hi, I got a backup file from my friend which needs 11 GB to hold the transaction log. I tried to restore this database but an error message: "MODIFY FILE encountered operating system error 112(error not found) while attempting to expand the physical file." appeared. The free space is more than enough. I then tried another way
5
5400
by: Ricardo Silva | last post by:
I have a DB2 v8.1 FP4 instances that have been running fine on an AIX server for quite some time. I installed FP7a, but for some reason when I do a "db2 list db directory" on the server as the instance id, I am getting the following error for all the FP4a instances. SQL10004C An I/O error occurred while accessing the database directory....
1
5952
by: pintur | last post by:
The message is: SQL1036C Errore di I/O durante l' accesso al database. SQLSTATE=58030 what is the proble? what for restore tables? thanks
3
22915
by: Michael S | last post by:
only my server get the report whitout the dialogue database login. I think it is where the database is localhost and the crystal report know not the connection string. how I can crystal reports say where the database is? Have anywhere a idee how a can fix this? thank you
2
1121
by: Prisy | last post by:
While i save a record the database stores the character > as it's html equivalent which is >. But when i update that record it saves the character as > itself. Why would this happen? -- Thanks Prisy
0
2123
by: viepia | last post by:
Hi, My project writes records to a new SQL Server 2005 database with currently 18 tables. When I change the Database Diagram for my database I save the copy the list of changed tables to a notepad text file; then one at a time I delete the changed tables from my DBML Diagram and drag a replacement from the Server Explorer Table list....
0
1512
by: GetgoodV | last post by:
Hi all, I wonder if anybody can help with a problem I have accessing (caaloging) databases on my network (drive V) I have installed DB2 V8 on Windows XP: - ========================================================= About DB2 Administration Tools Environment ========================================================= DB2 administration tools...
0
1114
by: Massimiliano Campagnoli | last post by:
We are using an unsupported configuration: DB2 V7.2 WSE fixpak 14 for OS/2 WARP. Several database applications written in VisualAge C++ with Data Access Builder (DAX) We have discovered this very strange behaviour: Many of the c++ applications traps while accessing the remote production database via TCP from a machine where there is...
0
7521
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7451
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7959
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7810
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6044
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5369
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3483
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1061
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
764
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.