- SUNY College at Buffalo
Willie Favero is currently a Senior Certified Consulting IT Software Specialist working with the Data Warehouse for System z Swat Team at IBM's Silicon Valley Lab, a member of IBM's zChampion team, a representative for System z with IBM's Academic Initiative, an IBM Certified Solutions Expert for DB2 9 for z/OS and DB2 for z/OS Version 8, DB2 UDB, and DB2 for OS/390 Version 7, and a participant in the zNextGen program at SHARE. Between IMS/VS DB/DC, Cincom's Total and Supra, IDMS, and DB2, he has over 30+ years experience working with database. However, Willie has spent his last 24 years working primarily with the DB2 family. His responsibilities include consulting to IBM's customers on Data Warehouse running with DB2 for z/OS. He has performed DB2 subsystem, performance, and security health checks, performance tuning for the DB2 subsystem, performance analysis for DB2 applications and SQL, design reviews, data modeling, general DB2 consultation, CritSit resolution, DB2 installation assistance, migration planning to DB2 for z/OS Version 8, all forms of DB2 education, and dables in z/OS and System z hardware. Willie currently has the top DB2 for z/OS blog on the internet, Getting the Most out of DB2 for z/OS and System z.
This is Willie's second career with IBM. Before rejoining IBM, Willie was a Principal Consultant for BMC Software, Inc. With 7+ years at BMC Software, Inc., Willie's responsibilities included consulting to BMC's R&D groups and to BMC's customers on issues relating to both the IBM DB2 family (all platforms) and the BMC products that support the DB2 family. He spent a great deal of his time presenting at conferences (locally and internationally), user groups, seminars, and taping product videos for customer distribution.
Prior to his stay at BMC, Willie was a Senior Instructor with IBM education for 11 years. He developed and delivered DB2 courses for IBM's Customers, IBM System Engineers, IBM internal sites, and for the DB2 developers and DB2 Level 2 Support at the IBM Santa Teresa Lab (now Silicon Valley Labs). Previous to joining IBM (his first IBM career), Willie spent over ten years as an IBM customer. During the last two years of this period, he held positions as a Systems Programmer in the Manufacturing industry supporting MVS, VTAM, NCP, and IMS. Prior to that, Willie worked five years as an IMS DB/DC Systems Programmer in both the Finance and Manufacturing industries. He started in IT performing duties as an Application Programmer and Application Analyst using IMS in the Finance industry for three years. He entered the industry in 1973 after receiving a Bachelor of Science degree in Information System Management from the State University of New York College at Buffalo (aka Buffalo State College).
Willie is a recognized worldwide as a DB2 expert and is a highly sought after speaker on a variety of DB2 for z/OS, Client/Server, Object Technology, z/OS, System z, and specialty engine topics. He presents at numerous conferences including the North American, European, and Asian Pacific International DB2 User Group (IDUG) Conferences and the IDUG Canadian Symposiums, GUIDE (an IBM Rep for 4 years), Nordic GUIDE, and SHARE (currently a project leader). In addition, Willie presents at most local DB2 and Database User Groups in the US and Canada, many international DB2 User Groups in Europe, Asia, and Australia, DB2 Vendor Seminars in the US, Asia, Europe, and Australia, and the IBM DB2 Technical Conference, now the IBM DB2 Information on Demand (IOD) Conference, in the US and Canada. He also participated for three years on the Conference Planning Committee (CPC) for the North American IDUG and he is currently the IBM liaison to the IDUG Solutions Journal and IDUG DB2-L list owner and administrator. In addition, in the spring of 2004, Willie was inducted into the IDUG "Volunteer Hall of Fame"
Willie has been a technical reviewer for all the DB2 product publications and SRA DB2 self study courses. While working for IBM, he had the opportunity to contribute to several DB2 "Redbooks" published by the IBM International Technical Support Centers (ITSC) on packaging, performance and distributed processing. Willie currently acts as a technical reviewer for books covering DB2, DB2 UDB, application development, data warehouse, and Object Oriented Design for several major publishing companies. He volunteers his services as a technical editor, reviewing articles on IMS, Parallel Sysplex, the DB2 Family of database managers, and numerous other topics for a variety of nationally published magazines. He has donated his time to Giga Information Group , search390.com and searchDATABASE.com Internet Web sites and Quest's DB2 Pipeline answering questions about database. In addition, Willie has published over a dozen articles on DB2 and client/server in numerous magazines and authored the TidBit column and Face Off column in the IDUG Solutions Journal.
As an IBM Instructor, Willie developed and taught courses on DB2 Release Transition (for Version 2.2, Versions 2.3, and Version 3), DB2 Advanced Recovery, DB2 Database and Systems Administration, DB2 Application Programming, SAA SQL, DB2 Design Reviews, SQL Performance Analysis, DB2 Performance and Tuning, DB2 Application Performance Tuning, DB2 Application Design Review and DB2 Distributed Processing. While with BMC, Willie developed and taught courses (and seminars) on DB2 Recovery and Restart, DB2 Version 3 Implementation, DB2 Version 4 for MVS/ESA Implementation and Planning, DB2 for OS/390 Version 5 Implementation and Planning and DB2 for OS/390 Version 6 Implementation and Planning. He has also written numerous presentations, seminars, and classes for BMC products that support DB2. Most recently, in his last role as a consultant for IBM Lab Services, he has taught the DB2 for z/OS Version 8 Transition course and DB2 Performance course for IBM's Global Education.
- IBMSenior Certified Consulting IT Software Speciaist, present
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 .
A new (draft) DB2 Analytics Accelerator Redbook (SG24-8314) is now avail...
(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 Accele
And DB2 just keeps getting better and better and better.
(Posted Tuesday, October 6, 2015) Today is another milestone day for DB2 for z/OS. The early support program (or what many of us still refer
Are you using the DB2 Diagnosis Guide and Reference?
() There are three questions that follow about the usage of the “DB2 Diagnosis Guide and Reference” I would like you all to answer for me to
But what if I don't want to become a digital business?
The good news is you can transition to being a digital business incrementally, without throwing out whatever systems and technologies you cu
This is just so cool: Accelerator-only tables (Part 2)
(Posted Thursday June 27, 2015) Today’s post is a bit longer than most that I publish, more the length of an article. For that reason I have
Red Alert: For DB2 V10 and DB2 V11 users (2015.07.06)
(Posted Monday, July 6, 2015) It appears that in rare situations the DB2 log records could be written with invalid control information, not
June 20, 2015 DB2 for z/OS Product Publication updates for DB2 11 and DB...
(Posted Friday June 26, 2015) June 20, 2015 sees another major update of a large number of the DB2 for z/OS product publication. Updates for
Building a data set containing a subset of SMF records
(Posted Thursday, June 4, 2015) I mess with reporting on DB2 quite a bit so I mess with MVS System Management Facility (SMF) data a lot. If
There's been a new subsystem parameter added to DB2 for z/OS
(Posted Sunday May 24, 2015) A few weeks ago there was a new subsystem parameter (aka ZPARM, aka DSNZPARM) that became available in DB2 for
Keeping up-to-date on the latest and greatest IBM technology
(Posted Monday, May 4, 2015) I guessing since you are reading this, you are in some way a fan of the Mainframe. Since you are a fan, then yo
March 2015 (RSU1502) service package has been tested and is now available
(Posted Friday March 6, 2015) Testing for RSU service package RSU1502 is now complete. This March 4, 2015 4th Quarter 2nd Addendum Quarterly
Why and How you should be using the DB2 Analytics Accelerator modeling f...
(Posted Wednesday, February 18, 2015) The IBM DB2 Analytics Accelerator has been available for over 3 years. The technology has achieved “Tr