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.
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
Conference & Conference & Conference Oh My!!The buildup and push for the Think Conference was manic. The "EXCITEMENT!!" seemed to come from a small group of IBM marketing folks and the focus on attendance numbers (tough to confirm or deny) was odd. Customers and Business Partners focused on the data management component of the Analytics portfolio, and with a limited budget to attend conferences, seem to have shifted from the IOD/Insight/Think Conference to the International Db2 Users Group (IDUG) conferences. IDUG North America is held in the Spring, this year in Charlotte, South Carolina, from June 2 -- 6. The conference focus is education for IBM database technologies solutions. Artificial Intelligence and Machine Learning aren't the dominating topics, and session selections and content are managed by IDUG volunteers. IDUG NA 2019 costs $2165 to attend, with a $300 early bird discount available until April 22nd. Having IDUG to counterbalance Think makes sense to me. Also, the IDUG community is very user friendly. There are several discount options to make attendance affordable, and as has been the case at most technical conferences, presenters receive a free pass. Now -- the wild card. IBM, through their marketing collaboration with IDG, has scheduled another conference, this one called IBM Data and AI Forum, for Miami, Florida, from October 21 -- 24. This event is the former IBM Analytics University, which I believe evolved from the Db2 Technical Conference. It seems to be IBM's attempt to cross pollinate Db2 users with AI, not necessarily a logical partnership in my opinion, as the potential benefits of AI and Machine Learning seem to be in the conceptual sales stage, being pitched to senior management, while the technical teams running data centers aren't setting the analytics vision. The conference pass cost is far lower than IDUG or Think, at $1295 for a full price pass and $1095 with the early bird discount through July 31. The call for speakers is open and I understand selected speakers will be compensated for presenting. It will be interesting to see how the community responds to all these conference offerings. Hmmm...
Baltimore/Washington Db2 Users Group March Education SessionThe Baltimore/Washington Db2 Users Group will be holding our annual education session on Wednesday, March 20, 2019, at the BWI Hilton. Please note the date is the third Wednesday in March, not the second, when meetings are typically held, as several members will be attending SHARE. As a very special 2019 offer, the group will have two session tracks and two terrific presenters. You are invited to sign up for one of the two tracks. The cost per attendee is $100 and includes session materials and a sit down lunch with the entire group. Date: Wednesday, March 20, 2019 Time: 9:00am -- 4:00pm (Registration and continental breakfast at 8:30am) Location: BWI Hilton, 1739 W Nursery Rd, Linthicum Heights, MD 21090 Register: HERE For DBA’s IBM’s Robert Catterall will present, and for developers, Tony Andrews from Themis. Abstracts for their day-long sessions are below. Track 1: Db2 Database Administration Db2 for z/OS DBA’s: News You Can Use This day-long session for DBAs delivers updates on four topics pertinent to database administration. Each unique segment will provide up-to-date information on: Leveraging large z/OS LPAR memory resources for improved Db2 application performance.Key metrics for Db2 subsystem and application performance monitoring and tuning.DDF application architecture and workload management.Modern Db2 for z/OS physical database design.Presenter: Robert Catterall Robert Catterall is an IBM Senior Consulting Db2 for z/OS specialist. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's Db2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent Db2 consultant, he rejoined IBM in 2010. Robert is a past President of the International Db2 Users Group (IDUG), and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences and user group meetings, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/. Track 2: Db2 Developers New Application Features for Db2 12 Are you still coding and designing SQL from the 90’s? The last several releases of Db2 have brought quality new features that can be used to improve both functionality and performance for today’s complex applications. This event will help catch you up! Morning Segment: • Global Variables: Creation, Usage, Rules, V12 Enhancements • Transparent Archiving: Automatic Archiving of Data, Data Retrieval Options, Global Variables for Archiving • Sequence Objects: Creation, Usage, Sequence vs Identity • Advanced Groupings: Group By / Having Review , Grouping Sets, Rollup, Cube • OLAP Ranking Functions Upgrades: o Rank, Dense_Rank, Row_Number Review o Ranking Moving Sums and Avgs o Rows Between o Range Between o Partition By • SQL Set Operations: Union/Union All Review, Intersect/Intersect All, Except/Except All, Union Select Into Afternoon Session: • SQL Merge: Overview, V12 Enhancements • SQL : Select From Update, Select From Insert • SQL Piece-Wise Delete: V12 Enhancement • SQL Pagination: V12 enhancement • SQL QUERYNO: Review • SQL Procedural Language: Piece Wise Delete, Autonomous Processing, SQL PL support for Triggers • Performance Enhancements: o New Stage 1 Predicates o V10, V11 New Performance Review o V12 Performance Enhancements o Sparse Indexing o V12 Runtime Adaptive Indexing o V12 Fast Traverse Indexing Presenter: Tony Andrews Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDBMS application design, development and SQL programming --- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’. *the Baltimore/Washington Db2 Users Group is a non-profit organization funding a portion of this meeting. If registration levels exceed our funds the per attendee cost will need to be raised to offset expenses.
IBM Replication 2019 New Features Webinar #IBMAnalytics #IBMzThanks to my colleagues, Kim May and Ed Lynch, for a terrific IBM InfoSphere Data Replication (IIDR) new features webinar delivered today. The recording of the webinar is found here. These are the presentation materials: Data Replication Update 2019-02-07 -- Final
IBM 2019 Replication Updates – 4 in 45 Minutes – Featuring Kafka!Join replication experts Frank Fillmore and Ed Lynch for this information-packed webinar with news and announcements about IBM’s replication solutions. Whether you are a current IBM replication user, investigating replication for a new deployment, or working with a competitor’s solution, this webinar will help you understand what IBM offers today, and the enhancements that will help you succeed with replication in 2019. At a sprint! In forty-five minutes Ed and Frank will deliver an overview of IBM’s current offerings, the four most important 2019 enhancement announcements, and 3 special pricing offers that can help your organization realize significant savings. We know you want your data to be available when you need it and where you need it, and fast. We can help. Registration is required. Please register HERE. Date: Thursday, 2/7/19 Time: 1:00pm – 2:00pm EST Presenters: Frank Fillmore is the Founder and President of The Fillmore Group, Inc., an IBM Business Partner specializing in replication solutions in the IBM Analytics portfolio. Frank has been a Db2 Gold Consultant since 1998 and is currently an IBM Champion for both Analytics and System z. Frank frequently presents on cutting-edge topics at regional and international Db2 Users Group meetings and is an IBM authorized instructor for delivery of replication courses including Q Replication, ICDC and pureScale. Frank leads a team of expert consultants delivering presales, implementation and enablement support to IBM customers. Frank is currently supporting a pureScale implementation for a US Federal agency. Ed Lynch was with IBM for over 25 years as a leader and innovator in Data Analytics and Information Integration. Leveraging his balanced and diversified knowledge of data and Information Technology with business needs and capabilities, Ed consistently recommends and delivers best of breed technical solutions. A trusted advisor to his customers and colleagues, Ed’s cross-industry knowledge enables him to be an effective go-to resource, particularly for difficult and complex challenges, and his success in many diverse roles at IBM, including development, technical team management, marketing and sales, showcase his flexibility. Ed is currently supporting a complex replication implementation for a large, US-based financial institution.
SQL to Aid #Db2 for z/OS EBCDIC to Db2 for LUW Unicode Conversion #IBMAnalytics #IBMzDr. Sheldon Cooper of "The Big Bang Theory" regularly records a YouTube video called "Fun with Flags" so I'm going to call this blog post "Fun with SQL". Sheldon may be a future Nobel Prize winner, but I've been named an IBM Champion for Analytics and System z for 2019. The problem statement: a large US government agency is contemplating migrating a packaged application from System z to Linux. The current and future database repositories are Db2 for z/OS and Db2 for LUW respectively. As a System z Champion I've presented on the continued relevancy and efficacy of the IBM mainframe, but that's not the focus of this post. One of the challenges of porting data is the conversion of character encoding from EBCDIC (Extended Binary Coded Decimal Interchange Code) which is the legacy encoding protocol used on IBM mainframes and System i to Unicode. Db2 for z/OS supports Unicode, but I'm not going to address anything other than EBCDIC encoding at the source and Unicode at the target (Sorry, ASCII). In brief, EBCDIC represents an 8 bit binary encoding scheme that can represent 256 different characters. For example: the letter "F" (one of my faves) is represented as 1100 0110 in binary and C6 in hexadecimal. For national language support amid the variety of Single Byte Character Sets (SBCS) used around the world -- think the German umlaut (i.e. ä ö ü) -- the 256 byte universe of EBCDIC wasn't nearly enough. The Unicode solution is to use more than 1 byte to represent some characters. For example: the "¢" cent sign takes one byte to represent in EBCDIC, but 2 bytes in Unicode. select length(ebcdic_str('¢')) as EBCDIC, length(unicode_str('¢')) as Unicode from sysibm.sysdummy1;EBCDIC UNICODE 1 2This problem has manifested itself as an error when moving a CHAR(5) column of data from Db2 for z/OS to Db2 for LUW. If, say, the pesky "¢" is present in the string and all 5 characters are significant (i.e. no trailing blanks), the string won't fit in the same column width on the target platform. Most customers find this out the hard way when the Db2 for LUW LOAD command or IMPORT utility posts errors. There are two possible solutions: data cleanup (Do we really need the pesky '¢' in a Comments column?)lengthen the target columns to accommodate Unicode expansionBoth can be time-consuming and expensive and will depend on a variety of factors beyond the scope of this blog post. The purpose here today is to identify the extent of the problem before you actually try to port the data. I've constructed this SQL statement to do just that. select 'SELECT', rtrim(name)||', HEX('||rtrim(name)||') AS HEX, LENGTH(EBCDIC_STR('||rtrim(name)||')) AS L_EBCDIC, LENGTH(UNICODE_STR('||rtrim(name)||')) AS L_UNICODE FROM', rtrim(tbcreator)||'.'||rtrim(tbname), 'WHERE LENGTH(EBCDIC_STR('||rtrim(name)||')) < LENGTH(UNICODE_STR('||rtrim(name)||')) AND LENGTH(UNICODE_STR('||rtrim(name)||')) >', '( SELECT LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = '''||rtrim(tbcreator)||''' AND TBNAME = '''||rtrim(tbname)||''' AND NAME = '''||rtrim(name)||''' );' from sysibm.syscolumns where tbname like 'ICM%' and encoding_scheme <> 'E' and coltype in ('CHAR', 'VARCHAR');So what are we doing here? The SQL statement above scans the Db2 for z/OS catalog and generates SQL statements like the one below that compares the length of the data in a column represented in EBCDIC with the length of that same data represented in Unicode. It also compares the length of the Unicode representation of the data with the maximum column length. SELECT DEFAULTVALUE, HEX(DEFAULTVALUE) AS HEX, LENGTH(EBCDIC_STR(DEFAULTVALUE)) AS L_EBCDIC, LENGTH(UNICODE_STR(DEFAULTVALUE)) AS L_UNICODE FROM XXXX.ICMSTCOMPATTRS WHERE LENGTH(EBCDIC_STR(DEFAULTVALUE)) < LENGTH(UNICODE_STR(DEFAULTVALUE)) AND LENGTH(UNICODE_STR(DEFAULTVALUE)) > ( SELECT LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = 'XXXX' AND TBNAME = 'ICMSTCOMPATTRS' AND NAME = 'DEFAULTVALUE' );The columns that are evaluated are chosen by you in the last line of the first SQL statement that generates the list of candidates. This is where knowledge of the data is crucial. If, for example, you have a VARCHAR column of a maximum 500 bytes and there's typically no more than 50 bytes of data, you won't exceed the maximum length of the column even with a slew of special characters and rampant expansion. As such you might only be interested in smaller, fixed length columns. I only chose columns with tables that had a certain name pattern (ICM%) and column types of CHAR and VARCHAR. My IBM Gold Consultant confrères will point out that the only test that matters is wheter the maximum column length will be exceeded. The first predicate just determines if any expansion will occur. But remember: I'm channeling Dr. Sheldon Cooper and err on the side of completeness. Be sure to test this first in a non-Prod environment before turning it loose on Production. Also run it during times of light subsystem utilization. The first, master query runs quickly against the SYSIBM.SYSCOLUMNS table. The resulting scans will produce a lot of I/O. Let me know if this has been helpful. And to all a happy, healthy, and prosperous 2019!
2019 Events – Coming Soon!With 2018 coming to a close I am focused on plans for 2019. Our current plans are being driven by changes in IBM's services delivery model and product enhancements to be available in 2019. Change can be good! In 2018 IBM's Lab Services organization opted to extend their use of Business Partners to support customer engagements. Lab Services has long maintained relationships with skilled partners to augment their staff consultants; in 2018 this utilization was increased. The Fillmore Group staffed several Lab Services engagements and supplied half a dozen consultants to support a variety of engagements including implementations, migrations, healthchecks, and staff augmentation, supporting replication solutions InfoSphere Change Data Capture, pureScale, Kafka, and Q Replication, as well as Db2 and Hadoop. In staffing these engagements we became aware of several interesting customer situations and opportunities we hope will deliver better results to our customers in 2019. Through a chance conversation with a Federal agency looking to identify the best replication tools for their next generation applications, we learned about some enhancements to the replication portfolio solutions expected to be delivered in 2019. To support our IBM colleagues in spreading the word about the upcoming enhancements, and to (no surprise!) encourage customers to contact us if they are in need of support, the 2019 schedule of events below was drafted. Some of these "events" consist primarily of outreach to customers who may be interested. If these apply to you, feel free to contact me for more information. Here's to a busy 2019! 1. CDC Healthcheck Services. Delivery through Lab Services. a. Audience: current CDC customers considering new replication environments and/or looking to better support current replication. b. Tasks/activities: a review of current replication environments, staff enablement, monitoring review, performance tuning and/or planning new replication environments. c. Deliverables: Healthcheck report, enablement recommendations, plan for new replication sources and targets. 2. IBM Replication Roadmap Webinar. a. Audience: current and prospective replication customers. b. Content: a review of current and new replication offerings. c. Deliverables: recommendations/actions needed to initiate CDC purchases. 3. Kafka Webinar. a. Audience: current and prospective customers looking to replication to Kafka. b. Content: a review of Kafka, use cases, and where Kafka is best deployed. c. Deliverables: recommendations/actions to initiate Kafka deployment. 4. Replication Whitepaper. a. Audience: current and prospective customers. b. Content: TBD – replication competitive options, pricing, and/or Db2 for z data focus. c. Deliverable: whitepaper explaining IBM replication options compared with competitor solutions. 5. Kafka Quickstart Services. Delivery through Lab Services. a. Audience: customers implementing replication to Kafka. b. Tasks/activities: Kafka installation, replication set-up, and staff enablement. c. Deliverables: data replicating to Kafka. 6. Kafka Training – Extending KM020G ICDC Class a. Audience: new Kafka customers. b. Tasks/activities: instructor-led modules to demonstrate and explain Kafka implementation and administration. c. Deliverables: 2-days of formal classroom instruction with hands-on exercises. 7. IAS to IAS Replication Quickstart Services. Delivery through Lab Services a. Audience: customers implementing IAS to IAS replication. b. Tasks/activities: Software installation, replication set-up, and staff enablement. c. Deliverables: IAS replication, monitoring in place. 8. Competitive Replication Webinar. a. Audience: Oracle GG and Attunity customers. b. Content: a review of the advantages of IBM replication solutions. c. Deliverables/action items: action plan to PoC IBM replication offerings.
Celebrate DB2 in the Baltimore-Washington-NoVA Area!December User Group Meetings Coming up in December are two (yes 2, TWO!!) Db2 Users Group events in the Baltimore-Washington-NoVA area: first, the Mid-Atlantic Db2 LUW group is scheduled to meet December 6th in Bethesda. This meeting is sponsored by IBM, there is no fee to attend, and features two sessions on Data Server Manager with DSM Offering Manager Peter Kohlmann, and a session on the future of Db2 by Dr. Jon Lind, the Db2 Product Offering Manager. This meeting is being held in conjunction with Washington Area Informix Users Group, and we are looking forward to sharing lunch and networking with their session attendees. Registration is required; register HERE. Details on the Mid-Atlantic Db2 sessions and the registration link (registration is required) are below; information on the Washington Informix sessions is HERE. The following week, the Baltimore/Washington Db2 Users Group will host our quarterly meeting Wednesday, December 12th at the BWI Hilton. The day's sessions include presentations by IBM's Master Inventor Terry Purcell, along with 3 (yes, 3!) user presentations, from Steve Cricchi, and NFCU's Joe Huang and Joe Watson. Details on the sessions and agenda are below, and attached. Registration is required; register HERE. If you are in the area, please join us. And if you are going to join us, bring a friend! Mid-Atlantic Db2 User Group Meeting Sponsored by IBM Date: December 6, 2018 Time: 10:00am – 3:00pm (registration opens at 9:30am) Location: IBM, 6710 Rockledge Drive, Bethesda, Maryland 20817 Cost: There is no cost but attendees must pre-register HERE Agenda: 9:30am – 10:00am Registration and Continental Breakfast 10:00am – 11:15am Data Server Manager, Part 1. Peter Kohlmann, presenter 11:15am – 11:30am Break 11:30am – 12:45pm Data Server Manager, Part 2. Peter Kohlmann, presenter 12:45pm – 1:45pm Lunch, sponsored by IBM 1:45pm – 3:00pm What’s New in Db2? Jon Lind, presenter Session Abstracts Data Server Manager, Part 1 Learn about the latest trends, directions and updates to the full line of Data Management Consoles for the Db2 family of offerings from ground to cloud. Where are we today, what is our vision and how are we getting there. Data Server Manager, Part 2 Go on a deep dive of how to monitor the overall performance of your Db2 family database. Learn how to dive deeply into the three levels of statement monitoring and choose which to use for your specific challenge. And learn how to use Db2 Workloads to surgically decompose your database performance by application and by user to see exactly who is doing what. What’s New in Db2? In this session attendees will gain an understanding of IBM’s Db2 product roadmap. IBM’s current strategy and plans for Db2 include increased functionality and support for a variety of deployment options – on premise, cloud, and several “mix and match” offerings. Presented by IBM Db2 Product Offering Manager Dr. Jon Lind, you will gain an understanding of IBM’s plans for the future of Db2. Whether your organization has been running Db2 for LUW for years or weeks, or if you are just beginning to consider Db2, this session will provide an excellent summary of what’s available today and what IBM’s investment in Db2 will deliver in the future. Presenters Peter Kohlmann Peter Kohlmann has been a member of the IBM database and Analytics development and product management teams since Version 2 of Db2 for Linux, UNIX and Windows. He is currently an IBM Offering Manager with a focus on tools for database and data services and IBM Data Server Manager used for the Db2 family. He was one of the original developers and designers of the Db2 Control Center and also created the Technology Explorer for IBM Db2 open source project. As the Db2 Release Manager he oversaw the delivery of Db2 for LUW 10.1 and 10.5 and he also directed the new technology adoption program for Db2 pureScale Version 9.8. Jon Lind Jon Lind is the Db2 for Linux, UNIX and Windows Product Manager, supporting one of the largest software products at IBM. Dr. Lind’s responsibilities include managing, positioning, marketing, and deploying Db2. He works with customers, internal product teams and key partners to drive product enhancements as well as the IBM marketing, sales and channel teams to determine the various routes to market for successful product launch and go-to-market campaigns. Prior to this role he held various technical positions in the IBM Toronto Lab and IBM Beaverton Lab, from technical development, project management, technical support, to management. With his solid technical background and broad experience in many areas of enterprise software business, Dr. Lind has assisted customers across all geographic areas at all levels – from development to C-level executives. Washington Area Informix Users Group (WAIUG) Meeting Sponsored by IBM Date: Thursday, December 6, 2018 Time: 9:30am – 2:30pm (registration opens at 9:30am) Location: IBM, 6710 Rockledge Drive, Bethesda, Maryland 20817 Cost: There is no cost but attendees must pre-register HERE Session Abstracts Docker & Informix – What can Docker do for you? Presenter: Darin Tracy Understand what Docker is, how it works. How to create an Informix Docker image and best practices. Docker containerization is the first step into using Kubernetes as a fault tolerant clustering service. Darin began working for Informix in 1994 and continues to work for IBM now. He has worked in the openlink support group, and the Down Systems Group and has been with the APD (RT) group. Darin has presented at many IIUG events as well as many internal classes to IBM support. Informix roadmap – Where do we go from here? Presenter: Karen Qualley What might we expect from Informix in 5 years? Join IBM to learn about the Informix roadmap and what the team is working on. Informix HCL Licensing Presenter: Karen Qualley Information about changes and plans for the Informix licensing model from HCL. Baltimore/Washington Db2 Users Group -- sponsored by IBM Date: Wednesday, December 12, 2018 Time: 9:00am – 3:30pm (registration at 8:30am) Location: Hilton BWI Airport, 1739 W Nursery Rd, Linthicum Heights, MD 21090 Fees: $30 Pre-registered and $40 At-the-door Register: HERE Agenda: 9:00am – 10:15am Optimize Db2 for z/OS with Machine Learning using IBM Db2 AI for z/OS Presenter: Terry Purcell, IBM 10:15am – 10:30am Break 10:30am – 11:45am Db2 12 and Continuous Delivery -- What's New from the Optimizer? Presenter: Terry Purcell, IBM 11:45am – 12:45pm Lunch Sponsored by IBM 12:45pm – 2:00pm Automating Accelerator Batch Loads in Single Instance Environments Presenter: Steve Cricchi 2:00pm – 2:15pm Break 2:15pm – 2:45pm Using and Implementing the Db2 Profiles Presenter: Joe Huang, NFCU 2:45pm – 3:30pm NFCU Db2 12 Migration Experience Presenter: Joe Watson, NFCU Session Abstracts Optimize Db2 for z/OS with Machine Learning using IBM Db2 AI for z/OS Terry Purcell, presenter Machine learning is now prevalent in our day to day activities as it helps us make better data driven decisions. Therefore, it makes sense to extend that same technology to help tune performance for Db2 for z/OS. Db2 AI for z/OS applies machine learning insights from your workload characteristics to empower the Db2 optimizer and find better access paths for SQL queries. This offering enables clients to see out-of-the-box CPU and elapsed time savings. Db2AI for z/OS embeds machine learning and IBM domain expertise to provide customized recommendations for performance tuning. Learn how Db2AI for z/OS applies IBM Machine Learning for z/OS to better optimize Db2 for z/OS performance. Db2 12 and Continuous Delivery -- What's New from the Optimizer? Terry Purcell, presenter DB2 12 for z/OS has been announced and DB2 has embarked on Continuous Delivery for ongoing features. So what's coming from the optimizer team regarding further performance enhancements? DB2 12 for z/OS had already delivered outstanding performance and scalability improvements from UNION ALL and outer join performance improvements, sort optimizations, improved predicate indexability and tighter integration of the Optimizer and RUNSTATS. This presentation will outline what was delivered and how future optimizer enhancements apply to continuous delivery. Automating Accelerator Batch Loads in Single Instance Environments Steve Cricchi, presenter When concurrency is not needed for warehouse applications it is possible to use standard z/OS tools to load a Db2 Analytics Accelerator without sample programs or 3rd party tools. See the mechanics of how to do this for a cycle-driven process with a high degree of usability and easy job output management. Using and Implementing the Db2 Profiles Joe Huang, presenter How to implement the Db2 Profiles at your shop with real life use cases. The presentation will show you how to configure and activate a Db2 Profile. The components of PROFILE tables and the relationship between PROFILE and ATTRIBUTE table. The presentation will also introduce the Navy Federal Credit Union use cases such as: to control number of active DBAT threads, to control IDLE THREAD TIMEOUT, bind DISTRIBUTED packages using multiple COLLID and Simulate PROD environment in TEST to trick optimizer. NFCU Db2 12 Migration Experience Joe Watson, presenter Navy Federal Credit Union recently migrated DB2 to V12 from V11. The migration occurred 'online' where production workflow continued to process without interruption. This was a major achievement for increased system availability / less system downtime, and the first major software implementation of this type for NFC. This implementation also ranks among a very few number of organizations that have done online migration. This presentation will outline the basic concepts pertinent to the NFC DB2 system configuration that enabled online migration to be pursued, along with challenges that existed and the approaches to resolve them. Presenter Bio’s Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where he is lead designer for the Db2 for z/OS Optimizer. Terry has 25 years of experience with Db2 in SQL Performance and optimization as a customer, consultant and Db2 developer. Terry is an IBM Master Inventor with more than 25 U.S. patents for database search Technology. Steve Cricchi has over 25 years of Db2 DBA experience starting with V1.3. He currently supports Db2 applications on V11 for a major financial organization. Joe Huang is a Certified Db2 DBA with 30 years of IT experience. During his career, Joe has held several job roles in Application Programming, Db2 z/OS system administration, IBM Mainframe System Architecture and Db2 z/OS Database Administration. Joe is an IBM Certified Db2 V11 Database Administrator and an IBM Certified Db2 V11 System Administrator. Joe plays Classic Guitar and he performs at a local 5 star rated restaurant in Northern Virginia. Joseph Watson is a Senior DB2 database administrator with Navy Federal Credit Union, with experience as database and system administration since version 1.3. Joe earned Master of Computer Science degree from Howard University; Certificate In Information Systems from George Washington University. Previous duties include DB2 administration, IMS programming, CICS programming, application consulting/training for EDS, Verizon, and consulting/training for IBM including government top secret security assignments. In a past life Joe was a science and math teacher for the MD Montgomery County school district. Db2 and Informix Users Groups 12.6.18 Agenda Baltimore Washington Db2 Users Group 12.6.18 Agenda
Time to be ThankfulIt's the time of year to reflect on what we are thankful for and in this spirit Frank and I had a discussion recently about the many terrific colleagues and customers we've had the opportunity to work with over the past year, and how much we appreciate their impact on the success of The Fillmore Group and our lives. Many thanks! Too often we become frustrated with the day-to-day "churn" of doing business as an IBM Business Partner, but our shared efforts have resulted in many positive outcomes for us as individuals, and for our organizations' ability to leverage IBM solutions. Two individuals deserve special recognition for their efforts: Susan Lawson and Ed Lynch. Both have demonstrated how deep technical skills and a positive outlook contribute to the Db2 community. Susan, as a Gold Consultant, introduced her network of Golds to an IBM team responding to an enterprise customer's "SOS!" after a significant performance issue. The customer recognized their need for expert assistance and IBM reached out to Susan. Susan in turn recommended the Gold Consultants as a resource ready and willing to assist. As Frank Fillmore has been part of an effort by the Golds' leadership team to better integrate their skills with IBM's consulting practices, her willingness to promote their skills and abilities reinforced to the IBM team, and to the Golds, the availability of this skilled community of consultants looking for ways to connect and support IBM customers. Rather than just keeping her head down and focusing on the specific tasks assigned to her, she raised her hand and introduced a whole team of colleagues ready to help. Thank you Susan! Ed, as an IBM technical expert and evangelist, found himself "retired" earlier this year and reached out to group of colleagues indicating his interest in returning to work. Coincidentally, IBM Lab Services transitioned their services model from utilizing inhouse/staff consultants to using Business Partner resources to support certain technologies in their portfolio. While Lab Services has long maintained subcontract relationships with IBM Business Partners to extend their "bench" resources, partners have been used infrequently and often as a last resort. This new initiative was unfamiliar territory and "mismatched expectations" is perhaps the most positive spin I can put on it. Ed cheerfully and professionally responded to cycles of administrative drama, unclear customer requests, overseas travel and constant uncertainty as to what was coming next. Thanks to his efforts several IBM replication customers were able to obtain the support they needed to be successful. Thank you Ed! To Susan and Ed -- with special thanks -- Happy Thanksgiving!!
Starting to Think About ThinkLast year Frank and I chose not to attend Think in Las Vegas. While I missed the networking (socializing/fun) part of conference, it didn't feel like a "must attend" event, as the Information on Demand and Insight Conferences had in the past. And, since we didn't go to Think, Frank and I instead attended IDUG Europe in Lisbon, which was awesome. Lisbon was stunningly beautiful, the people at the conference were great fun and the technical discussions were focused on Db2's future, which is of course important to The Fillmore Group. So then why am I thinking about attending Think 2019? I’m curious… First, my grudging acceptance of the shrinking role data management is playing in IBM's strategy has me curious about what the future holds. As I write this Bain Capital has recently acquired Rocket Software, and the rumor mill is churning with theories on what will happen to Db2 for z/OS and the mainframe. Do I expect a great announcement at Think, or insight into IBM's strategy that will shape our business plans? No. But I think the conversation -- with customers and colleagues -- will help guide The Fillmore Group's focus over the next few years. Second, I find IBM listens to Business Partners less and less each year. The Partnerworld program has always been a source of frustration to me, as the rules and guidelines seem thinly disguised to hide IBM's intention to work with a handful of partners, and exclude the rest. I recognize The Fillmore Group IS a small partner, but one with deep technical skills and a lot of history with some of IBM's key customers, so I have often attended conferences almost solely for the opportunity to meet with IBM management about ways to improve Partnerworld. The concepts I pitched -- crazy concepts like accountability, transparency, and support for partners teaming -- were often given 15 minutes and a, "gee it would be nice if we could". However, once in a while I felt my ideas were heard and given consideration. My requests to meet with IBM execs to discuss my concerns -- a "partner benefit" -- were denied at the last two conferences I attended. And earlier this year at a partner event when I asked a question about the percentage of sales leads being passed to IBM's largest (and most favored) partners the presenter shrugged and said, "We all know this is a relationship business." So do I think someone will actually solicit my input on the current state of Partnerworld and consider changing Partnerworld to facilitate the success of smaller partners? No, I do not. However, there may be an opportunity to discuss IBM's poor channel support with other Business Partners, and I’m interested to learn what others are doing to succeed in spite of Partnerworld’s shortcomings. Third, I want to see which customers post. I understand overall conference attendance numbers will be inflated, and the ratio of IBM’ers to customers will be high. However, with so many customers announcing their “Cloud First” and mainframe modernization projects, it will be interesting to see who attends and which sessions are popular. I’ve watched attendance at my local users group decline about 30% over the past two years and I know the members no longer attending are busy with other initiatives. Think should be a good market test as even customers whose passes are paid for by IBM are typically responsible for their own travel expenses. The net: I plan to attend because I am curious. If you are too, I look forward to seeing you. Registration is open, with an early bird discount. Here’s the IBM announcement and registration info: Think is IBM's flagship conference, focused on delivering the technical training, certifications, expertise, and networking opportunities you need to stay ahead. Designed with your goals in mind, Think 2019 will help you find the technologies your company needs to grow and thrive. You can sharpen your skills through 1,700+ technical and business sessions, 350+ technical breakouts, and hundreds of hands-on labs and certifications. You'll learn how to unlock new opportunities with the latest advances in cloud, AI, IT infrastructure, data, and more. You can even work with IBM experts one-on-one to solve your toughest challenges. And, of course, there will be many chances to expand your network with thousands of peers, IBM Business Partners, and thought leaders throughout the week. Register now to save $300 with early bird pricing, access the best deals at choice hotels, and be among the first to plan the trip of a lifetime as Think takes over San Francisco! Learn more and register today at https://www.ibm.com/think