BLOGS

    Thoughts and opinions from DB2 and technology blogs around the world featured by
    IDUG for our members.

    Willie Favero - Getting the most out of DB2 for z/OS

    Welcome to all things DB2 for z/OS. This is your one stop, your only stop, and your final stop to find out all you'll ever want to know about DB2 for z/OS. We'll be discussing how to upgrade to the latest DB2 version, have detailed "how it works" discussions, some performance tips, maintenance alerts, baby updates, with a few guest posts thrown in occasionally. In addition, you'll find all of the latest DB2 news and gossip, arrival notifications of the latest articles, books, seminars, and teleconferences, along with details on all of the major conferences. I'll occasionally be throwing in a post covering our z/OS operating system and our System z hardware. Plus, there will always be something entertaining posted every once in a while. This is the place you'll find just about anything you need to know to stay current with DB2 for z/OS, z/OS, or System z. This is also the place to get that little bit of lite reading each morning to start your day off on the right foot.

    Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

     

     
    August 2014 (RSU1407) service package has been tested and is now available(Posted Tuesday, August 19, 2014) Testing for RSU service package RSU1407 is now complete. This RSU completes the first quarter of 2014. This August 2014 2nd Quarter 2014 1st Addendum "Quarterly Report" (67 KB PDF file) contains ALL service through the end of M...
    APAR Friday: DSNWMSGS has just been updated again(Posted August 17, 2014) If you have had the opportunity to do any performance tuning of DB2 for z/OS, you have probably come across any number of IFCID (instrumentation facility component identifier) at some point. In fact, I did a blog post way back in May 2010 discu...
    DB2 10 for z/OS Out-of-Service Date Announced(Posted Monday, August 5, 2014) On September 30, 2017, that?s in just 3 years, 1 month, and 25 days from today (05AUG2014), DB2 10 for z/OS (5605-DB2) will go out of service. That may seem like a long ways off, but it isn?t. It?s only lust under 38 months. W...
    IBM Redbook update; some use tips(Posted Monday, August 4, 2014) I?m guessing that if you are reading this blog, you have downloaded a Redbook; and probably not all that long ago. With that in mind, today?s post isn?t about any one specific Redbook, but rather keeping up to date on the latest and greatest ha...
    DB2 11 for z/OS Performance Topics is completed and available(Posted Tuesday, July 29, 2014) Good news from the IBM Redbook website. The DB2 11 Performance Topics Redbook has been posted in its final status; it is no longer a Draft. All of the comments made about it since becoming a draft have accumulated and editing has been completed. It is now ready for general consumption. Of course, this is also a performance Redbook which always generates a little extra interest. So stop anticipating and start downloading.
    My previous RDS sort discussions(Posted Thursday, July 18, 2014) After posting about buffer pools for the last few weeks, I have received some questions about the sort work buffer pools. I made brief mention of them in one of my buffer pool post. However, last year I did a entire series of post...
    Back to Buffer Pool Basics OctologyI?m not sure if Octology is word or not... I can?t find it on Dictionary.com although it does show up in Wiktionary.org. I?m using it anyway to describe my Back to Buffer Pool Basics Series of 8 posts. From this post, you can ...
    Back to Buffer Pool Basics: Part 5A - Fixed ThresholdsLet?s start today?s post with a short discussion about what a buffer pool is. I know most of you all know this stuff already, so this explanation will be short and just enough to get us all on the same page. Thresholds are usu...
    Back to Buffer Pool Basics: Part 5C - DWQT and VDWQT(Posted Thursday, July 17, 2014) Just as a review: Before we jump into discussing the last two variable buffer pool thresholds, the defaults for the previously discussed fixed buffer pool thresholds are: immediate write threshold (IWTH) - 97.5%, data management threshold (DMTH) - 95%, and prefetch threshold (SPTH) ? 90%. The defaults for the previously discussed variable buffer pool thresholds are: sequential steal thresholds (VPSEQT), virtual buffer pool parallel sequential thresholds (VPPSEQT). Now we?ll discuss the deferred write thresholds (DWQT, and vertical deferred write thresholds (VDWQT).
    Back to Buffer Pool Basics: Part 5B - VPSEQT and VPPSEQT(Posted Thursday, July 17, 2014) Just as a review: Before we jump into discussing the different variable buffer pool thresholds, the defaults for the fixed buffer pool thresholds are: immediate write threshold (IWTH) - 97.5%, data management threshold (DMTH) - 95%, and prefetch threshold (SPTH) - 90%. Now we?ll discuss sequential steal thresholds (VPSEQT) and virtual buffer pool parallel sequential thresholds (VPPSEQT). We will be discussing deferred write thresholds (DWQT) and vertical deferred write thresholds (VDWQT) in my next post.

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact