Dropping Nicknames

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Asphalt Blazer - 07 Jul 2006 17:02 GMT

Hi,
This problem seems to be trivial but yeah its happening to me.
I am trying to drop a nickname
db2 "drop nickname <schemaname>.<tablename>"

after I execute the command, the cursor just hangs there. Nothing
happens. Can anybody let me know what I am doing wrong.

Reply to this Message

Serge Rielau - 07 Jul 2006 19:37 GMT

> Hi,
> This problem seems to be trivial but yeah its happening to me.
[quoted text clipped - 3 lines]
> after I execute the command, the cursor just hangs there. Nothing
> happens. Can anybody let me know what I am doing wrong.

Maybe the nickname is in use by another connection?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Asphalt Blazer - 09 Jul 2006 16:23 GMT

Nope. this is a new machine. Nobody else is using it right now.

> > Hi,
> > This problem seems to be trivial but yeah its happening to me.
[quoted text clipped - 16 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Serge Rielau - 09 Jul 2006 17:36 GMT

> Nope. this is a new machine. Nobody else is using it right now.

Then I would open a PMR.

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message