I have worked in the informatic for over twenty years and during all these years I have used many different data bases (relational, hierarchic, or network).
So I have followed the evolution and sometimes the disparitions of these data bases.
Today I am still surprised of teh small place that DB2 occupy on the open Systems, and I give you in this article my opinion on this lateness.

First I would say DB2 has no problem on the Open Systems :

• Performances : very good
• Price : Competitive except of course in front of OpenSource
• Functionality : Good security
• Evolution : Regular version of the product

(more…)

DB2 Backup Script

After my news about DB2 backup script under Windows, I give you in this small article a solution to do the same thing under Linux.

To Backup a database this IBM/DB2 gives you a graphic interface quite simple to use “Control-Center”, but if you want you include this backup in a batch script you must write a backup script without GUI.

In this new I explain how to write a windows script procedure (.bat or .cmd) to backup your DB2 database.

In this sample I considered that you must close your database before backup ( It’s possible to do this in “ONLINE” mode but it’s more complexe — include log file, rollforward…–) and I use a database SAMPLE (it is his name) for this test .

the goal of this scripts is to :

• Quiesce database (close)
• Backup your data
• UnQuiesce database (open)
• Zip backup file
• Clean/Delete old backup rows in DB2 catalogue
• Delete old backup files

(more…)

DB2 Backup Script

A database is very usefull but it’s always important to backup very often your data. To do this IBM/DB2 gives you a graphic interface quite simple to use “Control-Center”, but if you want you include this backup in a batch script you must write a backup script without GUI.

In this new I explain how to write a windows script procedure (.bat or .cmd) to backup your DB2 database.

In this sample I considered that you must close your database before backup ( It’s possible to do this in “ONLINE” mode but it’s more complexe — include log file, rollforward…–) and I use a database SAMPLE (it is his name) for this test .

the goal of this scripts is to :

• Quiesce database (close)
• Backup your data
• UnQuiesce database (open)
• Zip backup file
• Clean/Delete old backup rows in DB2 catalogue
• Delete old backup files

(more…)