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...
Showing posts with label force. Show all posts
Showing posts with label force. Show all posts
Monday, July 08, 2013
Subscribe to:
Posts (Atom)
Get Restart log using PowerShell
I'm often curious about a restart on a Windows server system. An easy way to get a list of the restart and what initiated it is to use t...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
I'm often curious about a restart on a Windows server system. An easy way to get a list of the restart and what initiated it is to use t...
-
I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...