Feb 10

Testing for the first service pack of 2013, RSU service package RSU1301, is now complete. This February 2013 4th Quarter quarterly report is the first addendum of 2013.  It is based on the previous quarter and contains PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through December 2012.

A complete list of products and tools and their tested levels is available HERE.

Continue reading »

Share
Tagged with:
Jan 08

Here are a couple of blog post I have made to my Toolbox.com blog.

The first covers an upcoming webcast on DB2 futures by Jeff Joston…

Upcoming DB2 11 preview (plus other stuff) webcast with IBM’s Jeff Josten

The second one covers the latest maintenance RSU…

January 2013 (RSU1212) service package has been tested and is now available

Please check them out

Share
Tagged with:
Nov 29

That’s right… I just didn’t care for the way it flowed… so I had a little time while eating lunch today… with a sandwich in one hand and keying with the other, I did a little patch work to a blog post I published back on October 28 that discussed the potential for wasting space in the older style table spaces after migrating to DB2 10.

Visit “APAR Friday: If you recently migrated to DB2 10, watch out for table spaces using too much space (HIPER) “ for the rewrite and what I think is a much better description of the issue.   If you want, let me know if it reads better now.

Share
Tagged with:
Oct 28

Here’s an interesting HIPER (High Impact or Pervasive) APAR that anyone who has recently migrated to DB2 10, conversion mode (CM) and above, should check out.

APAR PM71866 addresses a post migration issue where first update against a full data page incorrectly updates the space map.   It would seem that in some cases things can go downhill badly after that with table spaces rapidly extending because INSERTs are not reusing delete space especially in the cases where multiple DELETEs are performed successively.

Continue reading »

Share
Tagged with:
Sep 03

Last week we talked about how to improve LOAD and UNLOAD performance by taking advantage of the new option FORMAT INTERNAL (see “Did you know you can make DB2 LOAD run faster?” from August 14, 2012)…… Continue reading »

Share
Tagged with:
Aug 13

Testing for the latest RSU service package RSU1207 is complete. This 2nd quarter’s Quarterly Report’s 1st addendum contains all service through the end of March 2012 not already marked RSU. This service also includes PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through June 2012….. 

Continue reading »

Share
Tagged with:
Jul 09

Testing for the latest RSU service package RSU1206 is complete. This 2nd quarter’s Quarterly Report contains all service through the end of March 2012 not already marked RSU. This service also includes PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through May 2012…… Continue reading »

Share
Tagged with:
Jun 11

Testing for the latest RSU service package RSU1204 is complete.  This 2nd addendum to this quarter’s service contains all service through December 2011 and PE resolution or HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through April 2012…… Continue reading »

Share
Tagged with:
May 25

Title says it all.   Without this APAR, DB2 can spend a tremendous amount of time searching index space maps for free space an an effort to avoid extending the page set.

After applying this APAR, DB2 will use page list prefetch to improve search processing…….. Continue reading »

Share
Tagged with:
May 04

Testing for the latest RSU service package RSU1204 is complete.  This 1st quarter addendum contains all service through December 2011 and PE resolution or HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through March 2012…… Continue reading »

Share
Tagged with:
preload preload preload