When trying to backup a db on db2 LUW 9.5, I get the following message, even after running quiesce.
SQL1035N The database is currently in use. SQLSTATE=57019
There is some good advice involving authority here: http://www.dbforums.com/db2/1663529-backup-db2-unable-force-applications.html#post6596923
However, it did not apply to my situation.
In desperation, I decided to just restart the instance.
When I did, I got an error indicating invalid credentials.
I had to go into the Windows Service and change the password for the user.
That cleared up the issue.
Whaddya know...
Monday, July 08, 2013
Subscribe to:
Posts (Atom)
The Database is not accessible after creating Always On Availability Group
Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
BibleGateway.com - Passage Lookup: John 10:7, 9-10 9I am the gate; whoever enters through me will be saved.[a] He will come in and go out, a...
-
I spent a lot of time on this one, and it wasn't clear from examples precisely how the various items should be used together. The form...