Hi,
I have recently removed a database from DB2 .
I had deleted a database in the past, but now when I go to recreate
it, I'm getting the message
"The database alias ___ already exists in either the local database
directory or system database directory"
I have checked the database, I have cataloged and uncataloged, and
when I list out the directories, the alias does not appear. But when I
try to recreate it, I get this message.
How do I locate the database alias and rename/remove it, once and for
all?
Thanks
Rajni
1 2126
Hi,
I have recently removed a database from DB2 .
I had deleted a database in the past, but now when I go to recreate
it, I'm getting the message
"The database alias ___ already exists in either the local database
directory or system database directory"
I have checked the database, I have cataloged and uncataloged, and
when I list out the directories, the alias does not appear. But when I
try to recreate it, I get this message.
How do I locate the database alias and rename/remove it, once and for
all?
Thanks
Rajni
Use the CLP (command line processor) to connect to the DB2 system, catalog the database (if not already done) and the drop it; then you should be done.
It seems that dropping the database from the command-center (gui tools) does not delete it from the disk while doing it from clp or using the command-line tools is okay.
hope it helps
Sign in to post your reply or Sign up for a free account.
Similar topics
by: besbello |
last post by:
Hi all,
I want to submit a form when the user closes the browser, to keep a
count of the number of users accesing my application at each moment. To
do this, I use the onbeforeunload() event, that...
|
by: Kay Stoner |
last post by:
Greetings -
I have recently uninstalled DB2 7 and re-installed it.
I had deleted a database in the past, but now when I go to recreate
it, I'm getting the message
"The database alias ___ already...
|
by: Themis Papassilekas |
last post by:
So, I don't know how tricky this is, but thought I'd ask...
Here in the office there's an inventory db that was written in Access 2.0.
Nobody cared to upgrade it since its creation back in an era...
|
by: noone |
last post by:
I have a database file that I use an autonumber field as the primary key
index. Because of some rearrangements in the past, this index does not match
the order that I would like it to be in, that...
|
by: u7djo |
last post by:
Hi,
I'm currently building an application in Access and as part of this
need to import forms and modules from another database. Some of the
imports will be revisions of existing forms/modules so I...
|
by: Alan Silver |
last post by:
Hello,
This is NOT a troll, it's a genuine question. Please read right
through to see why.
I have been using Vusual Basic and Classic ASP for some years, and
have now started looking at...
|
by: Susan Mackay |
last post by:
I have a data table that is connected to a database table with a data
adapter in the 'standard' manner.
However I want to be able to remove selected rows from the data table (i.e.
no longer...
|
by: Viator |
last post by:
Hi folks,
I have a basic question. When I do object-oriented programming
using C++ or Java, all my objects reside in RAM. I do not have
to think about storing and retrieving them, because they...
|
by: cellus205 |
last post by:
Hows it going everyone. Im still pretty new to vb .net, and am having a little trouble. I am loading a tab delimited txt file into an access database, and parsing the text to extract some of the...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
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,...
|
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...
|
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,...
| |