Articles & Content
The Fillmore Group was founded by IBM DB2 Gold Consultant Frank C. Fillmore, Jr.
Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.
The Fillmore Group – Another Migration Success!I am pleased to report a team of four consultants from The Fillmore Group, a team with over 100 years of combined DB2 experience, recently completed a successful migration of the courts system database at Lake County, Illinois. The migration was spurred by an all-too-familiar challenge: retirement announcements by three long-time, key technical personnel and a recognized need to modernize their database to enable potential use of Commercial-Off-The-Shelf (COTS) application software. The entire project, including new DB2 for z/Linux (LUW) DBA training, re-integration of several archived databases and migration of the customer’s extensive library of QMF reports, was estimated at 18 months and completed in 9. Under Frank Fillmore’s direction, the team utilized resources as needed: part-time and full-time, remote and at the customer site. The production cutover Memorial Day weekend went smoothly. Lake County’s court system database is now running DB2 V11.1 on an Integrated Facility for z/Linux (IFL) on their IBM z Systems BC12. Their DB2 software license costs were under $10K. Most importantly, they are now prepared to begin evaluating application modernization options. Congratulations to Suresh, Roger, Jim and Frank. If your team is looking for migration support, please contact me. These DB2 experts like to keep busy!
$5!! – June 14th Balto/Wash DB2 Users Group MeetingThe Baltimore/Washington DB2 Users Group has been supporting the local DB2 community for 25 successful years. Our quarterly meetings are packed with interesting, relevant information about how to best leverage DB2. Many of the region's largest businesses and agencies regularly attend our meetings and benefit from the presentations and networking opportunities as some of the most highly skilled developers and database administrators in the Mid-Atlantic are frequent attendees. At our April board meeting we decided to do something special for the June meeting. We agreed to offer a special, discounted $5 registration fee to attendees who pre-register, rather than our usual $30 -- $50 (see the information below – details and registration information are included in it). The $5 includes everything our users expect at our quarterly meetings: terrific presenters (we have Jeff Josten presenting), a sit down lunch and the opportunity to meet with many of the best DB2 technical people in the region. We are hoping this *almost free* offer will encourage new DB2 users and people who haven't been able to attend meetings recently to join us. If you are in the area June 14th I hope you will join us. If you can't be here, please share this invitation with any of your colleagues or customers who may be interested. Please note: you must register by Friday, June 9th, on the Baltimore/Washington DB2 Users Group website (www.bwdb2ug.org) to receive the $5 discounted registration. Don't forget!! Date: Wednesday, June 14th, 2017 Time: 9:00 AM -- 3:30 PM (registration at 8:30) Location: Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD 21044 Meeting Schedule: Registration 8:30 -- 9:00 DB2 12 for z/OS and Beyond Jeff Josten IBM This presentation gives a high level overview of DB2 12, and also some other interesting features which have shipped recently on DB2 11 (and sometimes DB2 10) including native DB2 RESTful services, DB2aaS cloud-style provisioning, and IDAA on Cloud. We will also take a peek into the future for what is planned beyond DB2 12. Coffee Break 10:15 -- 10:30 DB2 for z/OS Continuous Delivery Jeff Josten IBM DB2 for z/OS is moving to a continuous delivery model for shipping new features. The main objectives are to speed up delivery of important new functions and to make it easier for customers to manage DB2 upgrades. This presentation will give an overview of the continuous delivery mechanisms and suggested best practices for managing DB2 in this continuous delivery world. Lunch 11:45 -- 12:45 DB2 Autonomics Sowmya Kameswara IBM An overview of the no-charge product the Data Server Manager (DSM) and the new IBM DB2 Autonomics for z/OS. The DB2 Autonomics can help you in closing the gap between yesterday's IT implementation and tomorrow's IT demands while eliminating the mundane repetition of manual day-to-day tasks. DSM in a web browser is the weapon that can help your organization to fight the constant skills and resource gaps. Break 2:00 -- 2:15 API Economy Jeff Bisti IBM Microservices are a take on API Enablement that are quickly becoming a new standard in many customer shops. The goal is to avoid building the next generation of "monolithic" applications, and instead build functionality with modular web services, which can be repurposed by a wider variety of developers. Microservices can excel on the mainframe System of Record when they take advantage of where the platform itself excels. In this session, Jeff Bisti will present the benefits of thinking in terms of microservices, introduce some of the tools that are available to developers and architects, as well as the importance of an overall API strategy.
Oracle Renewal Looming? Consider DB2! @IBMAnalyticsThanks to my colleague, Kim May, for another wonderful job leading customers and IBMers through the rewards and challenges of converting Oracle databases to DB2. The recording of the latest webinar is found here. The presentation materials: Oracle Customers Consider DB2 5.16.17 Finally, The Fillmore Group’s White Paper on Oracle to DB2 migrations: SmarterQuestions White Paper -- Oracle to DB2 Migration Lessons Learned -- Final Please reach out to Kim or me if you have any questions.
IBM Announces Extended Support for DB2 for LUW V9.7 and 10.1I've been pondering what this announcement means all day...is IBM trying to become the most altruistic database software vendor? They are offering amazing software license discounts to customers moving workloads from Oracle to DB2 for LUW, and today announced a new extended support option for customers unable to meet the September 30th End of Support (EOS) date for both DB2 V9.7 and V10.1. Typically IBM pushes customers to migrate before the EOS date as it helps to keep the majority of customers being supported on a limited number of software versions. As everyone supporting software knows, simpler is better. On the flipside though, I've been wondering if this announcement is a veiled advertisement for a new, for-fee offering from IBM to generate services income? Yes, I can be as suspicious as anyone! If you find yourself in need of extended support and discover IBM is asking for a substantial fee and would like a second price option on support, please shoot me an email. We've offered DB2 customers similar support in the past, and we've also completed several migrations from V9.7 and V10.1 to V11.1 and can help you get to V11.1 before September 30th if that's the best option of all. Information on the IBM announcement and contact for obtaining a quote for the extended support is HERE. My contact info is HERE. Your call!
Another Oracle Attack Webinar? You Bet!With IBM's announcement this week of super-aggressive discounting being offered to current Oracle customers considering a move to DB2, and with the deadline looming for many Oracle customers faced with another year of bloated "investment" in Oracle support, we've decided to deliver updated material on the benefits of moving to DB2. Our upcoming webinar, "Oracle Renewal Looming? Consider DB2!" will be delivered on Tuesday, May 16th, from 11:30am to 12:30pm EDT. DB2 Gold Consultant Frank Fillmore will join me for the session, as will IBM's Tony Mancini, Worldwide Competitive Team Executive. Tony will give us a brief overview of IBM's recent announcement, and Frank and I will deliver a fast-paced, interactive 60-minute session that will (we hope!) provide current Oracle customers with an understanding of both the cost savings and incredible database functionality available with DB2. Please register HERE to join us!
Calling All IDAA Users!The next IBM-sponsored DB2 Analytics Accelerator Users’ Group meeting was announced this week. The Fillmore Group’s Frank Fillmore will be presenting one of the sessions, along with BNY/Mellon Pershing’s Al DiGiovanni, whose support and promotion of the IDAA enabled Pershing to acquire their first IDAA. Al and Frank will be presenting the meeting’s final session titled, “Increasing Utilization of the Accelerator by your Lines of Business”, a session whose topic has been a core issue for System z customers trying to persuade their colleagues to consider investing in the IDAA. As many technical teams promoting IDAA adoption have learned (the hard way!), most organizations adopted the circa-Y2K best practice of running OLTP and analytic workloads separately, and are therefore reluctant to re-integrate the two, in spite of the cost, latency and simplicity advantages. This session is designed to surface the issue and discuss options to address and overcome it. Information on the DAAUG meeting is below. Please be advised that membership in this group is limited to current IDAA customers and registration to attend is managed by IBM. If you own an IDAA and would like to attend, and have not received an email invitation from IBM, please email me (email@example.com) and I will connect you to the IBM team coordinating the meeting. I hope you will join us May 9th. Session Details “Increasing Utilization of the Accelerator by your Lines of Business” Frank Fillmore and Al DiGiovanni, BNY/Mellon Pershing The IDAA is a powerful tool for performing real-time analytics on z/OS transactional data. In many cases it is left to the managers of an enterprise’s mainframe to “sell” an IDAA to lines of business (LOBs). The audience for the sales pitch: CFOs, CTOs, Enterprise IT Architects, Data ScientistsThe objections: o existing infrastructure (ETL processes, enterprise data warehouses) o mainframe marginalization (“The mainframe is too expensive”; “The mainframe is not a strategic platform”)The advantages: o reduced complexity o reduced latency o cost savings (e.g. inexpensive data archiving of all System z data)New opportunities: o in-database transformation (i.e. AOTs for MicroStrategy) o in-database analytics (i.e. INZA-IDAA 188.8.131.52) o cloud deployment (Public/Private/Hybrid) o Machine Learning o R supportDB2 Analytics Accelerator Users’ Group (DAAUG) Meeting Date: Tuesday, May 9, 2017 Location: IBM Offices, NYC or via web conference Time: 9:30am – 2:00pm EDT During this meeting, Ute Baumbach, subject matter expert from the Analytics on z Systems Center of Excellence out of Boeblingen, Germany, will cover the most recently introduced Accelerator features, functions and fixes. Tim Willging, Distinguished Engineer, will discuss how you can expand your Accelerator use cases with new functionality in the Accelerator Loader Tool. Jonathan Sloan, Business Analytics Executive Consultant, will present ways the Accelerator complements IBM Machine Learning. Frank Fillmore, DB2 Gold Consultant of the Fillmore Group, and a customer presenter will share their successful experiences to help you promote the value of the Accelerator to your Lines of Business. We encourage you to join the meeting in person if you are local. Web Meeting details will be provided for remote attendees. Agenda: 09:30 – 10:00 Registration 10:00 – 10:15 Welcome 10:15 – 10:45 Developer's Update: DB2 Analytics Accelerator Features, Functions and Fixes 10:45 – 11:30 Expanding Accelerator use cases with new DB2 Analytics Accelerator Loader functionality 11:30 – 12:00 Lunch Break 12:00 – 01:00 Complementing IBM Machine Learning with the DB2 Analytics Accelerator 01:00 – 02:00 Increasing Utilization of the Accelerator by your Lines of Business
Oracle Renewal Looming? Consider DB2! @IBMAnalyticsThanks to Kim May for a fabulous job stepping customers and IBMers through the rewards and challenges of converting Oracle databases to DB2. The recording of the webinar is found here. The presentation materials: Oracle Customers Consider DB2 4.5.17 Finally, The Fillmore Group's White Paper on Oracle to DB2 migrations: SmarterQuestions White Paper -- Oracle to DB2 Migration Lessons Learned -- Final Please reach out to Kim or me if you have any questions.
Webinar: Oracle Renewal Looming? Consider DB2!The Fillmore Group is inviting organizations frustrated with rising Oracle costs to join us for a webinar focusing on the two primary motivations behind DB2 migrations: cost and functionality. Session attendees will perform a self-analysis to compare similar version license costs, and gain an understanding of the technical features included in DB2 for on-premise use – BLU, pureScale, and the Data Partitioning Feature -- as well as a brief overview of cloud deployment and SaaS options. Date: Thursday, April 6th Time: 11:00am -- 12:00pm EDT The session also includes an overview of the migration process, as anyone considering a move needs to understand the time and effort involved. Sound boring? It won’t be! The session will be delivered by IBM Champions Frank Fillmore and Kim May. Frank has participated in IBM’s annual “Break Free Forum” and Kim has worked with several Oracle customers exploring migrations to DB2. We understand this is a complicated comparison but will do our best to make the session entertaining without including too much Oracle bashing. But maybe a bit. Registration is required to attend. Register HERE.
Baltimore/Washington DB2 Users Group – March Education Session with Susan LawsonI invite all DB2 for z/OS users in the Mid-Atlantic region to join the Baltimore/ Washington DB2 Users Group (www.bwdb2ug.org) for our annual March education session next Wednesday, March 8th, at the Sheraton Hotel in Columbia, Maryland. The session cost is $250 in advance and $350 at the door. Logistics and registration are on the Baltimore/Washington DB2 Users Group website HERE. The session will be delivered by DB2 Gold Consultant (and terrific presenter) Susan Lawson of YLA and is titled, "DB2 11 and 12 Performance and Availability: What Can I Take Advantage Of?" The session abstract, Susan's bio and the complete outline link are below. If you are using DB2 v11 or V12 I hope you will join us! Abstract With every new release of DB2 we look to see what features will allow us to improve the capabilities and performance of our existing applications as well as the availability of our data. We also have to plan to utilize new features in our development efforts. This presentation takes a look at the features in DB2 11 and 12 that will improve our performance and provide us with maximum data availability as well as advanced application development. We will be focusing on features that can be utilized by DBAs and application programmers. Speaker Bio – Susan Lawson Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help develop, implement and tune some of the worlds’ largest and most complex DB2 databases and applications. She also performs performance and availability audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities include authoring books, articles and white papers, presenting at user group meetings, and teaching a variety of DB2 courses. She is an IBM Gold Consultant and an IBM Analytics Champion and is the author of the IBM DB2 11 for z/OS Database Certification Review Guide. BWDB2UG March 8 2017 DB2 11 and 12 Performance and Availability
Thank you Governor Hogan!When I started working for The Fillmore Group over ten years ago, the world of DB2 was far different. The State of Maryland had probably over a dozen IBM mainframes running state government agencies. We occasionally delivered training and support, but often struggled with the procurement processes, as we weren't an approved vendor. As I learned, the master vendor list for IT vendors to the State of Maryland adds new vendors only once every 8 to 10 years, as the qualification process (we are talking government here!) is onerous and terribly time consuming for all involved. So I waited and finally this past year it was time again for open enrollment. The qualification process WAS onerous and time consuming and required the assistance of Maryland Governor Hogan's office to make the insurance requirements attainable for small businesses like The Fillmore Group. Many thanks Governor Hogan! Today The Fillmore Group received the fully executed contract to deliver IT services to the State of Maryland. There aren't as many mainframes as there were ten years ago and efforts have been underway to consolidate their workloads, but we can help. I think a private cloud running System z with a couple shared IDAA's would be cost effective, efficient, and modern. Can't wait to get started!