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.

     

     
    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.
    Happy 8th Anniversary to my DB2 Blog(Posted Tuesday, July 15, 2014) Today?s post will be short, sweet, and a little bit of bragging with some self promoting. You see, this Friday, July 18, will be my blog?s 8 year anniversary. My first post was on July 18, 2005. Yup, I have been writing this blog ...
    APAR Friday: Accelerator, SQLCODE, SYSTS_UPDATE SP, and PKGREL_COMMIT(Posted Saturday, July 12, 2014) The first three APARs all have something to do with the DB2 Analytics Accelerator for z/OS. Even though the Accelerator is a for-cost option, it?s still pretty cool and gaining more and more popularity. After all, who doesn?t want to run queries that normally run in tens of minutes to hours in just seconds. And if that?s not good enough, using the Accelerator has the added benefit of moving the query cost (CPU) over to the Accelerator thus freeing up cycles in the System z processor.
    Please take this survey... This one is important to all of us!(Posted Saturday, July 12, 2014) There?s a group of folks at IBM?s Silicon Valley Lab, you know the people who are responsible for creating all that terrific DB2 for z/OS documentation that allows us to our daily jobs so much better and easier, who have put together a survey to dete...
    July 2014 (RSU1406) service package has been tested and is now available(Posted Monday, July 7, 2014) Testing for RSU service package RSU1406 (CST2Q14) is now complete. This RSU completes the first quarter of 2014. This July 2014 2nd Quarter 2014 2nd Addendum "Quarterly Report" (109 KB PDF file) contains ALL service through the end of March 2014 not already marked RSU. This service also includes PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through May 2
    Back to Buffer Pool Basics: Part 6 - PGFIX(NO/YES)(Posted on Friday, July 4, 2014) This simplest of changes could give you your biggest bang for your buck. It?s the easiest buffer pool change you can make to reduce your CPU usage. There are a few things to consider like all things DB2. For example, you don?t want to run...

    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