I had a hard time finding this on the internet, so I thought I'd post after I found it in a book.
The naming convention for a DB2 file system backup will be:
Alias.Type.Instance.Node.Catalog_Node.MonthHourSecond.Sequence
Example:
MyDB.0.DB2INST.NODE00000.CATN0000.20131015131259.001
↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑
Alias | Instance | Catalog Node | | | | | |
Backup Type Node Year | | | | |
Mon Day | Sec Seq
Min
Reference:
Understanding DB2: Learning Visually with Examples Second Edition
Page 745
14.4.6 The Backup Files
Raul F. Chong (Author), Clara Liu (Author), Sylvia F. Qi (Author), Dwaine R. Snow (Author)
Showing posts with label backup. Show all posts
Showing posts with label backup. Show all posts
Monday, October 14, 2013
Monday, July 08, 2013
backup Db2- unable to force applications
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...
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...
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’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...
-
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...