Win a *FREE* Pass to IDUG North America!

Posted by Kim May on April 4, 2018 under Baltimore Washington DB2 Users Group, International DB2 Users Group (IDUG), TFG Blog.

All Baltimore/Washington Db2 Users Group Members are invited to participate in a drawing for a *free* IDUG pass – a $2195 value, thanks to IBM and the World of Db2.

The annual International Db2 Users Group (IDUG) North America conference is scheduled for April 29th – May 3rd in Philadelphia, PA.

To participate in the raffle you must register as a member of the World of Db2  and join the Baltimore/Washington Db2 Users Group on the World of Db2.

You must also agree to be part of an IBM promotion announcing free pass winners.  This will include uploading a photo of yourself on the World of Db2.

To join our group on the World of Db2 click on “All Groups” and select the Baltimore/Washington Db2 Users Group.  Once you’ve completed the process to join us please send an email to the board letting us know you’ve joined:  board@bwdb2ug.org.

The winner will be selected at our board meeting on April 12th.

Please note:  Government and government-owned entity employees are ineligible, as are IBM Business Partners and IBM employees.

I hope to see you on the World of Db2 and at IDUG in Philadelphia!

Baltimore/Washington Db2 Users Group Annual Education Event – Wednesday, March 14th

Posted by Kim May on March 2, 2018 under Baltimore Washington DB2 Users Group, DB2 for z/OS, IBM Champion, SQL Tuning.

I am looking forward to the Baltimore/Washington Db2 Users Group March education meeting – in our new meeting location, the BWI Hilton!!  After months of discussion the board decided this location offers our members convenience, better traffic routes and an improved lunch facility (the Flight Deck; even sounds fun!)

The meeting is scheduled for Wednesday, March 14th, from 9:00am – 4:00pm.  The cost is $250 in advance and $350 at the door.  Register HERE.

March is of course the group’s annual education session.  This year the group has invited Tony Andrews of Themis to present.  Tony’s full-day session consists of topics selected specifically to assist developers with Db2 SQL programming performance and best practices.

Attendees will gain knowledge of SQL programming, performance and tuning, and the SQL-PL native Stored Procedure language.

The material provided to each attendee will include:
– SQL Standards and Guidelines
– SQL coding best practices
– SQL-PL coding best practices
– Many great SQL examples on rewrites
– SQL and program tuning tips
– SQL and program tuning step by step processes

Session Topics:
? Learn the top reasons for poor performance
? Learn our top SQL rewrites every developer should know
? Learn our top SQL Tuning Tips for developers
? Learn our top reasons why you have to watch out for null columns
? Learn the top reasons why developers need to know their data
? Learn what filter factors are and why they are so important
? Learn our top 10 steps to tuning a query or program
? Learn our top SQL-PL stored procedures best practices

Presenter Tony Andrews, Themis Inc., Consultant and Trainer
Tony Andrews has more than 25 years’ experience in the development of relational database applications. For 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 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 and training.  His main focus is to teach today’s developers the ways of RDMS 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’.

Congratulation to the 2018 IBM Champions!

Posted by Kim May on February 12, 2018 under Baltimore Washington DB2 Users Group, Frank Fillmore, IBM Champion, TFG Blog.

My post is a bit late – and a bit self-referential. But sincere!

Congratulations to all the 2018 IBM Champions!!!

According to the IBM “Champion of Champions” Libby Ingrassia, IBM reviewed more than 1400 nominations, and selected 650 Champions for 2018.

The Champions program recognizes and rewards independent IT professionals, business leaders, developers, and educators who influence and mentor others to help them innovate and transform digitally with IBM software, solutions, and services. Champions invest time supporting community efforts – coordinating users groups, writing articles and blog posts, presenting at conferences – and in a variety of ways that enable users to connect with the IBM community and succeed with IBM solutions.

I am extremely proud to recognize so many names on the list who have worked with The Fillmore Group over the years, and who not only succeed in some of the most challenging customer environments, but take the time to share what they’ve learned with others and continue to support and promote the community.

Libby has the names of all the 2018 IBM Champions in her January 31st blog post, and more interesting information on the program as well.

Congrats!!!

2018 Events – So Much To Do!

Posted by Kim May on January 22, 2018 under Baltimore Washington DB2 Users Group, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Stars, Frank Fillmore, IBM Champion, IBM Mid Market Customers, IBM Think Conference, IDAA, TFG Blog.

With IBM’s consolidation of conferences resulting in the cancellation of last Fall’s World of Watson/Insight/IOD Conference, and the merge into March’s upcoming Think conference, Db2 users have several educational event options to consider.  With training and education budgets continuing to shrink, and the use of contractors (who need to be billable, and know everything already, right?) growing, getting funding and approval to attend events is more challenging than ever.

However, with so many choices, I hope you will find something that’s a good fit, and have the opportunity to network with the Db2 community.   Here’s a short list of the events I am hoping to attend – and why:

Hands-on IDAA/IIAS Training, Date TBD (February or March), Baltimore, Maryland

Frank Fillmore is developing a new 2-day hands-on training class to introduce the IBM Db2 Analytics Accelerator (IDAA) and it’s new version, the IBM Integrated Analytics System (IIAS), featuring BLU Acceleration and available as an appliance or a z/Linux software solution.  Class will focus on use case development, determining the right fit deployment option for your organization, implementation and administration.  Frank has been delivering similar classes since the release of the IDAA and has helped many System z customers understand the accelerator value.

Why attend?  The IDAA/IIAS solution is an incredible addition to the System z environment, Frank is an excellent presenter, and class is *FREE*

To register:  keep an eye on our blog or email me if you would like me to notify you when class is scheduled.

 

Baltimore/Washington Db2 Users Group Education Session with Themis, Wednesday, March 14th, BWI Hilton, Linthicum Heights, MD

Every March the Baltimore/Washington Db2 Users Group offers a full-day education session.  These sessions are evaluated by our board and intended to provide the best local full-day of training available in the area each year.  The March session will be delivered by IBM Champion and author Tony Andrews from Themis, and will focus on SQL programming, performance, and tuning, as well as the SQL-PL native Stored Procedures language.

Why attend?  The annual education day presenters reads like “Who’s Who in Db2” and the sessions are consistently terrific.  Tony is an excellent presenter, the event is local for Baltimore/Washington area Db2 users, and it’s our group’s first meeting at our new BWI Hilton location.

To register:  visit the Baltimore/Washington Db2 Users Group webpage.

Cost:  $250 in advance and $300 at the door.  The fee includes materials and a sit-down lunch.

 

Think 2018, March 19 – March 22, Las Vegas, NV

IBM has consolidated several technical conferences into Think, with the conference topics covering AI, Cloud, Data, Security, and Systems.  As last year’s World of Watson/Insight/IOD annual data-centric conference was cancelled, Db2 users are interested in better understanding IBM’s direction and how the continued IBM transformation will impact their organizations.

Why attend?  This is usually the largest annual gathering of Db2 users.  Great networking, excellent presenters, superb people watching.  Maybe some answers to those nagging “what’s next?” questions??

To register:  visit the Think registration page.

Cost:  $2,295 for the week; $895 for a single day pass.  *Before registering ask your IBM rep for help with the cost of the pass.*  😉

 

IDUG Philadelphia, April 29 – May 3, Philadelphia, PA

The annual North America Db2 conference will be held in downtown Philadelphia this year, an easy and inexpensive commute for Mid-Atlantic organizations like The Fillmore Group.  The IDUG conference is where the Db2 community and IBM are focusing on the delivery of hard-core technical content.  With 5 days of education sessions, workshops, over 100 technical briefings and an experts’ panel, this year’s IDUG conference, while smaller than Think, will likely offer the best technical education value for Db2 users.

Why attend?  IDUG will deliver top-notch Db2 technical presenters and presentations.  Great networking and friendly – very community focused.

To register:  visit the IDUG North America 2018 conference webpage. 

Cost:  $1,865 through March 16 (early bird).  Need help funding a conference pass?  There are many discounts and community offers – contact the IDUG Conference Planning Committee (CPC) for help.

2018 New Year’s Resolutions – Let’s Get Started!

Posted by Kim May on January 4, 2018 under Authorized Training Partner, Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, DB2 Migrations, Frank Fillmore, IDAA, Oracle, TFG Blog.

As always the holidays are over too soon.  Here at The Fillmore Group we are back to work, starting the year with the usual goal setting and head scratching.  Three initiatives we worked on in 2017 showed a great deal of promise but never seemed to quite gain the traction we had hoped for.  So, unlike in prior years when I would start with a blank page, I am committing myself to pushing these three harder in 2018, as all three offer terrific options to maximize the value of an organization’s data assets.  These are:

Oracle to Db2 database migrations.  Last year IBM offered discounted Db2 licenses to current Oracle customers – and when I say “discounted” I mean practically gave them away.  Frank Fillmore and I delivered several competitive migration presentations and got lots of positive feedback from Oracle customers.  Still, we didn’t see a lot of Db2 adoption from these folks and I’m sorry – for them and us.  This is a head-scratcher, because I’m not sure where we are getting snagged, but we need to figure it out in 2018.

IDAA/IIAS/HTAP vs. “edge systems”.  Admittedly 2017 was a bit of a transition year for the IBM Db2 Analytics Accelerator (aka the IDAA) as IBM completely revamped the design, replacing the Netezza-bolted-to-a-mainframe with 2 Db2 BLU Acceleration-based options to deliver the Hybrid Transaction Analytic Processing (HTAP) capability.  Meanwhile in 2017 analysts were predicting that edge systems are the future – sounding frighteningly like they did in the late 1990’s when the standalone data warehouse was the next big thing.  It makes absolutely no sense to me to build out a completely new system, particularly on the periphery of an organization’s most secure system, to perform analytics when IBM has clearly demonstrated you can leave the data in place and perform both your OLTP and analytic processing in tandem.  We need to continue to educate customers to ensure they understand the overall value – reducing complexity, reducing cost, and keeping data secure.  The new BLU-based version has a new name:  IBM Integrated Analytics System – IIAS.

Supporting the Db2 eco-system.  This is such a no-brainer but one that needs constant attention, effort and input to maintain.  IBM formal classroom education offerings are minimal.  Conferences – IBM and IDUG – are changing and it’s difficult to determine which is most appropriate to attend.  Users groups (including the Balto/Washington Db2 Users Group) are struggling to provide our users with unbiased product information, education and resources.  We aren’t giving up and hope the greater Db2 community continues to work to stay active and involved within the community and within our individual organizations.  If we want to stay relevant we need to stay involved.

Happy 2018!  Off to work!

QMF Analytics for Multiplatforms – September Baltimore/Washington DB2 Users Group

Posted by Kim May on August 16, 2017 under Baltimore Washington DB2 Users Group, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IBM DB2 Services, TFG Blog.

Frank Fillmore just finished delivering a webcast with IBM’s Steve Mink and Doug Anderson, hosted by Blanca Borden, on the just-released QMF Analytics for Multiplatforms solution.  For the many QMF for z users, this new GUI-based solution offers the opportunity to extend the use of the objects, forms, queries, etc., an organization has developed over the years.  The session was recorded and I will post the recording link as soon as it’s available to view.

For the September 13th Baltimore/Washington Db2 Users Group Frank will reprise his presentation and deliver a demo on QMF Analytics for Multiplatforms.  The meeting is being sponsored by SEGUS and will include 4 presentations – 2 from SEGUS’s Ulf Heinrich and 1 from IBM’s John Iczkovits in addition to Frank’s.  Summary session abstracts are below.   Complete abstracts, speaker bio’s and registration information will be available later this week on the Baltimore/Washington DB2 Users Group website (www.bwdb2ug.org).  I hope you will join us if you are in the area!

Session 1:  Ulf Heinrich – Compliance with Compliments!  Viable Db2 Workload Tracking

Audit and Compliance is one of the big challenges companies are facing these days. This presentation shows how the entire DB2 workload can be tracked without the overhead of a trace, or monitor, enabling to answer Who did What When ? whenever needed.

Session 2:  Ulf Heinrich – Db2 12 Continuous Delivery

Starting with version 12  Db2 goes agile and code fixes, as well as new features and functions, will be delivered in a continuous stream, so called Continuous Delivery. While this change intends to make new technology available faster than in a three-year cycle it will also differ from how we did DB2 migration and testing before.  This presentation provides an overview about Db2 Levels and how they affect the Db2 subsystem, the
Catalog/Directory, SQL and DDL. More importantly, you will see how changes can be applied safely and what levels of quality assurance and testing can be passed to assure Continuous Delivery goes well with Continuous Availability.

Session 3:  John Iczkovits – DB2 for z/OS is in The Cloud! Using z/OSMF to Install, Migrate, and Provision DB2

These are exciting times and you may not realize it, but Db2 for z/OS is in the cloud! You may be thinking, what exactly does that mean? Many of your z/OS colleagues are already using z/OSMF for all sorts of functions. Come learn how to use z/OSMF to manage Db2 software, install, migrate, and provision data for Db2 and what the cloud means to us.

Session 4:  Frank Fillmore – QMF Analytics for Multiplatforms

In July, QMF Analytics for Multiplatforms became generally available.  Like QMF for z/OS, this solution delivers QMF’s visualization, dash boarding and graphical ad-hoc query capabilities, and enables users to leverage their existing QMF assets – queries, forms, procs from legacy QMF.  In this session Frank Fillmore will provide an overview of the features of QMF Analytics for Multiplatforms and perform a demonstration that includes new updates to QMF’s data visualization interface.

IBM Reinvents Partnerworld – Ravages the Partner Ecosystem

Posted by Kim May on August 2, 2017 under Baltimore Washington DB2 Users Group, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Training Services Delivery Partner, TFG Blog.

I just received an email from IBM’s Partnerworld program notifying me that as of August 1, 2017, The Fillmore Group, after ten years as a Premier IBM Business Partner (the highest program level), is now officially a Registered Business Partner, the lowest level in the program.

We still have a team of expert consultants.  We are still authorized to deliver most IBM courses in the Analytics brand family curriculum.  We are still actively promoting, influencing and reselling IBM Analytics solutions.  I am still Chair of the Baltimore/Washington DB2 Users Group and an IBM Champion.  Frank is still a Gold Consultant.  Several of our consultants are IBM Champions and Golds.  IBM simply won’t programmatically acknowledge that our skills have value any longer.

IBM claims to value partners with skills, but by they are lying.  The truth is the two factors determining partner level in the new Partnerworld system are software sales and customer references. 

Is it a coincidence that IBM is struggling with sales (21 straight quarters of declining revenues) and the company has historically been terrible at getting customer references?  Sadly, great technology followed by poor quality and expensive implementations and enablement support don’t add up to gushy customer success stories.

In the new program, without sales of $1,000,000 or more in a single product family a Business Partner cannot be granted a product “Competency” designation – no matter how many times they have implemented a solution, how many customers they have trained, and/or how many presentations and webinars they have delivered to help current and prospective customers understand the value of IBM’s solutions.

In the new IBM world, that’s not “competency”.

So like many of IBM’s “reinvention” efforts over the past five years, the “new” Partnerworld program is essentially the same old program, with new, onerous requirements designed to eliminate specialty partners (like The Fillmore Group) and I suppose reduce IBM’s burden of managing their partner network.

Because like who needs an extensive network of partners promoting an incredibly complex portfolio of products and solutions??  Heck, why not just funnel business to a handful of partner organizations and keep things simple.  Maybe reduce channel support headcount by 10 or 15 people.  Woohoo.  Think small.

After I received the email notifying me of our program level demotion I tried to log in to Partnerworld to review the program offerings for our new, low level.  And like so many things in today’s IBM world, the response was sad, heartbreaking and terribly frustrating – apparently they can’t keep the program website up.  Need a high availability solution???

 

 

$5!! – June 14th Balto/Wash DB2 Users Group Meeting

Posted by Kim May on May 31, 2017 under Baltimore Washington DB2 Users Group, DB2 for z/OS, DB2 Stars.

The 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.

Baltimore/Washington DB2 Users Group – March Education Session with Susan Lawson

Posted by Kim May on February 27, 2017 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, TFG Blog.

I 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

Kim May Takes the Reins at Baltimore/Washington DB2 Users Group @IDUGDB2 @IBMzAnalytics

Posted by Frank Fillmore on February 2, 2017 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/Linux, DB2 for z/OS, IBM Champion, IDAA, International DB2 Users Group (IDUG). Tags: , , .

My colleague, Kim May – Vice President of Business Development at The Fillmore Group, has been elected Chairperson of the Board of Directors of theMay - Champion Baltimore/Washington DB2 Users Group.  Kim has served on the board of BWDB2UG since 2005 in many capacities such as programming and membership.  BWDB2UG continues to provide strong technical leadership for DB2 practitioners in the US Mid-Atlantic region.  Kim takes over from long-time board Chair Steve Rosenberger.

Kim is also an IBM Champion and is very active in the DB2 Community.  As an example, she presented at the IBM World of Watson conference in Las Vegas in 2016.  Kim recently returned from the zAnalytics Bootcamp held annually at IBM Silicon Valley Lab.

Kim’s business focus in 2017 is the IBM DB2 Analytics Accelerator (IDAA) and DB2 running on Linux on System z.  Please join me and the BWDB2UG board in supporting Kim in her new role.