ubable to drop database

chakribobby · #1 (**permalink**) 10-04-07, 01:10

hi,
While deleting the db2 database I got this error

bash-3.1$ db2 drop database TC
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.0.3.4". Communication function
detecting the error: "connect". Protocol specific error code(s): "239", "*",
"*". SQLSTATE=08001

Any ideas on what I missed
Thanks in advance

meehange · #2 (**permalink**) 10-04-07, 01:56

Is the database catalogued? Can you connect to it?
Is the instance started?
try a db2start

chakribobby · #3 (**permalink**) 10-04-07, 06:12

thanks for u reply
I am new to db2
Can u explain in brief

bash-3.1$ db2start
10/04/2007 15:42:36 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.

bash-3.1$ db2 drop database TC
SQL30082N Attempt to establish connection failed with security reason "3"
("PASSWORD MISSING"). SQLSTATE=08001

sundaram · #4 (**permalink**) 10-04-07, 18:29

try

db2 drop database TC user myUser using myPassword

Regards

Harikumar

chakribobby · #5 (**permalink**) 10-05-07, 00:11

hi,
now i am got this problem

bash-3.1$ db2 drop database TC
SQL1428N The application is already attached to "DB2INST1" while the command
issued requires an attachment to "TC" for successful execution.

stolze · #6 (**permalink**) 10-05-07, 02:29

Quote:

Originally Posted by sundaram

db2 drop database TC user myUser using myPassword

The DROP DATABASE command doesn't support this syntax. What is needed is an attachment to the instance in which the database resides, i.e.:

Code:

$ db2 attach to <instance>

stolze · #7 (**permalink**) 10-05-07, 02:30

Quote:

Originally Posted by chakribobby

$ db2 drop database TC
SQL1428N The application is already attached to "DB2INST1" while the command
issued requires an attachment to "TC" for successful execution.

What's the output of:

Code:

$ db2 list db directory

chakribobby · #8 (**permalink**) 10-05-07, 05:25

bash-3.1$ db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = TC
Database name = TIOINTER
Node name = TC
Database release level = a.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

stolze · #9 (**permalink**) 10-05-07, 05:31

Do you want to drop the database named TIOINTER that resides at node TC (which is a different DB2 instance), or do you just want to remove the local alias? In the first case, attach to instance TC with the proper credentials and drop the database there. In both cases, you should run the following DB2 command:

Code: