Not logged initially must be forbidden!

You can temporarily turn off logging for a table with the statement “ALTER TABLE ACTIVATE NOT LOGGED INITIALLY“. Do not do this if you are using archival logging; here is why: The ALTER statement will turn off logging for the table until the next commit....

Comparing DB2 10.5 Express-C with its competitors

DB2 Express-C is the free edition of the DB2 for Linux / Unix  / Windows database. Unlike Microsoft and Oracle express offerings, DB2 Express-C does have a huge limit on the size of database! The latest edition (10.5) relaxes its memory restriction by 400%! It will...

Meet zEC12’s little brother: IBM zEnterprise BC12

In August 2012 IBM announced the zEnterprise EC12 mainframe. The zEC12 is the biggest mainframe available from IBM and maybe too big for some customers. For those customers IBM has a new entry-level model. Meet zEC12’s little brother the IBM zEnterprise BC12....

Incremental copies, a false sense of security!

In the DB2 for z/OS Utility manual, you can read that an incremental image copy is a copy of the pages that have changed since the last full or incremental image copy. Incremental copies are faster and produce smaller image copy files. Image Copies play an important...

DB2 11 for z/OS is coming… Here are the features!

UPDATE: IBM made DB2 11 for z/OS ( DB2 11) generally available on October 25, 2013. You can find the announcement letter here. Julian Stuhler and Klaas Brant discuss the new features in Triton’s Confessions of a DB2 Geek podcast. You can find here: part1 and...