If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > The database is currently in use. SQLSTATE=57019

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Feb 2009
Posts: 1
The database is currently in use. SQLSTATE=57019

We have Windows 2003 Server. I have two instances DB2 and db2ctlsv. Everything was fine until the system crashed and we had to reboot. If I try to select on control center -- we get this message -- The database is currently in use. SQLSTATE=57019

The database in question is "island". Any help is appreciated.

I cannot drop the database and dont know what to do. All I want to do is to restore from backup.

Here is the list database directory

---------------------------------- Script -----------------------------------
Untitled1
-----------------------------------------------------------------------------


System Database Directory



Number of entries in the directory = 4



Database 1 entry:



Database alias = WAS

Database name = WAS

Database drive = D:\DB2

Database release level = 9.00

Comment =

Directory entry type = Indirect

Catalog node number = 0



Database 2 entry:



Database alias = YP

Database name = YP

Node name = DB2PROD

Database release level = 9.00

Comment =

Directory entry type = Remote

Catalog node number = -1



Database 3 entry:



Database alias = ISLAND

Database name = ISLAND

Node name = DB2PROD

Database release level = 9.00

Comment =

Directory entry type = Remote

Catalog node number = -1



Database 4 entry:



Database alias = DWCTRLDB

Database name = DWCTRLDB

Database drive = D:\DB2

Database release level = 9.00

Comment =

Directory entry type = Indirect

Catalog node number = 0
Reply With Quote
  #2 (permalink)  
Old
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,649
T:\>db2 ? SQL1035N

Quote:



SQL1035N The database is currently in use.
Explanation:
One of the following conditions exists:
o Exclusive use was requested, but the database is already in
use as a shared database by another user (in the same
process).
o Exclusive use was requested, but the database is already in
use as an exclusive database. (Two different processes are
trying to access the same database.)
o The maximum number of connections to the database has been
reached.
o The database is being used by another user on another
system.
o Activate/Deactivate database is in progress.

The command cannot be processed.
User Response:
Possible solutions include:
o Resubmit the command later when the database is not in use.
o Change the authorization to match the current user or wait
until the database is not in use.
o Wait until the database is not in exclusive use.
o Wait until other users on another system have disconnected
from the database.

sqlcode : -1035
sqlstate : 57019
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Apr 2013
Posts: 1
you can try: "force applications all"
after that "drop database dbname"

It may Helpful
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On