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 DB2 Backup Naming Convention. Show all posts
Showing posts with label DB2 Backup Naming Convention. Show all posts
Monday, October 14, 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’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...