Useful SQL*Plus headers
Dino eats frog
Oracle with Active Record
When is he free?
Gentle dive into analytic functions
« Wings of Fire
» No spin; or only spin?
IBM dW has an excellent article:
If you’re a database specialist interested in growing your DB2 Universal Database skills, there’s a good chance that you’ve already developed database skills with another relational database product somewhere along the way. This article shows you how to use your current knowledge of Oracle 9i to quickly gain skills in DB2 UDB for Linux, UNIX, and Windows Version 8.
Very concise summary. Definitely worth a bookmark.
If you have a choice I strongly recommend sticking with Oracle and avoiding DB2 like the plague. Why? Because DB2 release 8 has a similar feature set to Oracle 6.
Want to change the precision of a column? You cant. Want to rename a table? Forget it. Change the data type of a column? No. Make a not null column nullable? Nope. Want to administer more than one database? DB2 Control Center is one of the worst Java applications it has been my displeasure to use, it actually manages to use up all of the free memory on my work machine.
http://www.halfcooked.com/mt/archives/000507.html
Oh, and the locking policies are a nightmare, we regularly get full table locks in our production system and are having to re-architect the system to avoid them.
I could go on but you'd start to think I was bitter. I really wanted to like DB2 because everyone I asked had told me what a great database it was. After a year or so of using it I have to say that it is stable and performant but that it requires at least twice the amount of effort during the development phase of a project than Oracle or SQL Server.
that was very useful! thanks!