IDUG Call for Speakers Open Until October 19th

Posted by Kim May on September 24, 2018 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Migrations, International DB2 Users Group (IDUG), Oracle, pureScale, TFG Blog.

 

The Call for Speakers for the 2019 IDUG North America Conference, scheduled for Charlotte, NC, from June 2 – 6, 2019, is open.  For Db2 users this is an excellent opportunity to share your experience with your peers.  IDUG has a well documented presentation submission format and process, detailed on the IDUG North America webpage.

You may submit an unlimited number of abstracts.  However, it is important that you provide all of the information requested when submitting your presentation(s) for review. Failure to provide all requested information may impact whether or not the abstract is accepted.

One last note:  given the timing, don’t forget to reach out to your local Db2 RUG and offer to deliver your presentation at one of their meetings prior to the conference.  It’s a great opportunity to do a practice run, and also allow your local peers – some of whom may not be attending the conference – to appreciate your work.

From the IDUG webpage:

IDUG is soliciting presentation abstracts that explore into details of implementation, migrating to a new release, or maximizing performance from any member of the DB2 product family. In recognition of the complex requirements of today’s database implementations, presentation abstracts relating to migration from Oracle to DB2, upgrading within versions of DB2, and new hardware implementations are also being requested. Presentations may cover details of DB2 tools, Big Data and other ancillary DB2 products.

All presentations must be strongly technical in nature, cannot contain marketing themes, and must support and strengthen the information services community by providing the highest quality education and services designed to promote the effective utilization of the DB2 and its family of products.”

 

Frank Fillmore to Present on IDAA V7 (“Sailfish”) at the Baltimore/Washington Db2 Users Group

Posted by Kim May on August 23, 2018 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IDAA, TFG Blog.

Following his successful hands-on IDAA class in Columbus, Frank Fillmore will be presenting on the IDAA at the September Baltimore/Washington Db2 Users Group, scheduled for Wednesday, September 12th.   Frank’s presentation and bio are below – last, per his request – keep reading – !

If you are in the area September 12th please join us.  If you have any questions on the upcoming meeting or are interested in presenting please contact me.

Date:                Wednesday, September 12th, 2018
Time:                9:00 AM – 3:30 PM (registration at 8:30)
Location:          Hilton Baltimore BWI Airport, 1739 W Nursery Road, 21090
Fees:                Pre-registered members: $30,  Pre-registered non-members: $40
At-the-door:    Members: $40, non-members: $50

Schedule:
Registration
8:30 – 9:00

9:00 – 10:15:  Copy Smarter – Unload/Load, DSN1COPY and Beyond

Kai Stroh, UBS Hainer

When you get tasked with setting up a refresh process for thousands of Db2 z/OS tables you probably have a few thoughts running through your head: How long does it take to create all the required jobs? How long for all the control cards? Do all the target tables exist, or are there any new tables in production? Have tables been changed? Better double check if the tables have grown or if Db2 has added more VSAMs so that you don’t run out of space halfway through like last time. Don’t forget catalog statistics and RTS. And those identity columns and sequences – they’re always trouble. What seems like little bits and pieces at first can really stretch your staff thin, which is why automation is key if you want to save time and energy. This presentation discusses advantages and disadvantages of different utilities that copy Db2 data, but the main focus is automating all the side tasks that DBAs usually need to do in addition to copying the data itself.

10:15 – 10:30:  Break

10:30 – 11:45:  Log Enhanced Copies for 24×7 DB2 Refresh/Migration

Kai Stroh,  UBS Hainer

LOB compression is one of the more interesting features of Db2 12. It promises performance gains for your application that use LOB’s, coupled with disk savings! This presentation provides an overview of the feature, and discusses some of the performance characteristics. Then we move on to pros and cons, and a process for taking advantage of the feature.

11:45 – 12:45:  Lunch

12:45 – 2:00:  Machine Learning

Jonathan Sloan, IBM

Gain an overall understanding of Machine Learning for z/OS and its role in enabling advanced analytics on IBM Z. You will learn how this machine learning technology integrates with Db2 Analytics Accelerator and Db2 for z/OS to drive real-time insight on an enterprise scale.

2:00 – 2:15:  Break

2:15 – 3:30: IBM Db2 Analytics Accelerator (IDAA) V7 had a Brain and Heart Transplant

Frank Fillmore, The Fillmore Group

IBM Db2 Analytics Accelerator (IDAA) v7 has been completely re-engineered. Previous IDAA versions were based on legacy Netezza technology including PostgreSQL (the “brain”) and Field Programmable Gate Arrays (FPGA – the “heart”). IDAA v7 – aka “Sailfish” – uses Db2 with BLU Acceleration and POWER processors. The benefits are greater compatibility between Db2 for z/OS and the IDAA, fewer hardware problems, improved Incremental Update latency, and lots more.  If you are an existing IDAA shop considering migrating to v7 or have not previously considered IDAA, this presentation will cover what you need to know.

Speaker:

Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in Db2 utilities for z/OS. He designs and builds innovative Db2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around Db2 dumps and knows how to move data and definitions across Db2 versions, and this includes the unique in-house Db2 subsystems which each have their own little technical adaptations.

Jonathan Sloan is a Senior Certified Executive Software IT Specialist, with more than two decades experience successfully leading, selling and implementing business analytic and data warehouse applications as a vendor as well as an implementer. He joined IBM in 2000 and specializes in helping customers understand the application of IBM Information management technology to business problems.

Frank C. Fillmore, Jr. is the Founder and President of The Fillmore Group, Inc., a Premier IBM Business Partner specializing in Hybrid Cloud and Analytics. Frank has been a Db2 Gold Consultant since 1998 and currently is an IBM Champion for both Analytics and System z. Frank has frequently presented on cutting-edge topics at regional and international Db2 Users Group meetings and the IBM Insight conference.

New Mid-Atlantic Db2 for LUW Users Group Announced

Posted by Kim May on July 27, 2018 under Baltimore Washington DB2 Users Group, DB2 for Linux Unix Windows, DB2 Gold Consultants, IBM Champion, TFG Blog.

After a few months of discussion and support from the IBM community-focused Db2 technical team and local Db2 users, a new RUG, the Mid-Atlantic Db2 for LUW Users Group, is here!  The group will kick off with their first meeting on Wednesday, August 15th at the McLean TEC.

The team is working on the exact schedule for the day and planning a late morning start, most likely 10am, to allow for traffic (a challenge to us all!)   IBM is sponsoring the meeting and bringing STSM Date McInnis in from the Toronto Lab to present.  There will be no charge to attend the meeting, however registration is required.

I will update this post with the registration link as soon as it is set up.  In the meantime please mark you calendar and plan to join us if you are a Db2 user.

And if you run into IBM’s Kay Groski, Lynn Chou and/or Warren Heising, or Db2 Gold Consultants and IBM Champions Ken Shaffer and Steve Mazer, please give them a shout out for their efforts to make this new group a reality.

…and here’s the update – just in!

Register on Eventbrite HERE.

The agenda:
10:00 – 11:00 Db2 Topic: Db2 Backup and Restore best practice with Dale McInnis
11:00 – 11:15 break
11:15 -12:15 Db2 Topic: Building a resilient DB with Db2 with Dale McInnis
12:15 – 1:00  lunch
1:00 – 1:45  Emerging Technologies Topic: ICPD overview with Kay Groski
1:45 – 2:00 break
2:00 – 3:00 Emerging Technologies Topic: Topic DSX Local with demo with Steve Geringer

*** Please note:  There is a fee for parking ***

IBM Think Conference Call for Speakers is **OPEN**

Posted by Kim May on June 28, 2018 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, IBM Think Conference, TFG Blog.

The IBM Think 2019 Conference will be held in San Francisco, on February 12 – 15.  For those like me, who felt the Las Vegas conferences were becoming one exhausted blur, San Francisco is a welcome change.

I hope this year’s Think Conference will offer excellent networking (why I go!), along with the opportunity to learn about new and “coming soon” solutions.  For technical folks there should be plenty of opportunities to learn and improve your skills.

As with past IBM conferences, presenters get a free pass. The conference fee is set at $2,295 – and we all know getting a free pass makes asking your boss to fund a week in San Francisco much easier.  And the Call for Speakers is now open.

I suggest anyone interested in presenting, particularly if it’s your first time submitting a presentation, share your presentation idea with your local users group and ask for their feedback. Users groups – like the Baltimore/Washington Db2 Users Group – review presentations throughout the year as part of the process of selecting meeting sessions.  Our board members can provide feedback to make your session abstract stand out (in a good way!)  Many of our board members have also delivered presentations, and welcome the opportunity to share their experiences with “newbie” presenters.

From IBM’s Call for Speakers announcement – “If you or your client have faced a challenge that led to a breakthrough in your industry, reinvented your processes, or resulted in success worth sharing, submit your proposal to become a speaker at Think 2019. All formats are welcome: lectures, labs, panels, breakout sessions, etc.”

The submission link is hereDon’t lollygag – submissions must be submitted by July 16, 2018.

Other dates to note: speakers selected will be notified in September; final presentations are due to IBM in December.

I hope to see you at Think!

IDUG 2018 Thoughts and Notes

Posted by Kim May on May 7, 2018 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, IDAA, International DB2 Users Group (IDUG), TFG Blog.

Last week’s annual International Db2 Users Group (IDUG) Conference in Philadelphia was interesting and – as always – a great time to reconnect with friends and colleagues.  With IBM in what feels like perpetual transformation mode, I was curious to compare this conference with others I’ve attended in the past, to get a sense of how Db2 customers are perceiving the state of Db2 in these uncertain times.  My impressions:

  1. Db2 for z/OS customers, while not excited about growing workloads on System z, appear to be more confident their organizations will maintain what’s in place and invest in mainframe infrastructure when and where it makes sense.  I expected to hear the “we’re getting off the mainframe in 3 years” comment and did not; instead I was encouraged to see existing IDAA customers expressing interest in the new “Sailfish” model (V7.1).  Shameless plug:  if you were one of these people, please join us for our free IDAA class in June.
  2. For Db2 for LUW, the times are changing, and hopefully for the better.  Jon Lind’s Technical Advisory Board meeting offered participants a chance to express their concerns with the ecosystem, marketing, competitiveness, enablement, and I could go on, list of challenges around keeping Db2 for LUW relevant in the RDBMS market.  Jon Lind’s team has a refreshing willingness to listen, and the opportunity to revive Db2 for LUW.  Keep an eye on this team:  they have a long list of requests, and spent much of the conference talking with end users and partners about what they can do to help.  I wish them great success!!
  3. Kudos to the IDUG team for a fabulous location and super well organized event.  I wish we could have had some competitors join us for the community dinner to check out the enthusiasm (and noise level!) in the dining room.  There was ENERGY to spare!  And special thanks to IBM’s Surekha Parekh and Jim Reed for hosting such a great event at the conference and for all their support.
  4. One-name Rocket woman Saghi also deserves a shout out for gathering the local user group leaders for lunch and extending IDUG’s support to our Db2 communities.  The Db2 for z/OS RUGs are incredibly strong and doing their best to ensure LUW users have access to similar community resources.

So, I will end this post on my experience at IDUG with one final thank you, to Steve Cricchi, from T. Rowe Price, whose presentation on loading data into the IDAA was very well done and will be shared with the Baltimore/Washington Db2 Users Group at an upcoming meeting.  Well done!  Frank’s waiting for his beer…  🙂

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!