Articles & Content

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 opinion about the future DB2 publication in PDF format(Posted Thursday, October 27, 2016) I was just re-reading my blog post discussing IBM DB2 product publications that I published on Monday, October 24, 2016. Let me stick my neck out a bit and discuss, what I believe, is the preverbal elephant in the room; the always so popular PDF versions of the product documentation, the ?hardcopy? version of the Knowledge Center information for lack of a better description.
Friday's HUGE DB2 for z/OS product publications update; get full list here(Posted Monday, October 24, 2016) Friday?s onslaught of updates totaled 69 changes and addition to the DB2 Publications, not including the Program Directories, on the publication?s websites. DB2 12 added 22 new manuals, DB2 11 updated 18 of its 24 books, and DB2 10 revised 18 of its 23 publications.
I have a new friend; Alexa(Posted Saturday, August 20, 2016) I recently made a new friend, someone I find myself now talking to all of the time. Unfortunately, the conversations are a bit on the strange side? I just ask questions, and she answers them, or least she answers most of them.
A step back: A DB2 optimization term, then and now (revised/replaced)(Posted Wednesday, July 27, 2016 - Revised) The terms ?sargable? and ?non-sargable? became common place in the very first releases of DB2. However, the terms most commonly used today are indexable, stage 1, and stage 2. Since I have been dying to write about something (anything) since retiring, this seemed like a fun subject to attack.
A step back: A DB2 optimization term, then and now (Posted Sunday, July 24, 2016) The terms ?sagable? and ?non-sagable? became common place in the very first releases of DB2. However, the terms most commonly used today are indexable, stage 1, and stage 2. Since I have been dying to write about something (anything) since retiring, this seemed like a fun subject to attack.
An update on the DB2 for z/OS Diagnosis Guide and Reference for DB2 10 and DB2 11(Posted Friday, July 15, 2016) If you have a product license for DB2 11 for z/OS or DB2 10 for z/OS, it?s time to get your updated copy of the Diagnosis Guide and Reference. DB2 11 for z/OS Diagnostics Guide and Reference (LY37-3222-04) and DB2 10 for z/OS Diagnosis Guide and Reference (LY37-3220-09) are now available
So you wish DB2 would do "_______" (fill in the blank) (Posted Saturday, May 4, 2016) Everyone at sometimes wish is DB2 for z/OS would only do something? There is always an operation , a feature, a function, a keyword that you wish was part of the product. But what can you do? You?re only one person.
The last word on the status of SYNONYMS in DB2 for z/OS (Posted Saturday, April 27, 2016) It turns out that my posting on April 16, 2016 discussing SYNONYMS being un-deprecated was a bit premature. Please ignore the contents of that post. Instead, here's the most up-to-date information about SYNONYMS presented by today?s guest blogger Patrick Bossman, STSM with DB2 for z/OS Development.
"HOUSTON, WE HAVE A PROBLEM"(Posted Monday, April 25, 2016) I think that misquote from the Apollo 13 movie is perfect for today?s blog post. You see, here in Houston, we have a DB2 User Group that has its attendance dropping off. The solution of course, is to get more folk from around the Houston area to attend our meetings. However, I just can?t seem to come up with a way to do that.
April 2016 (RSU1603) service package has been tested and is now available(Posted Thursday, April 21, 2016) Testing for RSU service package RSU1603 is now complete. This April 1, 2016 "1st Quarter Quarterly Report" (108 KB PDF file) contains ALL service through the end of December 2015 not already marked RSU. This service also includes PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through the end of February 2