Remove database aliases

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Andrey

    #1

    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.

  • Knut Stolze

    #2
    Re: Remove database aliases

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

    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:


    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena

    Comment

    • Andrey

      #3
      Re: Remove database aliases

      Thanks, this is exactly what I needed

      Andrey

      Knut Stolze wrote:[color=blue]
      > Andrey wrote:
      >[color=green]
      > > Hi,
      > > I have a DB2 8.2 client installed and I have created multiple[/color][/color]
      database[color=blue][color=green]
      > > aliases using ODBC wizard. I am now trying to figure out how to[/color][/color]
      remove[color=blue][color=green]
      > > these aliases. I tried removing data source, however alias does[/color][/color]
      not[color=blue][color=green]
      > > get removed. I don't have any gui tools for db2 installed - only[/color][/color]
      db2[color=blue][color=green]
      > > client with bunch of command line utilities. Any help/hint would[/color][/color]
      be[color=blue][color=green]
      > > greatly appreciated.
      > >
      > > PS. I am not savvy with DB2, so a more detailed explanation vs.[/color][/color]
      short[color=blue][color=green]
      > > sentence would be great.[/color]
      >
      > db2 uncatalog db <db-alias>
      >
      > (If you are running on Windows, then you should start a DB2 command[/color]
      window[color=blue]
      > first.)
      >
      > The long explanation can be found here:
      >[/color]
      http://publib.boulder.ibm.com/infoce...e/r0001984.htm[color=blue]
      >
      > --
      > Knut Stolze
      > Information Integration
      > IBM Germany / University of Jena[/color]

      Comment

      Working...