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...
You can temporarily turn off logging for a table with the statement “ALTER TABLE <tablename> 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...
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...
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...