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.
Fall Class HighlightsLearn new Db2 skills and help your organization leverage the best features and functionality available in the Db2 product family. The classes below are our Fall, 2019 top picks! Virtual and in-classroom options are available. For registration email Kim May.----10/7 -- 10/9 Db2 pureScale Implementation and Management. Prepare for planning, installing, managing and monitoring a DB2 pureScale database system. Cost: $2325. View the course outline below.CL801G pureScale Implementation and Management----10/10 -- 10/12 Db2 BLU Acceleration Implementation and Use. Learn the concepts and facilities of BLU Acceleration including loading data into column-organized tables and monitoring the processing of SQL statements that access the tables. Cost: $1550.CL451G Db2 11 BLU Acceleration Implementation and Use----10/15 -- 10/17 Change Data Capture Essentials. Learn the architecture, components and capabilities of CDC, day-to-day operations, monitoring and troubleshooting. Cost: $2775.KM020G Change Data Capture Essentials----10/21 -- 10/23 Db2 LUW -- and IAS! -- Database Administration Workshop. The Fillmore Group's Db2 DBA fundamentals course, authored by our consultants and trainers, and delived to hundreds of Db2 users. Cost: $1800.TFGE231 Db2 LUW Database Administration----10/28 -- 10/31 Q Replication Workshop. Learn the architecture, components and capabilities of Q Replication, day-to-day operations, monitoring and troubleshooting. Cost: $2400.CE243G Using Queue Replication---- Through a partnership with TechData one of IBM's select global training providers, The Fillmore Group delivers authorized training for the design, installation, maintenance, and troubleshooting of IBM Analytics solutions. This partnership allows The Fillmore Group to leverage the award winning IBM technical training content that is exclusive to IBM's global training providers.
Join Gold Consultants for a V12 Upgrade Webinar Wednesday, October 9thThe Time is NOW! Upgrade to Db2 12 for z/OS! Date: Wednesday, October 9, 2019 Time: 11:00am EDT Register: HERE You are invited to join a live webcast hosted by IBM Gold Consultants to learn why this is the right time to upgrade to Db2 12. Gold Consultants are an independent voice, delivering Db2 consulting and support to customers worldwide. Learn more about the Golds and how they can help your organization by visiting the IBM Gold Consultant webpage. During this webcast expert Golds will discuss: • The benefits of upgrading to Db2 12 • Continuous availability and potential cost savings • In-memory Features • Pre-planning tasks and their importance • Costs and risks associated with failing to migrate by September 30, 2020 The session will close with a live Q&A session with several of the Golds who contributed recommendations and content to the presentation. The session was developed and will be delivered by the following IBM Gold Consultants. Bio's for each presenter are below. Julian Stuhler Triton Consulting Julian has over 30 years of Db2 experience in application programming, database administration, technical architecture, performance tuning and systems programming, working within the insurance, telecommunications, banking, financial services and manufacturing sectors. He is an IBM Redbook and White Paper author and IDUG Best Speaker, and has lectured widely on DB2 subjects in the UK, Europe and US. In 1999 Julian was invited to join the IBM Gold Consultants program, and in May 2008, Julian was recognized as one of IBM’s inaugural Data Champions. Julian served on the IDUG Board of directors from 2003 to 2010, and is an IDUG Past President. Frank Fillmore, Jr. The Fillmore Group, Inc. Frank is the Founder and President of The Fillmore Group, Inc., a Premier IBM Business Partner. Frank is an IBM Gold Consultant and IBM Champion for both Analytics and System z. The Fillmore Group’s areas of expertise include data interoperability, replication and high availability, InfoSphere, Db2 Server for VSE&VM, competitive migrations and technical Project Management. Frank oversees a staff of talented employees and contractors, and manages projects ranging from new database implementations to health checks. In addition to consulting Frank and his team deliver IBM Authorized Training and are IBM software resellers. Isaac Yassin DBX-Consulting Isaac is an IBM Gold Consultant and Champion with over 40 years of experience consulting on IT and security at cross-industry customers covering areas of global system tuning including Sysplex and Parallel Sysplex, Security (RACF, Top-Secret, Guardium) and large-scale projects involving Data Warehouse / Big Data and Machine Learning as well as data analysis in heterogeneous environments. Isaac has vast knowledge in DB2 (both Z & LUW), IMS and other major DBMSs and has installed and migrated every release of Db2 starting with V1.2 and up to V12, including "skip & jump" migrations and worked on a variety of migrations to and from other vendor databases. Isaac's Db2 technical work includes wide-scale problem analysis, performance, troubleshooting, education/training, security problems and audits and BCP/DRP scenarios. Isaac is an active IDUG contributor and frequent presenter. Gerald Hodge HLS Technologies Gerry began working with Db2 V2 in 1985 while a First Vice President at Security Pacific National Bank. While there he headed the Capacity Planning and Performance Planning for 11 of the bank’s data centers. In 1990 he moved to BMC Software’s International Sales as their SME for their Db2 products, and was the primary on sight support for sales and Db2 Products in both Europe and Asia. In 1995 Mr. Hodge started HLS Technologies, Inc. His company developed the following DB2 products: Avoid Bind, DBRM Check, Path Check, and Express Hints. He was invited to join IBM’s Gold Consultants the year the program was formed. He has been an active member every year since. HLS Technologies has provided detailed planning and support for Db2 migrations since V5 and is currently supporting a large V12 migration project. Dan Luksetich DanL Database Consulting Dan is a Db2 DBA consultant, an IBM Gold Consultant and IBM Analytics Champion. He works as a DBA, application architect, presenter, author, and teacher. Dan has been in IT for over 34 years, and has worked with Db2 for over 29 years. He has been an application programmer, Db2 system programmer, Db2 DBA, and DB2 application architect. His experience includes major implementations on z/OS, AIX, i Series, Windows, and Linux environments. His industry experience includes retail, banking, fraud detection, analytics, government, and utility. He specializes in highly available, high-volume transaction processing against very large database systems. Dan’s experience includes, but is not limited to: · Application design and architecture · Business analytics · SQL consulting and education · SQL coding and application programming · Database administration · Complex SQL · SQL tuning · DB2 performance audits · Replication · Disaster recovery · Stored procedures, user-defined functions, and triggers
#IBMz #IDAA v7.1 Webinar Recording and Material #Db2Extending appreciation to all who participated in the IBM Db2 Analytics Accelerator (IDAA) v7.1 webinar on August 28, 2019. If you weren't able to join us, here is the webcast recording. In a fast-paced 90 minutes we covered: A review of capabilities included in recent IDAA v7.1.x code dropsThe return of the High Performance Storage Saver (HPSS)Integrated SynchronizationThe closer-to-real Hybrid Transaction Analytic Processing (HTAP) capabilityDisaster Recovery and High Availability considerationsThe Fillmore Group’s exclusive IDAA Buyer's Guide compares these IDAA form factors and deployment options: IBM Integrated Analytics Systems (IIAS)Docker container running on System zDocker container running on LinuxONEAnd this is the handout: IDAA Webinar 2019-08 Please note: if you would like the exclusive IDAA Buyer's Guide referenced in the webinar, contact my colleague, Kim May (email@example.com).
IBM Replication Featured at Upcoming Baltimore/Washington Db2 Users GroupIBM is hosting the September meeting of the Baltimore/Washington Db2 Users Group to be held at the BWI Hilton on Wednesday, September 11th. IBM's Kenishia Sapp and Anthony Ciabattoni will be presenting on Db2 for z/OS topics (see agenda below) and *drum roll!* IBM Replication Product Offering Manager Davendra Paltoo will be presenting on IBM's recent replication enhancements and new offerings. With the recent Gartner report validating IBM's market position in their "magic quadrant" with IBM's offerings supporting a broad range of replication sources and targets (including Postgres and Kafka), and the increased focus on making data accurate and available for analytics, it's important to understand what IBM is delivering to customers today. If you are in the Baltimore/Washington area I hope you will join us for the meeting and the opportunity to talk replication with Davendra. The full agenda is below. Registration is required -- please register on the Baltimore/Washington Db2 Users Group website HERE. Date: Wednesday, September 11, 2019 Time: 9:00am -- 3:30pm (registration open at 8:30am) Location: BWI Hilton, 1739 W Nursery Road, Linthicum Heights, MD 21090 Agenda: 9:00am -- 10:15am APIs: A Pathway to the Modern Enterprise, Kenishia Sapp, IBM NA z API Swat Team As Enterprises begin their modernization journeys, REST and the API economy are integral elements of their roadmaps. There are many ways to achieve the goal of REST API enablement for the mainframe, and it can be hard to distinguish the benefits and unique value points among them. Kenishia Callaway will illustrate how solutions such as z/OS Connect, API Connect and others can be used to modernize while retaining the well-developed systems that differentiate company value. 10:30am -- 11:45am Db2 for z/OS Native RESTful Experience, Anthony Ciabattoni, IBM Db2 zOS Development SWAT Team IBM Db2 for z/OS is still the undisputed leader for storing and maintaining mission critical data. It remains the "gold standard" for system availability, scalability, security and cost effectiveness. A majority of Fortune 500 companies, including the world's top banks, retailers and insurance providers trust Db2 for z/OS for storing their data. In addition, Db2 for z/OS continues to invest in industry leading easy to access, efficient and cost effective data access capabilities while maintain our mainframe heritage.This session will show how Db2 REST services allow modern applications to access and consume Db2 data and to reuse existing SQL statements and stored procedures. We will present how they are easily deployed, managed and also promote the rapid/agile development and deployment of new applications that are mobile friendly. 12:45pm -- 2:00pm Db2 12 experiences from the field, recipe for successful migrations, FTB's & Insert Algorithm 2, Anthony Ciabattoni Migrating to Db2 12 and exploiting and taking advantage of new features and functions needs to be planned, prepared and executed to maintain availability and achieve organizational success. This session will go through the recipe of a successful Db2 migration, what can be completed prior to the migration window and what steps actual customers have made to achieve a successful migration. In addition, Fast Traversal Blocks and Insert Algorithm 2 are two of the most popular new features in Db2 12. During the session these two features will be described in detail along with the appropriate use cases for both technologies. Lastly, real life customer behavior, experiences and implementation successes will be discussed. If you are an organization that is in the process of migrating to Db2 12 or are planning for a Db2 12 migration before Db2 11 End of Service this is a must attend session. 2:15pm -- 3:30pm Delivering a Real-time Experience for Dynamic Digital Businesses, Davendra Paltoo, Replication Offering Manager Learn how organizations use IBM Data Replication to deliver near real time data across the enterprise from Db2 and most other major databases. IBM Data Replication key capabilities and plans will also be covered.
Join Frank for a Free Webinar: IDAA Afternoon ShowSeveral people who registered for The Fillmore Group’s Columbus IDAA class in July were unable to attend, so we’ve decided to borrow the “Db2 Night Show” format, with Frank hosting the “IDAA Afternoon Show” Wednesday, August 28th from 4:00 p.m. – 5:30 p.m. EDT. Frank will deliver a fast-paced, content-rich 90-minute webinar covering: A review of capabilities included in recent IDAA v7.1.x code dropsThe return of the High Performance Storage Saver (HPSS)Integrated SynchronizationThe closer-to-real Hybrid Transaction Analytic Processing (HTAP) capabilityDisaster Recovery and High Availability considerationsAnd as an added bonus we will step all registered attendees through The Fillmore Group’s exclusive IDAA form-factor Buying Guide to compare: IBM Integrated Analytics Systems (IIAS)Docker container running on System zDocker container running on LinuxONEWe’ll do this via webinar, so come-one-come-all. We’ll upload the materials we used in the Columbus class so anyone who did not register for class but attends the webinar can access them. I hope you will join us if your schedule allows, and invite any colleagues who may be interested in the material. Registration is required. Please register HERE.
Don’t Miss IDUG Blog: Meet the CrusherThe Fillmore Group has had the pleasure of working with Steve Cricchi for the past several years. Steve is a database administrator and technical problem solver who has done some amazing work with the IBM Db2 Analytics Accelerator. In December he delivered a presentation on his successful efforts with the IDAA to the Baltimore/Washington Db2 Users Group, and an article he wrote about his experiences was recently published on the IDUG blog. Anyone who has considered an IDAA acquisition understands that this tool is not inexpensive, so there's an urgency to ensure it delivers value once it's purchased and installed. It also requires -- like many technical challenges -- a certain degree of creativity. Steve's done a terrific job delivering and his article explains how. Please take a moment to read it! Meet “the Crusher” -- or How We Learned to Love Query Acceleration
Vote for me! Replication Enhancement to Support ASMIBM recently introduced the Data and AI ideas portal for clients where users are invited to request enhancements. And vote on them -- sort of like voting for class president. I submitted a request earlier today for the addition of Oracle ASM support in IBM InfoSphere Data Replication/Change Data Capture. I did this because I was introduced to an Oracle customer currently using Informatica replication who needs to find an alternate replication solution, as Informatica is moving replication to the cloud. IBM's replication solutions are quite strong compared to other vendor options. The list of ICDC supported database sources and targets continues to grow, with Postgres and Kafka being recent additions. I think IBM should continue to enhance ICDC by adding support for ASM so we can introduce more Oracle customers to ICDC. PLEASE! Vote for my enhancement -- I believe it's I-83 at this link. It's currently in "under consideration" status so I may need to update the link when I have confirmed it's available for voting. I'll post some signs up in the hall announcing my enhancement's candidacy. Vote early and vote often!! Thank you for your support!!
IBM Highlights Gold Consultants on IBM.comThanks to the combined efforts of several Gold Consultants, notably Julian Stuhler and Ted Alexander, IBM Gold Program sponsors and advocates Jim Reed and Reid Gerson, and The Fillmore Group's Megan Byrne, a new page highlighting the Gold Consultants program is available on IBM.com. The page provides links to consultant specialty and contact information. The directory is attached here: IBM Gold Consultants Profiles Best of all, the page answers the frequently asked question, "What exactly are the Gold Consultants?" "An elite group of independent consultants with vast experience in IBM data repositories, unified governance, artificial intelligence (AI) and machine learning IBM Gold Consultants bring extensive industry experience and technical expertise to help IBM clients define and implement strong strategies for their data and analytics initiatives using IBM Db2® on all platforms, IBM Informix, IBM InfoSphere®, IBM CICS® and related technologies. This group is recognized as some of the world’s most experienced independent consultants for these products. With in-depth technical knowledge and communication skills, the consultants can fill in skill gaps within a client’s organization and facilitate better performing solutions, optimal database designs and high availability." The new page link is: https://www.ibm.com/analytics/ibm-gold-consultants Check it out -- it looks much better on screen!
Mid-Atlantic Db2 LUW Meeting – Bethesda, May 7thThank you to the IBM Technical Team, Kay Groski and Warren Heising, for coordinating this terrific agenda and group of excellent speakers for the Mid-Atlantic Spring Db2 LUW Users Group Meeting! The is no cost to attend (again thanks Kay and Warren). Registration is required. Register here. Date: Tuesday, May 7, 2019 Time: 9:00am – 2:30pm Location: IBM Bethesda, Room 02-2A304, 6710 Rockledge Drive, Bethesda, MD 20817 Agenda: 09:00-10:30 SESSION 1: Futures (vNext coming soon!) presented by Jon Lind 10:30-10:45 BREAK 10:45-12:00 SESSION 2: IBM Streams presented by Roger Rea 12:00-12:45 Networking Lunch 12:45-2:00 SESSION 3: Demystifying the Db2 Logger presented by Dale McInnis 2:00-2:15 BREAK 2:15-2:30 IDUG Overview
Free Hands-on IDAA Class Announced – July 18 & 19, Columbus, OhioJoin us for this new and improved for 2019 class to be delivered by IBM Gold Consultant Frank Fillmore. Contents include IDAA v7 early experiences, best practices, and v5 to v7 migration tips. Attendees will learn how an IDAA v7 (aka “Sailfish”) can extend System z’s processing capabilities to enable Hybrid Transaction/Analytic Processing (HTAP). For IBM System z customers considering an IDAA purchase, this class provides an overview of the architecture, use cases delivering value, and insight into the administration of the accelerator. Class is free to IBM System z customers considering an IDAA purchase. The Fillmore Group will provide breakfast and lunch each day; attendees are responsible for their own travel and lodging expenses. Registration is required – Register HERE Dates (2 days): Thursday and Friday, July 18 and 19, 2019 Location: IBM, 6060 Britton Parkway, Building 1, Dublin, Ohio, 43016 Time: 9:00am – 4:00pm EDT Cost: Class is *free* to pre-registered attendees Instructor: Frank Fillmore Topics: An introduction to the V7.1 architecture and Integrated Analytics System (IAS).The heterogeneous accelerator environment: what works well today.Assessment tools to support acquisition: Workload Assessment, Client Value Engagement, PoC.Positioning IDAA within your organization with the most valuable use case.Migrating from the Netezza-based IDAA to v7.1.Lab 1: Basic IDAA Activities Data Studio / IBM Db2 Analytics Accelerator Studio GUITable accelerationQuery processing and analysisEnhancing Value to the IDAA with the IBM Tools Ecosystem Assessment: What is the workload that would benefit from being accelerated?Optimization: How do I monitor and optimize a workload to take advantage of the Accelerator?Administration: Can I manage the Accelerator more effectively?Lab 2: Advanced IDAA Exploitation Incremental Update: keeping accelerated data in sync with DB2 for z/OS OLTPAccelerator-only Tables (AoTs): intermediate tables and ETL processing