Playing With CLPPLUS

I’ve played with the clpplus at least once before, but have generally thought of it as a tool created to satisfy those coming from Oracle and looking for Oracle-like features. One of the features I actually liked about Oracle in the class and certification tests that I took for it was the ability to specify values for an SQL statement stored in a file on execution.… Read the rest

Continue reading »

DB2 LUW – What is a Page?

The logical view of a database consists of the standard objects in any RDBMS – Tables, Indexes, etc. There are a number of layers of abstraction between this and the physical hardware level, both in the OS and within DB2.

Setting the Page Size

The smallest unit of I/O that DB2 can handle is a page.… Read the rest

Continue reading »

The early history of databases and DB2

So I debated about even writing this post. But the truth is that I find database history fascinating. I’m sure this post has nothing on the Wikipedia article, but I’m going to give it a go anyway. Note that this is my own sometimes unsupported view of database history and may include inaccuracies

The early history of databases

As a DB2 DBA and a former IBMer, I’m biased towards IBM’s history of datbases – in which IBM seems to claim that IBM developed the first computer database either for American Airlines in 1962 (SABRE) or for the moon mission (see http://www.dbisoftware.com/db2nightshow/20110425-Z01-roger-miller.pdf) in 1964.… Read the rest

Continue reading »

Oracle’s SCN Flaw – could it happen in DB2?

I read an article on a flaw in Oracle that was recently discovered. It had to do with the SCN number that is constantly increasing in any database:

http://www.infoworld.com/d/security/fundamental-oracle-flaw-revealed-184163-0

Thanks to my friend Fitz for bringing it to my attention – and you really should read all 6 pages of that article – it is fascinating for a database geek.… Read the rest

Continue reading »

Commerce Database Facts

So these are miscellaneous things that I sometimes note about Commerce databases. Though some of the details here may reference DB2, the basic facts are RDBMS-independent, so they would be true for Oracle Commerce databases as well as DB2 ones.

Most tables have generated primary keys

Commerce tends to use sequential numbers for most primary keys, or as a component of a composite primary key.… Read the rest

Continue reading »

DB2 vs. Oracle – handling dates

So as I may have mentioned before, I’m learning Oracle. I’ve always been a DB2 DBA, having started out as strictly a Physical/Systems DBA. Thus SQL is a skill I’ve built very slowly, over time. I thought the hardest test for DB2 certification was the ‘Family Fundamentals’ one, because it focused so heavily on SQL and other things I didn’t do day-in and day-out at the time.… Read the rest

Continue reading »