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.

 

 
What are your plans for DB2's Synonyms?(Posted Monday, January 27, 2016) If you look up synonyms in IBM?s Knowledge Center, the very first thing you?ll see, the heading for the entry, should grab your attention. In very bold print, it states?
They're everywhere, they're everywhere Redbooks that is. (Posted Monday, January 19, 2016) Do you use IBM Redbooks? Ya, I know, everyone does, right? They have become a staple in the industry; the way to find out how something really works. However, I?m betting a lot of you have always been stuck at a computer reading the PDF version of a Redbook or possibly, even using the hardcopy version (although I haven?t personally seen a Redbook in hardcopy in ages).
Let's start a new year of blogging with a webcast announcement(Posted Monday, January 18, 2016) Although not actually a New Year resolution, it?s a bit late for that, I do plan to do more blogging this year. My goal is to come at least close to my blogging rate of two or three years ago. To kick things off, I wanted to let you all know about an upcoming IBM webinar. This webinar should be of particular interest to anyone using our DB2 Analytics Accelerator, or even considering taking advantage of it. The webinar discusses the Accelerator enhancements in Version 5.1. Patric Becker, a Software Architect in the Analytics on z Systems Center of Excellence at the IBM Boeblingen Lab, Germany will be your speaker.
GDGLIMIT (generation data groups limit) increased: Good, Bad, or "Who Cares" ? (Posted Thursday, November 26, 2015) Thanks to a recent enhancement in z/OS v2.2, a change has been made to DB2 that affects the use of GDGs. However, DB2 has techniques you can use to generate unique data sets other than using GDGs.
It's Thanksgiving in the USA this Thursday (11/26/2015)(Posted Wednesday, November 25, 2015) I would like to take this opportunity to wish all my friends, followers, and ?. a very happy Thanksgiving.
How to improve performance of your older COBOL programs (Posted Sunday, November 22, 2015) COBOL has been around for more than 50 years now. According to 1997 report by the Gartner Group, it was estimated that at that point in time, there were a total of 200 billion lines of COBOL in existence running about 80% of all business programs. Statistics reported just a few years ago to Datamonitor by IBM revealed that 75% of the world?s business data, and 9
November 2015 (RSU1510) service package has been tested and is now available(Posted Friday, November 6, 2015) Testing for RSU service package RSU1510 is now complete. This November 4, 2015 "3rd Quarter Quarterly Report 1st Addendum" (55.5 KB PDF file) is based on RSU1503 recommendations and contains ALL service through the end of June 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 September 2
APAR Friday: Red Alert: Potential issues converting partitioned table spaces(Posted Saturday, October 31, 2015) On October 29, 2015, IBM issued a Red Alert to any DB2 11 customer converting partition table spaces from basic format to extended format. Red Alerts are used to identify and notify customers of critical issues with IBM z Systems products. They should be immediately reviewed to determine how they may impact your specific environment.
A new (draft) DB2 Analytics Accelerator Redbooks publication (SG24-8314) is now available (Posted Thursday, October 22, 2015) If you are using the DB2 Analytics Accelerator for z/OS or even if you are just interested in the Accelerator, there is a new DRAFT Redbooks publication that has just been published by the International Technical Support Organization (ITSO), Boeblingen Center that is definitely one of the DB2 Analytics Accelerator Redbooks you?ll want to check out. It is authored by the Accelerator?s development team out of the IBM Boeblingen lab, Germany and focuses on the functionality delivered in DB2 Analytics Accelerator V4.1 PTF5. In particular, it examines the new table type (Accelerator-only tables) delivered in PTF5 that will allow for more efficient data transformations.
October 2015 (RSU1509) service package has been tested and is now available(Posted Monday, October 21, 2015) Testing for RSU service package RSU1509 is now complete. This October 1, 2015 2nd Quarter "3rd Quarter Quarterly Report" (100 KB PDF file) is based on RSU1503 recommendations and contains ALL service through the end of June 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 August 2