473,473 Members | 1,831 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Remove database aliases

Hi,
I have a DB2 8.2 client installed and I have created multiple database
aliases using ODBC wizard. I am now trying to figure out how to remove
these aliases. I tried removing data source, however alias does not
get removed. I don't have any gui tools for db2 installed - only db2
client with bunch of command line utilities. Any help/hint would be
greatly appreciated.

thanks

Andrey

PS. I am not savvy with DB2, so a more detailed explanation vs. short
sentence would be great.

Nov 12 '05 #1
2 47101
Andrey wrote:
Hi,
I have a DB2 8.2 client installed and I have created multiple database
aliases using ODBC wizard. I am now trying to figure out how to remove
these aliases. I tried removing data source, however alias does not
get removed. I don't have any gui tools for db2 installed - only db2
client with bunch of command line utilities. Any help/hint would be
greatly appreciated.

PS. I am not savvy with DB2, so a more detailed explanation vs. short
sentence would be great.


db2 uncatalog db <db-alias>

(If you are running on Windows, then you should start a DB2 command window
first.)

The long explanation can be found here:
http://publib.boulder.ibm.com/infoce...e/r0001984.htm

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2
Thanks, this is exactly what I needed

Andrey

Knut Stolze wrote:
Andrey wrote:
Hi,
I have a DB2 8.2 client installed and I have created multiple database aliases using ODBC wizard. I am now trying to figure out how to remove these aliases. I tried removing data source, however alias does not get removed. I don't have any gui tools for db2 installed - only db2 client with bunch of command line utilities. Any help/hint would be greatly appreciated.

PS. I am not savvy with DB2, so a more detailed explanation vs. short sentence would be great.
db2 uncatalog db <db-alias>

(If you are running on Windows, then you should start a DB2 command

window first.)

The long explanation can be found here:
http://publib.boulder.ibm.com/infoce...e/r0001984.htm
--
Knut Stolze
Information Integration
IBM Germany / University of Jena


Nov 12 '05 #3

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

Similar topics

1
by: Roger | last post by:
Hello all Haven't worked with Crystal since the VB 4 days. Now for the first time I'm trying to create a report in a .net/vb project using SQL 2000 for the Database. When I add the Crystal...
5
by: Kevin | last post by:
I'm making my first attempt to put embedded SQL in a visual C++ application and I'm having trouble getting aliases to work. If I try the following SQL query on MS SQL 7.0 it works fine. SELECT...
2
by: gdabbara | last post by:
Hi, We have a situation where we want to move our current database server to a different hardware and rename the server. If we change the Physical server name, do we have to go thru the whole...
1
by: Yanik Reid | last post by:
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the...
2
by: JP SIngh | last post by:
Hi All We are creating a multi-region ASP application which will be using SQL Server 2000. As our users exist in multiple location i.e. UK, US, Australia how can we distinguish that the date...
6
by: Jeff Gardner | last post by:
Greetings: Is there a way to do <snip>SELECT table.* AS alias.*</snip>, or do I have to write additional code to automate the process? -- Regards, Jeff Gardner ___________________________
2
by: Martin Douglas | last post by:
Using VS2005, Win32 projects expose on the properties of a reference the "Aliases" property, which defaults to "global" for a value. Here one can define in comma-delimitted format a list of...
2
by: Laurence | last post by:
Hi folks, I installed DB2 V9.1 FP2 on RHEL AS V4 (DB2 Server) and Win XP SP2 (DB2 Client). The strange thing, there were two database aliases TOOLS0 & TOOLS1 in the DB2 Client that were...
6
by: dom.k.black | last post by:
Is it still common practice to use type aliases (INT, PCHAR etc). It looks ugly and breaks the syntax highlighting, are there any advantages these days (MSVC++6.0 and later)? I could understand...
0
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,...
0
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...
0
Oralloy
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,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
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,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
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...
0
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 ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.