I created 2 remote instances of administration client, then I right
clicked on one of the instance and first dropped it, then removed it.
I thought that only that instance of the admin client would be gone,
but looks like this removed the database itself from the control
center. I have not deleted the sql000 directory, -- is there ANY way I
can get the database back to the control center? Thank you SO... very
much -- I don't have a recent backup and I don't know how to even
start creating the database again from scratch! HELP PLEASE! 5 2763
re-create the dropped instance and then just catalog the db again...perhaps
aou like to use command line interface for this so you don't have any hassel
with probably unclear control center procedere...
look for "db2 ? catalog node" and "db2 ? catalog db"
good luck
aka
"sea" <se*****@hotmai l.com> schrieb im Newsbeitrag
news:f8******** *************** ***@posting.goo gle.com... I created 2 remote instances of administration client, then I right clicked on one of the instance and first dropped it, then removed it. I thought that only that instance of the admin client would be gone, but looks like this removed the database itself from the control center. I have not deleted the sql000 directory, -- is there ANY way I can get the database back to the control center? Thank you SO... very much -- I don't have a recent backup and I don't know how to even start creating the database again from scratch! HELP PLEASE!
I gather from your post that you accidentaly deleted an instance from
your Control Center, or worse dropped it.
If you dropped it, don't worry the db itself is still there.
You need to remember the drive (on Windows) or the path (on UNIX) where
the db was created.
YOu now have only one instance left so on a command line do:
db2 catalog db <nameofdb> on <drive or path>
db2 terminate
db2 connect to <nameofdb>
Things should work now.
HTH, Pierre.
sea wrote: I created 2 remote instances of administration client, then I right clicked on one of the instance and first dropped it, then removed it. I thought that only that instance of the admin client would be gone, but looks like this removed the database itself from the control center. I have not deleted the sql000 directory, -- is there ANY way I can get the database back to the control center? Thank you SO... very much -- I don't have a recent backup and I don't know how to even start creating the database again from scratch! HELP PLEASE!
--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Thank you very much for your reply -- sorry but how do I re-create the
dropped instance? I will try db2 catalog node and db2 catalog db...
"aka" <ak*@aka-soft.de> wrote in message news:<c8******* ***@online.de>. .. re-create the dropped instance and then just catalog the db again...perhaps aou like to use command line interface for this so you don't have any hassel with probably unclear control center procedere...
look for "db2 ? catalog node" and "db2 ? catalog db"
good luck aka
"sea" <se*****@hotmai l.com> schrieb im Newsbeitrag news:f8******** *************** ***@posting.goo gle.com... I created 2 remote instances of administration client, then I right clicked on one of the instance and first dropped it, then removed it. I thought that only that instance of the admin client would be gone, but looks like this removed the database itself from the control center. I have not deleted the sql000 directory, -- is there ANY way I can get the database back to the control center? Thank you SO... very much -- I don't have a recent backup and I don't know how to even start creating the database again from scratch! HELP PLEASE!
The command to create an instance is db2icrt
sea wrote: I created 2 remote instances of administration client, then I right clicked on one of the instance and first dropped it, then removed it. I thought that only that instance of the admin client would be gone, but looks like this removed the database itself from the control center. I have not deleted the sql000 directory, -- is there ANY way I can get the database back to the control center? Thank you SO... very much -- I don't have a recent backup and I don't know how to even start creating the database again from scratch! HELP PLEASE!
Thank you very much for helping find solutions to my (stupidly
created) problems! I realized that I had actually dropped the database
which meant that all related folders etc were gone. So I had to
recreate the database which I was able to do from an old backup after
long hours of hard work - will be very careful before I use the drop
command the next time!
=============== =======
Blair Adamache <ba*******@2muc hspam.yahoo.com > wrote in message news:<c8******* ***@hanover.tor olab.ibm.com>.. . The command to create an instance is db2icrt
sea wrote: I created 2 remote instances of administration client, then I right clicked on one of the instance and first dropped it, then removed it. I thought that only that instance of the admin client would be gone, but looks like this removed the database itself from the control center. I have not deleted the sql000 directory, -- is there ANY way I can get the database back to the control center? Thank you SO... very much -- I don't have a recent backup and I don't know how to even start creating the database again from scratch! HELP PLEASE! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Gilles T. |
last post by:
How I can get element ID in the edit mode of datagrid control?
If I not in the edit mode, there are no problem.
<asp:TemplateColumn ItemStyle-CssClass="grid_column_width_3"
ItemStyle-HorizontalAlign="center" ItemStyle-VerticalAlign="top">
<ItemTemplate><%#
CType(Container.DataItem("DateStatut"),DateTime).ToString("yyyy-MM-dd")...
|
by: Franco Lombardo |
last post by:
Hi all,
I'm running DB2 8.1.5 on Windows 2000 professional SP4.
When I try to start Control Center, I see the splash
screen for a while, then it closes and nothing else happens.
It happens with "Activity center" (Since I'm running the
italian version, I don't know the
english name of this tool, I mean db2tc.bat).
|
by: trinitypete |
last post by:
Hi all,
I have a user control that uses control literal to build
a heading with a link, and a div containing links below.
As the link heading is hit, I want to change the style of
the div, making it visible or not. Yep you guessed it,
expanding tree type functionality.
The header has an onclick event onclick='Doexpandcollapse
|
by: bienwell |
last post by:
Hi,
I have a problem of displaying data bound by a datalist control. In my
table, I have a field Start_date which has Short Date data type. I tried to
update this field by Current Date. After that, I display End_Date on the
DataList control. The output looks like 3/18/2005 12:00:00 AM . I'd
like to format data for this field to be...
|
by: Hoku |
last post by:
I am using dual monitors on a dual head ATI AGP4x video card. I installed the
Nov 11 2005 release of ATI's catalyst control center with Hydravision to
manage the dual monitor setup. I recently updated to .NET v2 and run Zone
Alarm Internet Sec Suite 2006 for firewall and av.
When I log off/shut down the computer a dialog box appears as...
| |
by: gsb58 |
last post by:
Hi!
On a form I have a calendar. The form is rezised to 1024x768 (Don't
worry - this is a training case) when loaded.
Now I want to center the calendar on the form so that its edges are
equally far from the upper, right, left and bottom borders of the form.
I understand I must use the location property, am I right?
|
by: scoffer |
last post by:
Hi all,
I have a problem when I try to open the tables list on a database.
I work with 8.2.0 Enterprise Edition.
The control center return this error:
SQL0104N E' stato trovato un token "SELECT
TabSchema, Tabname, Type, T" non previsto dopo "BEGIN-OF-STATEMENT". I token
previsti possono comprendere: "<query_expr_top>". SQLSTATE=42601
|
by: ehchn1 |
last post by:
Hi,
I had accidentally removed an active transaction log file.
After doing so, my database cannot be started (db2start).
Is there a way to make my database start again?
Please advise.
|
by: Ken Fine |
last post by:
I want to add the security question and answer security feature to the
ChangePassword control. I am aware that this functionality is built into the
PasswordRecovery tool. I have implemented the PasswordRecovery with a
Password reset required; a temporary password is sent to the account on
file. I want an extra layer of security to accommodate...
|
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...
|
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...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
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...
|
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...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |