Not logged initially must be forbidden!
You can temporarily turn off logging for a table with the statement “ALTER TABLE
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...
read moreMeet 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. The...
read moreIncremental 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...
read moreDB2 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...
read moreDB2 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...
read moreIBM announces a new mainframe model: IBM zEnterprise EC12
It is already two years ago that the top mainframe model z196 was introduced by IBM. On August 28, 2012, IBM announced a new mainframe model called the IBM zEnterprise EC12 (in short zEC12). This new model can have up to 120 six-core CPU’s inside running at 5.5 GHz. ...
read moreHot Tip #3 – DB2 10 (z/OS) IBM white papers – Free Download
Are you planning for DB2 10 on the mainframe? Then IBM has some excellent white papers available for you! You will find everything you need to cost justify the upgrade or explain what is new and useful for your company. They have the following pdf documents available...
read moreHot Tip #2 – Remote Desktop Manager to manage all your DB2 server connections
How to manage your remote connections easily
read moreHot Tip #1 – Simplify and Speed-up your DB2 Downloads with DownThemAll
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 information...
read more