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…)

Some news of the web

After three “releases candidates” the final version of the excellent XWiki software is avaible to download.

Xwiki is a Wiki Open Source multilingual, entirely written in Java. It offers all the services of a well securisated Wiki and permit an easy developping of the specifique functions (very useful to integrate this in existing applications). This sort of tools permit to develop quickly an entreprise Intranet by adding quite easyly specifique functions.

This new version offers better performans, New users, groups and rights management UI (I didn’t like the previous one), many pluggins anb many other things to see at this link. ici.

In my opinion I find the first contact very simple and quick. I particulary like the panel interface, the flux reader “Xwiki Watch” which is really very powerful and the exportation in RTF or PDF format.

If you don’t already know this tool I invite you to discover it quicky.

the official announcement
the download page.
xwiki.com.

After some rumors, Sun announces an agreement to acquire MySql and Oracle announced that it has entered into an agreement to acquire BEA Systems, Inc.

It will give to Sun a popular database missing from its catalogue and it’s a very good database…

More informations on this news
- http://www.mysql.com/news-and-events/
- http://www.oracle.com/bea/index.html

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…)

Index

• Applet tEurocalc description
• Sample use
• Sample use 2

Description

tEuroCalc is a little Calculator/Converter Applet. Its very small size allows an easy use (14 Ko). tEuroCalc runs on all browsers with support JDK 1.1. With this applet you can make all standard operations (“+”, “-”, “/”, “*”, “%”…) and you can convert european devises in Euro.

Download

tEuroCalc.zip

News

Version 2.00

• Add LiveConnect support for Java< ->Javascript communication
• Add layer sample
• Add greece devise

(more…)