DavidYahalom.com is an IT knowledgebase dedicated to the world of databses and RDBMS systems by David Yahalom. Here you'll find articles, views, news, tips and in-depth analysis about Oracle, DB2 LUW, Sql Server and MySql. I hope you'll enjoy your stay.

28th
JAN

Understanding DB2 backup filenames

Posted by David Yahalom under DB2 LUW

[Digg] [Facebook] [Google] [Reddit] [Slashdot] [StumbleUpon]

When backing up a db2 database the output filename might be confusing at first.
The filename generated by the backup utility might seem long an confusing but it is actually pretty straight forward and very informative.

For example, if I issued the following command:

db2 backup database dbone to /storage/backup_path/

I might get a file named:

DBONE.0.DB2INST1.NODE0000.CATN0000.20070101140000.001

So, what does all the numbers mean?

On UNIX/LINUX:

DBONE.0.DB2INST1.NODE0000.CATN0000.20070101140000.001
(1)-----(2)---(3)---------(4)---------(5)-------------(6)-----------(7)

On Windows:

DBONE.0DB2INST1NODE0000CATN000020070101140000.01
(1)-----(2)----(3)---------(4)----------(5)---------------(6)--------(7)

1) Database alias
2) Backup type.
3) Instance name
5) Database Partition (always NODE0000 for a non-partitioned database).
5) Catalog partition number (always CATN0000 for a non-partitioned database).
6) Date&time of when the backup file was taken.
7) Time image sequence number.

Leave a Reply

DavidYahalom.com - Oracle, Databases, SQL, news, views, articles and in-depth analysis is powered by Wordpress. Designed by Free WordPress Themes.