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:

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