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.
Congratulations to Arvind Krishna!!Yesterday was one of those, "Where were you when you heard the news?" days -- I was at the gym (yes, I do go once in a very long while), watching the financial news and saw the headline announcing Arvind Krishna as IBM's New CEO, effective April 6th. I was so excited I ran out to my car, grabbed my phone and started calling Db2 people. Arvind has been a great supporter of the Db2 community, is the executive sponsor of the Gold program, and the rare sort of leader who can hand you a challenge and make you feel honored to be asked. I am so excited for IBM, their customers, and Business Partners to have Arvind in charge. The photo below is from an IBM dinner I was invited to attend a few years back with two of the best IBM'ers I know -- Arvind and Db2 and replication superstar Christian Zentgraf. I am looking forward to an exciting 2020 for the Db2 community!!
Db2 12 Certification Input and Master Class – Help the Db2 Community – and you!With 2020 off to a positive start for Db2 12 there are two current events I hope are on your radar. First, IDUG is supporting an effort to create a new Db2 12 certification, led by IBM Gold Consultant and Champion Dan Luksetich, who also manages the Db2-L listserv. A survey was created to gather responses to the specific technical issues the community considers important. If you have time to complete the survey and contribute, it is much appreciated by the IBM community. Take the survey here. And of course, if you aren't already monitoring (or better yet, contributing to!) Db2-L, sign-up. It's easy and free -- Db2-L. Second, IBM is offering a week-long Db2 Master Class for advanced Db2 for z/OS system and database administrators clients, led by Distinguished Engineer, John Campbell. John will be joined by Adrian Burke and Michael Dewert. The US-based session will be held at IBM Silicon Valley Laboratory (SVL), Monday, September 28 (8 am) to Friday, October 2, 2020 (2:30 pm), in San Jose, California. The complete outline is attached. Participants will meet the Db2 for z/OS development team -- visit the incredible people whose work is known worldwide! If you are interested in attending this class, fill in and submit the application form. Class is a client-only course, participation is BY INVITATION only, and seating is very limited. Applications will be reviewed and acceptance notices will be emailed. Apply HERE. A registration link with payment instructions will be included in the invitation. If you have any questions, please contact Dorothy Lin (firstname.lastname@example.org) There are pre-requisites, and attendees must have at least 1 of the following certifications (or the equivalent experience level): -- IBM Certified System Administrator -- Db2 for z/OS -- IBM Certified Database Administrator -- Db2 for z/OS Cost $2,500 USD per client participant Client participants are responsible for their own travel, lodging, and meal expenses A registration link with payment instructions will be included in the invitation. Db2 for z 2020 Master Class Summary and Outline
Congratulations to the 2020 IBM Champions! IBM Champion Program Director Libby Ingrassia sent messages to the selected 2020 IBM Champions last night. Congratulations to all -- particularly new Champions! Libby posted a complete list of Champions, by competency, on the IBM Developer Blog. Congratulations to Frank Fillmore for being selected as both a Data and AI Champion and a System z Champion. Along with Frank, I am proud to have been selected as a Data and AI Champion. As long-time participants in the program we recommend it to anyone actively supporting the Db2 community -- through outreach efforts such as conference presentations, blogging and promoting IBM events, as well as internal events, such as mentoring co-workers and facilitating skills enablement for your peers. The goal of the program is to support -- and celebrate -- your success. If I can help guide you through the process so that you can be a 2021 Champion let me know. I would be happy to help! What are IBM Champions? From Libby's blog: "These individuals evangelize IBM solutions, share their knowledge, and help grow the community of professionals who are focused on IBM offerings. IBM Champions spend a considerable amount of their own time, energy, and resources on community efforts—organizing and leading user group events, answering questions in forums, contributing articles and applications, publishing podcasts, sharing instructional videos, and more. We have book authors and YouTube stars, as well as those who work behind the scenes as client, press, or analyst references. The program selects Champions annually based on individual contributions that go beyond the scope of a person's job, so that we can recognize and reward those who give so generously of their time, effort, and energy." Libby also hosts a Champions in Action series, coordinates Champion events at Think and IDUG conferences, and maintains a directory of all Champions. Keep up with the IBM Champions and their activities on Twitter either by @IBMChampions or by the #IBMChampion hashtag. Thanks Libby and Congrats 2020 Champions!!!
Mid-Atlantic Db2 LUW Meeting Thursday, 12/5The next Mid-Atlantic Db2 Users Group meeting is scheduled for Thursday, December 5, 2019 at IBM in Bethesda. There are some great speakers lined up and exciting topics -- see the full agenda below. The meeting is free, so please share the invitation with anyone you know who may be interested. And of course, please join us! Date: Thursday, December 5, 2019 Time: 9:30am -- 2:45pm Location: IBM, 6710 Rockledge Drive, Bethesda, MD 20817 Registration:* https://www.eventbrite.com/e/mid-atlantic-winter-db2-luw-users-group-registration-82353671047 *Pre-registration is required to enter the building -- don't forget! Agenda: 9:30am -10:30 SESSION 1 My Favorite Db2 Problem Determination Tricks presented by Pavel Sustr 10:30 -1045 BREAK 10:45 -11:45 SESSION 2 IBM Cloud Pak for Data presented by Brad Rowen 11:45 -- 12:45 -- Networking Lunch 12:45 -- 1:45 SESSION 3 Table Space Odyssey presented by Pavel Sustr 1:45 -- 2:00 BREAK 2:00-2:45 SESSION 4 Db2 Augmented Data Explorer Demo by Kay Groski
Collaboration at Work: Gold Consultants and IBM Data and AI Expert LabsCongratulations and many thanks to the IBM Data and AI Expert Labs team for their willingness to collaborate with the IBM Gold Consultants. Frank Fillmore and I met in February with Ritika Gunnar, who had just been appointed the new VP leading the IBM Data and AI Expert Labs team. Frank explained that he is an IBM Gold Consultant and we discussed our frustrations with the IBM's low utilization of skilled contract talent like the Golds, and Ritika said she would do some research and try to help. Frank was selected as a Gold Consultant in 1998 and considers it one of (if not THE) highest achievement of his career. There are approximately 40 Gold Consultants worldwide, all of whom are independent consultants. Each was selected by IBM and their Gold Consultant peers to participate in the program. Information on the Golds and their skills is on the IBM website Gold Consultant page. After our meeting with Ritika we soon met Business Partner Liaison Karla Rooney, who initiated a series of calls to discuss pipeline, pending needs and utilization. Karla introduced services sellers, Resource Deployment Managers and other colleagues in the Data and AI Expert Labs organization. Through these discussions we were able to introduce the unique experiences of the Gold Consultants and identify a few pending engagements where the Golds skills were needed -- and the momentum began to build. In August a group of Gold Consultants delivered a webinar to hundreds of Db2 for z/OS customers planning migrations to V12. Or, to be more exact, Db2 customers NOT at V12. The migration to V12 has been hyped as the last major migration planned for Db2 for z/OS, not because the database is going away, but due to the continuous delivery model. However, customers need to get to V12 to take advantage of continuous delivery, and unfortunately many have not begun the work. The IBM teams overseeing System z are concerned there will be a last minute rush to migrate to V12 and not enough consultants available to help. Enter the Golds, who delivered an excellent webinar on the V12, and who have been asked to support migration efforts contracted with IBM's Data and AI Expert Labs. The webinar was recorded and is available here. The net of all this is: thanks to Karla and Ritika and their teams, customers are now able to access the best independent Db2 talent on the planet through Data and AI Expert Labs. I hope your organization -- and everyone in the Db2 community -- has the opportunity to benefit from the value of this collaboration. Thanks Karla and Ritika!!
Plan for Replication Success with Education and Services from The Fillmore GroupIf your organization is considering a year end CDC acquisition and plan a 2020 implementation, consider training and services from The Fillmore Group to accelerate your success. The Fillmore Group is working to update the IBM Change Data Capture curriculum -- course KM020G -- adding optional sessions covering replication to Kafka and replication to and from PostgreSQL. Please note: customers purchasing replication licenses prior to year end may qualify for free PostgreSQL or Kafka education. Contact me if you are interested. In addition, our team is also ready to assist with replication Quickstart services. A TFG consultant will help your organization leverage the best features and functionality available in the IBM replication product family -- quickly! Training 2/3/20 -- 2/5/20 Change Data Capture Essentials. Prepare for planning, installing, managing and monitoring IBM replication with this IBM training class, KM020G. Cost: $2775. View the course outline: KM020G Change Data Capture Essentials 2/6/20 -- 2/6/20 CDC New Features -- Kafka and PostgreSQL. These 1/2 day sessions are designed to extend the KM020G class material with topics specific to Kafka and PostgreSQL replication. Cost: $350. Outline: Kafka and PostgreSQL Replication Class Module Abstracts Services Kafka Quickstart. Leverage expert technical assistance for a successful implementation. Overview: Kafka Replication Quickstart.PostgreSQL Quickstart. The Fillmore Group's PostgreSQL delivers a skilled consultant to work with your team to plan and execute a successful replication implementation. View the offering summary: Postgres Capture Quickstart.Remote Capture Quickstart. Work with a skilled replication expert to apply this new offering in your environment with services to help you design, install and administer replication away from System z, reducing MIPs consumption and lowering System z data replication costs. View the offering summary: Remote Capture Quickstart.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.
Torn Between IDUG and Think? Call for Speakers Closes Nov 12 – For BothThis month the International Db2 Users Group (IDUG) hosted their annual European conference in Rotterdam, and this week IBM is hosting the Data and AI Forum in Miami. With so many conference options it can be difficult to decide where to invest your organization's conference funding -- if you are lucky enough to have it available. One way to reduce attendance cost is to be a speaker, as conference presenters typically receive a free conference pass. You are still responsible for your travel expenses, but the overall cost will be greatly reduced. And of course end user conference presentations are always welcome and appreciated. One way to decide between IDUG North America (Dallas) and Think (San Francisco), is to submit presentation abstracts to both and see if you are selected. But hurry! The call for speakers is open for both; details are below. Think 2020, San Francisco, May 4 -- 7. Registration cost $1995-$2495. Call for speakers deadline November 12, 2019. IDUG North America, Dallas, June 8 -- 11. Registration cost $1865 -- $2295. Call for speakers deadline November 12, 2019. Coincidence??? Details on submitting presentation abstracts for IDUG are here. Details on submitting abstracts for Think are in the attachment below. Good luck!! Think 2020 Speaker Guidelines
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).