by Klaas Brant | Jan 21, 2015 | DB2 LUW
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...
by Klaas Brant | Sep 27, 2013 | DB2 LUW
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...
by Klaas Brant | Jul 15, 2011 | DB2 LUW
“Single sign-on” is a dream that for many for us is impossible. Servers, servers and more servers is what we are facing nowadays. And single sign-on is simply not possible because… There are many reasons why this is not possible. Most of them are...
by Klaas Brant | Jun 25, 2011 | DB2 LUW
In our day to day job the use of internet is nowadays permitted in the larger companies. Software vendors store their manuals, white papers and software updates online so you can easily download it. There are two potential “problems” with downloading...
by Klaas Brant | Nov 18, 2010 | DB2 LUW, DB2 z/OS
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...
by Cristian Molaro | Aug 7, 2010 | DB2 LUW, DB2 z/OS
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...
