Comparing Db2 free edition with its competitors
Db2 Community Edition is the free edition of the Db2 for Linux / Unix / Windows database. Unlike Microsoft and Oracle express offerings, Db2 Community Edition does allow for a unlimited size database (was 100GB in the past) and can use up to 16GB of memory and with...
Not logged initially must be forbidden!
You can temporarily turn off logging for a table with the statement “ALTER TABLE
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 10 and SMS
SMS stands for System Managed Storage, short for Data Facility Storage Management Subsystem (DFSMS), which is an integral part of z/OS . SMS is composed of a set of components designed to make disk storage management easier and more efficient. SMS has many benefits...
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 part2. On...
Hot Tip #2 – Remote Desktop Manager to manage all your DB2 server connections
How to manage your remote connections easily
FREE DB2 SQL Cookbook
Did you end up here because you found out that Graeme Birchall's website is shutdown and you want the free SQL Cookbook? Keep reading, we still have it! Graeme Birchall is the author of the free DB2 SQL Cookbook which has been extremely popular, but now his website is...
DB2 Handling -805 on SYSLH2 packages
Did you ever encounter a SQLCODE -805 (SQLSTATE 51002) in a distributed dynamic SQL environment? A bit strange because the SQLCODE -805 says DBRM or package not found in plan, but we are dealing with dynamic SQL. Here is what happened...It all started with an email...