SQL1428N The application is already attached to "DB2INST1" while the command issued requires an attachment to "LHOST0" for successful execution

Have you ever faced this issue while running drop database ???
SQL1428N  The application is already attached to "DB2INST1" while the command
issued requires an attachment to "LHOST0" for successful execution
db2 => drop database IBMCDB
SQL1428N  The application is already attached to "DB2INST1" while the command
issued requires an attachment to "LHOST0" for successful execution.
db2 => list db directory
 System Database Directory
 Number of entries in the directory = 1
Database 1 entry:
 Database alias                       = IBMCDB
 Database name                        = IBMCDB0
 Node name                            = LHOST0
 Database release level               = c.00
 Comment                              =
 Directory entry type                 = Remote
 Catalog database partition number    = -1
 Alternate server hostname            =
 Alternate server port number         =
db2 => drop database IBMCDB
SQL1428N  The application is already attached to "DB2INST1" while the command
issued requires an attachment to "LHOST0" for successful execution.
db2 => uncatalog db IBMCDB
DB20000I  The UNCATALOG DATABASE command completed successfully.
DB21056W  Directory changes may not be effective until the directory cache is
refreshed.
db2 => list db directory
SQL1057W  The system database directory is empty.  SQLSTATE=01606
Hope this solved your issue :))


0 comments to "SQL1428N The application is already attached to "DB2INST1" while the command issued requires an attachment to "LHOST0" for successful execution"

Post a comment

Whoever writes Inappropriate/Vulgar comments to context, generally want to be anonymous …So I hope U r not the one like that?
For lazy logs, u can at least use Name/URL option which doesn’t even require any sign-in, The good thing is that it can accept your lovely nick name also and the URL is not mandatory too.
Thanks for your patience
~Krishna(I love "Transparency")

Popular Posts

Enter your email address:

Buffs ...

Tags


Powered by WidgetsForFree

Archives