“IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop” #IDUG Europe

Posted by Frank Fillmore on July 14, 2014 under Big Data, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, Hadoop, IDAA, Netezza. Tags: , , , , , .

From November 9 – 14 I will be visiting one of the most charming cities on the planet when I attend the International DB2 Users Group (IDUG) conference in Prague, CZ.  I will present “IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop”.  It will be session E7 on Tuesday, November 11 from 3:15 to 4:15 p.m.  Please consider attending IDUG Europe and joining me at this session.

Abstract:  IBM offers four distinct data retrieval technologies: the traditional RDBMS, which primarily relies on indexes to speed access; the new BLU Acceleration columnar compression database; IBM PureData System for Analytics (IBM Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse the data; and IBM InfoSphere BigInsights, which is the IBM distribution of Hadoop. Choices are good to have, but how do you choose which technology to apply to a particular business use case? In this session, you learn how these techniques differ, including their relative strengths and weaknesses, to help you make an informed choice.

IDAA Education – What Follows the “Presales” Hands-on Workshops?

Posted by admin on June 25, 2014 under Authorized Training Partner, Data Studio, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM DB2 Services, IBM Information Management Software Sales, IDAA, TFG Blog. Tags: , , .

Frank, joined by Mike Hood and Saghi Amirsoleymani, is delivering hands-on IDAA training for a group of customers in Columbus today and tomorrow.  Again, amazingly, almost every “student” registered to attend class posted for class, interested in learning about how an IDAA may help support their mainframe workloads.  The photo above is Frank in the classroom this morning in the IBM Advanced Analytics Briefing Center in Columbus.

After delivering three similar IDAA hands-on training classes we have been able to expose and teach over 35 z/technical influencers about the IDAA.  We have also become aware of the need for implementation and post-implementation training and services, as we have learned there are many z/customers who need help getting the IDAA they’ve purchased into production.  Unfortunately there currently aren’t any IBM authorized classes or IDAA classroom training; there seems to be a pre-purchase perception that the IDAA is a “plug and play” device, which it is not.

We hope to be able to help some of the customers we’ve introduced to the IDAA with additional training and services once they purchase the IDAA.  Please check back here for the outline of our new class, “IDAA Implementation and Administration”, and an overview of two new services offerings:  IDAA Implementation Quickstart and IDAA Healthcheck.  Check back here for updates – I am working on the collateral for these offerings.  In the meantime, if you are looking for similar help, please feel free to contact me.

 

 

IDAA Implementation and Administration Training

Posted by Kim May on June 2, 2014 under Authorized Training Partner, DB2 Education, DB2 for z/OS, IBM DB2 Services, IBM Information Management Software Sales, IDAA, Netezza, TFG Blog.

One of the areas of interest we identified through promoting our hands-on IDAA classes intended for customers considering IDAA purchases is the need for post-purchase implementation and administration education.  To address this need we will be adding a new 3-day class to our August schedule, ”IBM DB2 Analytics Accelerator Implementation and Adminsitration”.  I am targeting August 19th, 20th and 21st for the first class to be delivered in our Towson, Maryland classroom.

The cost of the class will be $2100.

Please contact me with any questions on the class, or for registration information.   As soon as I have a final outline ready I will post it here.

If you are one of the people who asked to join us for the Baltimore, NY or Columbus sessions, and are from an organization that has already purchased an IDAA, I hope you will join us.

Services – Available Help for the “tions”

Posted by Kim May on May 30, 2014 under Authorized Training Partner, Big Data, Data Studio, DB2 Connect, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Federation, Frank Fillmore, Hadoop, IBM Champion, IBM DB2 Services, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, MQT's, Netezza, Optim, Oracle, pureScale, Q-Replication, SQL Tuning, TFG Blog. Tags: , , , , , , , , , , , , , , , , , .

I was on a call this morning with an IBM technical team to discuss our progress filling the seats in one of our upcoming free IDAA classes.  Not surprising, given the number of people on the call (and who they were!) we went a bit off topic and ended up chatting about services and what appears to be – to IBM customers and sellers at least – a shortage of skilled consultants available to help with the “tions” – replication, implementations, migrations and federation.

The Fillmore Group has skilled consultants available to support these efforts, at rates that are typically about half of those being charged by “the competition”.

If your team has a project pending, or one in process, where a skilled consultant, at a reasonable hourly rate, can get things back on track, please contact me.  We are ready to work!  A list of our IBM Information Management capabilities is attached here.

 

Finding System z Talent

Posted by admin on May 16, 2014 under DB2 Education, DB2 for z/OS, TFG Blog. Tags: , , .

The Fillmore Group has, at least in our opinion, access to some of the best DB2 for z/OS consulting and staff augmentation talent in the world.  Need help?  Email me!

However, as we heard recently from two successful mainframe customers at a class in Baltimore, finding young IT professionals interested in mainframe-centric careers is really tough.  Add to this the challenges in the world of IBM training, and the convergence of the aging z technical teams with the lack of young, skilled talent, and this becomes another factor jeopardizing long-term prospects for the IBM mainframe.

IBM has been trying to address the problem by enabling colleges and universities around the world to use IBM curriculum and remote labs to teach mainframe technology courses.

I spoke recently with IBM’s Don Resnik, who runs the IBM Academic Initiative, and Don re-introduced me to the program and shared some terrific resources.  As it turns out, there are three schools on the East Coast offering a mainframe track:  Radford in Virginia, and Syracuse and Marist in NY.

This week many colleges are holding graduation ceremonies.  If your organization would like to invest in the future of the mainframe, I recommend you spend a few minutes reviewing the information in the Academic Initiative website as well as the website where many students have posted their resumes, and where you can post job openings, www.systemzjobs.com.

As the parent of a college student anxious about his post graduation job prospects, I encourage everyone working with the mainframe to consider hiring a recent grad.  It’s a win-win.

 

Free Hands-on IDAA Classes for Columbus and New York Announced!

Posted by admin on May 5, 2014 under DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IDAA, Netezza, TFG Blog. Tags: , , , , , .

We were so pleased with the response to the *free* hands-on IDAA class delivered in Baltimore in April that we’ve decided to do two more in June!  Back again, to repeat their successful presentations will be Frank Fillmore and IBM IDAA experts Saghi Amirsoleymani and Mike Hood.

Class is open to any current DB2 for z/OS customer considering an IDAA acquisition, and will provide attendees with the opportunity to test drive an IDAA.

IBM® DB2® Analytics Accelerator for z/OS is a high-performance appliance that integrates IBM Netezza and zEnterprise technologies. The solution delivers extremely fast results for complex and data-intensive DB2 queries on data warehousing, business intelligence and analytic workloads.

IBM DB2 Analytics Accelerator for z/OS helps you:

  • Query data at high speeds—to significantly improve response times for unpredictable, complex and long-running query workloads.
  • Extend the capabilities of DB2 for z/OS—to support a cost-effective analytics solution for data warehousing, business intelligence and predictive analytics.
  • Lower operating costs—by reducing System z disk requirements and offloading workloads and archiving infrequently used data using the High Performance Storage Saver (HPSS) technology.

DB2 Gold Consultant Frank Fillmore will present these 2-day, hands-on training classes to introduce experienced DB2 for z/OS DBA’s to the IDAA.  Starting with an overview of the unique hybrid technology behind the IDAA, and covering topics including installation, security, and operational management, the classes will deliver an understanding of how the IDAA can quickly integrate into your existing zEnterprise infrastructure and rapidly provide value.  Frank will be joined by IBM’s Saghi Amirsoleymani and Mike Hood for sessions focused on the IDAA tools.

There is no charge for these classes, however attendees are responsible for their own travel and lodging.  Please note that due to the technical nature of the hands-on labs, there is no distance learning/remote option available for these classes.

A continental breakfast and lunch will be provided each day.

Dates and locations scheduled are below.  Click on either session to register.  We hope you will join us!

IDAA Hands On Training NYC June 11 and 12 Terrace Club

IDAA Hands On Training Columbus June 25 and 26

 

 

 

Two *Free* IDAA Hands-on Classes Coming Soon

Posted by Kim May on April 25, 2014 under DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IBM Information Management Software Sales, IDAA, TFG Blog. Tags: , , , .

The IDAA class feedback was terrific as the attendees had the opportunity to expand their understanding of the potential use cases and opportunities to use the IDAA to:  1) speed analytic queries, 2) archive rarely used data, and retrieve it quickly, and 3) reconsolidate workloads on System z.

We hosted the class in Baltimore, since it’s our backyard.  At the recommendation of the IBM Big Data team, we are planning to host two more sessions in June.  The dates are confirmed:  June 11th and 12th, and June 25th and 26th, but the locations are still TBD.

If you are interested in attending, the outline is available here, and my email address is here.  If you let me know you are interested I will contact you – before the end of April – with the two locations.

IBM DB2 Analytics Accelerator (#IDAA) Workshop a Success!

Posted by Frank Fillmore on April 14, 2014 under Data Studio, DB2 Education, DB2 for z/OS, IDAA, Optim, Sidecar. Tags: , .

Last week in Baltimore The Fillmore Group conducted a deep-dive technical workshop on IBM DB2 Analytics Accelerator.  We covered Basic and Advanced hands-on labs with the support of the IBM Poughkeepsie Demo Center.  Saghi Amirsoleymani and Mike Hood, both of IBM, presented on the Tools Ecosystem supporting the Accelerator including:

The presentation I gave outlining the topics covered in the Basic and Advanced lab exercises is here: IDAA Workshop 2014-04  Additional presentations will be posted soon.

Demo videos of the Tools include:

Database Magazine and Articles on Accelerating Analytics Queries

http://ibmdatamag.com/2013/12/accelerating-analytics-queries/

http://www.ibm.com/developerworks/data/library/techarticle/dm-1403queryaccel/index.html

Summary of DB2 and Q Replication Performance Tuning Techniques

Posted by Frank Fillmore on March 25, 2014 under DB2 for Linux Unix Windows, Q-Replication, SQL Tuning. Tags: , .

Performance tuning for both DB2 and Q Replication are an ongoing process.  However, there are three tools which provide an initial set of recommendations for bufferpools, Database Manager (DBM or instance) and database configuration parameters, indexes, and other application table objects.

 

DB2 Configuration Advisor

The DB2 Configuration Advisor recommends the initial values of the bufferpool size, database configuration parameters, and database manager configuration parameters.

To use the Configuration Advisor, specify the AUTOCONFIGURE command for an existing database, or specify AUTOCONFIGURE as an option of the CREATE DATABASE command.

Example:

db2 autoconfigure using mem_percent 50 num_stmts 100000 tpm 6000 admin_priority performance num_local_apps 144 num_remote_apps 0 isolation UR apply none

DB2 Design Advisor

The DB2 Design Advisor is used to improve application SQL performance by creating (or dropping) indexes, Materialized Query Tables (MQTs), and MultiDimensional Clustering (MDCs).  The Design Advisor analyzes an SQL workload against existing table structures and recommends changes to improve performance.  The workload can be derived from Dynamic Statement Cache (DSC).  The DB2 Design Advisor command can be invoked by the db2advis command.

A prerequisite is creating the DB2 EXPLAIN tables for the schema conducting the analysis.

cd /<path>/sqllib/misc

db2 –vtf EXPLAIN.DDL

Then run the db2advis command.

db2advis -d mydb -g -a myuser -x -c USERSPACE1 -f -m IMCP -o db2advis_output

 

Q Replication Dashboard Performance Advisor

The Q Replication Performance Advisor helps you identify latency issues with your replication environment and suggests ways to lower end-to-end latency.  The Performance Advisor tab is located within each Monitoring Group.  The Q Replication Dashboard Performance Advisor can recommend updating statistics or reorganizing tables.

IBM zEnterprise Technology Summit – May 6th, Washington, DC

Posted by Kim May on March 21, 2014 under Baltimore Washington DB2 Users Group, DB2 for z/OS, IBM DB2 Services, IDAA, Optim, Q-Replication, TFG Blog. Tags: , , , , , , .

IBM has scheduled a second presentation of the 2014 zEnterprise Technology Summit due to the snowstorm that hit in January when the event ran originally.  If you are in the area and have time to attend, please do!  Information on the event is below; register on the IBM site here.  There are several other events scheduled across the US in 2014 – view them on the IBM site here.

IBM zEnterprise Technology Summit Tuesday, May 6, Washington, DC

New technology is stretching IT budgets in many directions, forcing IT to find better ways of meeting business demands in increasingly complex data centers. Read More…