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)
Subscribe to:
Post Comments (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 was not able to find what I considered a good, clear reference for this when I recently encountered it at a customer installation. I fou...
No comments:
Post a Comment