Monday, October 14, 2013

DB2 Backup Naming convention

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 Clara Liu Sylvia F. Qi Dwaine R. Snow 

No comments:

DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)

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...