Inside IBM Insight 2014: See How Clients Are Revolutionizing Their Business With DB2

cassieBy Cassandra Desens
IBM Software Group, Information Management  

This will be my second year at Insight and I must say, it is my favorite time of the work year. As frenzied and busy as the planning is, the return on intangible investments is worth it. Ask anyone – after just a few short days in Vegas you walk away with a renewed sense of excitement around IBM, its products, lots of free stuff, and usually a head cold  (I’m no doctor, but casinos are definitely germ incubators).

Last year I was amazed at the hundreds of events and opportunities the conference presented by customers. Demos, a city-sized EXPO floor, labs, 1-on-1s, both large general & breakout sessions,  product specific & networking events…the list goes on and on. There are so many different ways to spend your short week with us at Mandalay Bay. The question is – what will you choose to attend?
Allow me to suggest the client-led sessions.

As I said in my last blog entry, Balluff loves BLU Acceleration too: “Hearing customer stories puts our product claims into perspective. Success stories give us the ultimate answer to the elusive question “How does this relate to me and my business?”.”

There is nothing that gets me more excited than hearing how a customer was able to revolutionize their business with DB2 for Linux, UNIX and Windows, so today I want to recommend 5 Insight2014 sessions for you to attend to hear the way companies around the world are leveraging DB2. I encourage you to weave these into your busy schedule next week. I promise you won’t be disappointed!

1) IWA-4145A: Keeping Data Analysts in the Pink: IBM DB2 with BLU Acceleration on Power System at BlueCross BlueShield of TN
Date & Time: Monday October 27th, from 2:00-3:00pm
Speakers: Randy Wilson Lead DB2 for LUW DBA at Blue Cross Blue Shield of Tennessee, and Danny Arnold, Software Client Leader at IBM
Abstract: When BlueCross BlueShield of Tennessee (BCBS of TN) data analysts ran certain queries, the queries did not run in a timely manner and took hours to complete. In need of a solution, the company decided to test the IBM DB2 10.5 with BLU Acceleration technology. The initial results were astounding, showing queries completing in just seconds, not hours. The company then installed DB2 10.5 with BLU Acceleration on a large test environment on the IBM POWER7 system. It worked with its data analyst team of IBM Cognos and SAS users to identify queries that could benefit from the BLU Acceleration technology. In this session, you learn about BCBS of TN’s experience with DB2 BLU and how it allows the company to make better business decisions.

2) IWS-5729A: IBM BLU Acceleration: Adoption Guidelines and Lessons Learned at Coca-Cola Bottling Company

Date & Time: Monday October 27th, from 3:30-4:30pm
Speakers: Andrew Juarez, Lead SAP Basis DBA at Coca-Cola Bottling Co., and Naresh Chainani, DB2 Development at IBM
IBM DB2 with BLU Acceleration can provide performance improvements that range from 10 times to 25 times and beyond for analytical queries with minimal tuning. If you are eager to understand how your business can take advantage of this technology for your warehouse or data marts, attend this session. You learn how quick and easy it is to get started with BLU. You see a specific real-world example based on the Coca Cola Bottling Company’s experience with DB2 BLU, from installation to performance tests. You also see how DB2 BLU fits into the SAP BW environment.
3) IWS-5338B: Why the University of Toronto Loves BLU: Faster, Smaller, and Simpler in Only a Few Hours
Date & Time: Tuesday October 28th, 10:00-11:00am
Speakers: Brenda Boshoff, Senior Database Administrator at University of Toronto, and Adam Storm, Senior Technical Staff Member and Master Inventor at IBM
Abstract: It’s not every day that a new database technology promises revolutionary performance gains, improved compression and radically reduced time to value. It’s even less often that such aggressive claims can be validated by customers. This session takes you through the adoption cycle of IBM BLU Acceleration at the University of Toronto. You learn how an aggressive one-day proof of concept achieved dramatic performance gains in less than three hours. You gain insight into the process of taking BLU Acceleration through the QA cycle and into production. If you’re considering moving to BLU Acceleration, attend this session to see how the University of Toronto successfully adopted the technology in its environment and achieved dramatic results.

4) IWS-5787A: Simplify your SAP Landscape – Superior SAP BI Performance @ Yazaki with DB2 BLU
Date & Time
: Wednesday October 29th from 11:15-12:15pm
Speakers: Juergen Laudien, Infrastructure Manager at Yazaki Europe, Bernd Ertl, Competitive Sales Lead at IBM, Karsten Stoehr, Competitive Database Sales Specialist at IBM, Carsten Dieterle, SAP Infrastructure Solution Architects (SOLAR) – SAP Growth Program at IBM
Abstract:The topic is about simplifying your SAP BW landscape by taking SAP BWA and HANA appliances out of the IT infrastructure and replace it with DB2 BLU instead of SAP HANA – Many DB2 clients have done this. They have gained their experiences in proof of concepts as well as in production environments which prove, that DB2 BLU needs up to 85% less cores/storage/RAM compared to SAP BWA or HANA appliances. This huge amount of HW savings and the reduced SW license costs allow clients to run their business faster and more efficient on DB2 BLU.

5) IDB-4606A: Ameriprise Financial’s Deployment Experiences with IBM DB2 High Availability Disaster Recovery
Date & Time: Wednesday October 29th from 4:30-5:45pm
Speakers: Chip MicAllister, UDB Database Technical Lead at Ameriprise and Dale McInnis STSM: Chief Architect IM Cloud Availability
Abstract:  In this session, you learn about the high availability disaster recovery (HADR) feature in IBM DB2. Then, you will hear about Ameriprise Financial’s experience when deploying DB2 HADR in its production environment.

Safe travels everyone and see you soon!

Mastering the DB2 10.1 Certification Exam – Part 2: Security

It’s hard to argue against the benefits of becoming a DB2 Certified Professional. Aside from gaining a better understanding of DB2, it helps keep you up to date with the latest versions of the product.  It also gives you professional credentials that you can put on your resume to show that you know what you say you know.

But many people are reluctant to put in the time and effort it takes to prepare for the exams. Some just don’t like taking tests, others don’t feel they have the time or money to prepare. That’s where we come in – the DB2 team has put together a great list of resources to help you conquer the certification exams.

We caught up with Anas Mosaad and Mohamed El-Bishbeashy who are part of the DB2 team to that developed the DB2 10.1 Fundamentals Certification Exam 610 Prep – a 6 part tutorial series aimed at helping DBA’s prepare for the certification exam.

What products are focused on in this tutorial?

In this tutorial we’ve focused completely on DB2 10.1 LUW

Tell us a little about what students can hope to learn about in this tutorial?

It is the second in a series of six tutorials designed to help you prepare for the DB2 Fundamentals Exam (610). It puts in your hands all the details needed to successfully pass security related question in the exam. It introduces the concepts of authentication, authorization, privileges, and roles as they relate to DB2 10.1. It also introduces granular access control and trusted contexts.

Why should a DBA be interested in this certification?

IBM professional certifications are recognized world wide, so you will get recognized! In addition, this one is the first milestone in the advanced DB2 certification paths (development, DBA and advanced DBA). It acknowledges that you are knowledgeable about the fundamental concepts of DB2 10.1. It shows that you have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 10.1, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Do have any special tips?

Absolutely, here are a few of our favorite tips for preparing for the certification exam:

  • Practice with DB2
  • If you don’t have access to DB2, download the fully functional DB2 Express-C for free
  • Read the whole tutorial before taking the exam
  • Be a friend of DB2 Knowledge Center (formerly infocenter)
  • When in doubt, don’t hesitate, post and collaborate in the forums.

For more information:

DB2 10.1 fundamentals certification exam 610 prep, Part 2: DB2 security

For the entire series of tutorials for Exam 610 DB2 Fundamentals, include the following:
Part 1: Planning
Part 2: DB2 security
Part 3: Working with databases and database objects
Part 4: Working with DB2 Data using SQL
Part 5: Working with tables, views, and indexes
Part 6: Data concurrency

About the authors:
Anas MosaadAnas Mosaad, a DB2 solutions migration consultant with IBM Egypt, has more than eight years of experience in the software development industry. He is a member of IBM’s Information Management Technology Ecosystem Team focusing on enabling and porting customer, business partner, and ISV solutions to the IBM Information Management portfolio, which includes DB2, Netezza, and BigInsights. Anas’ expertise includes portal and J2EE, database design, tuning, and database application development.

Mohamed El-BishbeashyMohamed El-Bishbeashy is an IM specialist for IBM Cairo Technology Development Center (C-TDC), Software Group. He has 12+ years of experience in the software development industry (8 of those are with IBM). His technical experience includes application and product development, DB2 administration, and persistence layer design and development. Mohamed is an IBM Certified Advanced DBA and IBM Certified Application Developer. He also has experience in other IM areas including PureData Systems for Analytics (Netezza), BigInsights, and InfoSphere Information server.

Roger Sanders: Previewing the DB2 Sessions at IBM Insight 2014

rogerBy Roger E. Sanders
Senior Consultant, Software Engineer

As a DB2 professional, there are two major events I look forward to each year – the International DB2 User’s Group North America conference and the IBM Insight (formerly Information On Demand) conference. And this year, I’m really excited about the IBM Insight 2014 conference.

Why? Well, for one thing, I have a new book out and I will be autographing copies outside the bookstore, right after the opening session on Monday morning. Writing is a solitary, lonely activity. And until others have read your work and commented on it, writing is an activity that is essentially done in a void. At book signing events, I have the rare opportunity to meet some of my readers and solicit their input on things I have written in the past. By finding out what readers like and (what they don’t), I can improve my skills as a technical writer.

For more information on the book signings taking place at the conference, see Book Signings and Giveaways at IBM Insights 2014.

But the conference is much more than just an opportunity to sign books. It is also an opportunity to hear technical presentations from many of the IBM Distinguished Engineers who are responsible for the development and testing of the DB2 software. This year, I’m looking forward to hearing about the latest features and functionality that can be found in the “Cancun” release of DB2 for Linux, UNIX, and Windows (DB2 10.5, FixPack 4).

I’ve read many of the product announcements and I have participated in a couple of webinars, but after attending some of the sessions being offered, I expect to come home with a burning desire to get some hands-on experience with some of the new features I will learn more about.

Finally, I’m looking forward to seeing many old friends. I’ve been attending both conferences regularly for over a decade and it seems like I meet new people every year. Consequently, each conference now feels like a family reunion. And after a day of trying to absorb a lot of technical information, spending time at the evening activities catching up with old friends is a great way to relax and wind down.

Here are some of the DB2 sessions that I am looking forward to attending:

I’ve made my travel arrangements, created a conference agenda, and have started packing my bags. Hope to see you at the IBM Insights 2014 conference next week!

Webinar: Why IBM DB2 Database Software Leaves the Competition in the Dust

We all know that IBM DB2 database software is an industry leader when it comes to performance, scale, and reliability. But how does it compare to the competition, specifically Oracle and SAPHANA?

IBM’s Chris Eaton joined IDUG’s DB2 Tech Talk to give an update on IBM DB2 and show how DB2 goes above and beyond our competitors to provide reliable functionality while saving businesses money.

During the presentation, Chris walked the audience through DB2’s latest release, DB2 10.5 “Cancun Release” and the four innovations that make BLU Acceleration  different from our competitors: Next Generation In-Memory, the ability to analyze compressed data, CPU Acceleration, and data skipping.

You can watch the entire presentation on the IDUG website by clicking here, and also review the Tweets from the event by logging on to the IBM DB2 Storify page here.

Still have additional questions? Feel free to leave them in the comment box below and we’ll get the answers to you shortly.

Chris eatonAbout Chris Eaton – Chris is a Worldwide Technical Sales Specialist for DB2 at IBM primarily focused on planning and strategy for DB2 on Linux, UNIX and Windows. Chris has been working with DB2 on the LUW platforms for over 21 years. From customer support to development manager to Externals Architect to Product Manager for DB2, Chris has spent his career listening to customers and working to make DB2 a better product. Chris is also the author of The High Availability Guide for DB2 , DB2 9 New Features, Break Free with DB2 9.7: A Tour of Cost-Slashing New Features and Understanding Big Data Analytics For Enterprise Class Hadoop And Streaming Data. Follow Chris on his blog here.

Balluff loves BLU Acceleration too

cassieBy Cassandra Desens
IBM Software Group, Information Management  

BLU Acceleration is a pretty darn exciting advancement in database technology. As a marketing professional, I can tell you why it’s cool..
BLU provides instant insight from real-time operation data,
BLU provides breakthrough performance without the constraints of other in-memory solutions,
BLU provides simplicity with a load-and-go setup,
etcetera, etcetera ..you get the point.

You can read our brochures and watch our videos to hear how DB2 with BLU Acceleration will transform your business. We think it’s the next best thing since sliced bread because we invented it. But is it all it’s cracked up to be? The answer is YES.

Clients all over the world are sharing how BLU Acceleration made a huge, positive difference to their business. Hearing customer stories puts our product claims into perspective. Success stories give us the ultimate answer to the elusive question “How does this relate to me and my business?”. Which is why I want to share with you one of our most recent stories: Balluff.

Balluff is a worldwide company with headquarters in Germany. They have over 50 years of sensor experience and are considered a world leader and one of the most efficient manufacturers of sensor technology.  Balluff relies on SAP solutions to manage their business, including SAP Business Warehouse for their data analysis and reporting.

Over the last few years Balluff experienced significant growth, which resulted in slowed data delivery. As Bernhard Herzog, Team Manager Information Technology SAP at Balluff put it “Without timely, accurate information we risked making poor investment decisions, and were unable to deliver the best possible service to our customers.”

The company sought a solution that would transform the speed and reliability of their information management system. They chose DB2 with BLU Acceleration to accelerate access to their enormous amount of data. With BLU Acceleration Balluff achieved:

  • Reduced reporting time for individual reports by up to 98%
  • Reduced backup data volumes by 30%
  • Batch mode data processing improvements by 25%
  • A swift transition with no customization needed; Balluff transferred 1.5 terabytes of data within 17 hours with no downtime

These improvements have a direct impact on their business. As Bernhard Herzog put it, “Today, sales staff have immediate access to real-time information about customer turnover and other important indicators. With faster access to key business data, sales managers at Balluff can gain a better overview, sales reps can improve customer service and the company can increase sales”.

Impressive, right? While you could argue it’s no sliced bread, it certainly is a technology that is revolutionizing reporting and analytics, and worth try. Click here for more information about DB2 with BLU Acceleration and to take it for a test drive.

_________________________________________________________________

For the full success story, click here to read the Balluff IBM Case Study
You can also click here to read Balluff’s success as told by ComputerWoche (Computer World Germany). Open in Google Chrome for a translation option.

What is DB2ssh?

photo.doBy Mihai Iacob
DB2 Security Development

The IBM DB2 pureScale Feature provides high levels of distributed availability, scalability and transparency to the application, but why do I need to enable password-less SSH for the root user in my DB2 pureScale cluster? Well you don’t any longer and this site  explains how to use db2ssh to securely deploy and configure the DB2 pureScale Feature.

Both the DB2 installer and GPFS, the filesystem used by DB2 pureScale, have a requirement to run commands as root on a remote system. Db2ssh provides an alternative to enabling password-less SSH as root, by effectively SSH-ing as a regular user, and then elevating privileges to root to run the require commands.

Wait, isn’t that asking for trouble? Can a non-root user run remote commands as root in my cluster ? Not at all, there are rigorous security checks put in place to make sure only the root user can run commands remotely as root. This is accomplished by having the root user digitally sign any message that is sent to the remote system and having the remote system verify this signature before executing any commands. SSH can also be configured in a secure way to prevent against replay attacks.

Take a look at the article to find out how to configure and troubleshoot DB2ssh.

Exclusive Opportunity to Influence IBM Product Usability: Looking for Participants for Usability Test Sessions – Data Warehousing and Analytics

Arno thumbnail 2By Arno C. Huang, CPE
Designer, IBM Information Management Design
IBM Design making the user the center of our productsThe IBM Design Team is seeking people with a variety of database, data warehousing and analytics backgrounds to participate in usability test sessions. We are currently looking for people who work in one of the following roles: DBA, Architect, Data Scientist, Business Analyst or Developer. As a test participant, you will provide your feedback about current or future designs we are considering, thus making an impact on the design of an IBM product and letting us know what is important to you.

Participating in a study typically consists of a web conference or on-site meeting scheduled around your availability. IBM will provide you with an honorarium for your participation. There are several upcoming sessions, so if you’re interested, we’ll help you find a session that best suits your schedule. If you are interested, please contact Arno C. Huang at achuang@us.ibm.com

Make Your Apps Highly Available and Scalable

By Vinayak Joshi
Senior Software Engineer, IBM

The IBM premium data-sharing technologies offer unmatched high-availability and scalability to applications. If you are a JDBC application developer wanting to explore how these benefits accrue to your application and whether you need to do anything special to exploit these benefits, my article – “Increase scalability and failure resilience of applications with IBM Data Server Driver for JDBC and SQLJ” – is a great source of information.

In the article, I explain how turning on a single switch on the IBM Data Server Driver for JDBC and SQLJ opens up all the workload balancing and high availability benefits to your JDBC applications. There is very little required for an application to unlock the workload balancing and high availability features built into the DB2 server and driver technologies.

For those curious about  how the driver achieves this in tandem with pureScale and sysplex server technologies, the article should provide a good end-to-end view. While all the nuts and bolts explanations are provided, it is stressed that all of it happens under the covers, and beyond the bare minimum understanding, application developers and DBA’s need not concern themselves with it too much if they do not wish to.

The aspects a developer needs to keep in mind are highlighted and recommendations on configuring and tuning applications are provided.  We’ve made efforts to keep the reading technically accurate while keeping the language simple enough for a non-technical audience to grasp.

Any and all feedback shall be much appreciated and taken into account. Take a look at the article by clicking here, and feel free to share your thoughts in the comment section below

Influence Your Data Management Future Today

RadhaBy Radha Gowda
Technical Marketing, IBM Analytics

Too many tools! Too many repositories! Too many installs! Focus on managing databases across the enterprise rather than an individual database.  Any of these sounds familiar?

Yes, we heard you. While IBM offers an impressive portfolio of data management tools to manage the complete data life cycle, we agree that there are far too many tools. We want to help you streamline your data management processes and make you even more productive. We are happy to introduce you to the next generation of data management tool for DB2 for Linux, UNIX and Windows – IBM Data Server Manager (beta). It is simple to install, easy to use and enterprise ready with the ability to manage hundreds of databases

Picture2

IBM Data Server Manager integrates key capabilities from the existing portfolio of data management tools. It offers a simple integrated web console to administer, monitor, manage, and optimize hundreds of DB2 for Linux, UNIX and Windows databases across the enterprise. It helps you identify, diagnose, solve, and prevent performance problems. Of course, not to underestimate the expert guidance you will receive to optimize query performance, which tables to convert to column-organized format or create shadow tables for — to optimize with BLU Acceleration, identify storage saving opportunities and more. And, it provides centralized client and server configuration management so you understand and control your environment more efficiently. Best of all, it is quick and easy to deploy.

IBM Data Server Manager beta software is available for Linux, AIX and Windows platforms. Early feedback on the tool has been very positive; we invite you to sign up for the beta program today and start influencing your data management future.

IBM Data Sever Manager – Simple. Scalable. Smart.

Troubles Are Out of Reach With Instant Insights

RadhaBy Radha Gowda
Technical Marketing, IBM Analytics

Bet you have been hearing a lot about shadow tables in DB2 “Cancun Release” lately.  Umm… do shadow and Cancun remind you of On the beach by Cliff Richards and the Shadows?  Seriously, DB2 shadow tables can make you dance to a rock ‘n’ roll on the beach because you will be trouble free with real-time insights into your operations and of course, lots of free time.

What is a shadow table?

Shadow tables have been around since the beginning of modern computing – primarily for improving performance.  So what does the DB2 shadow table offer? The best of both OLTP and OLAP worlds!  You can now run your analytic reports directly in OLTP environment with better performance.

Typically organizations have separate OLTP and OLAP environments – either due to resource constraints or to ensure the best OLTP performance.   The front-end OLTP is characterized by very small, but high volume transactions. Indexes are created to improve performance.  In contrast, the back-end OLAP has long-running complex transactions that are relatively small in number. Indexes are created, but they may be different from OLTP indexes.  Of course, an ETL operation must transfer data from OLTP database to OLAP data mart/warehouse at time intervals that may vary from minutes to days.

DB2 can help you simplify your infrastructure and operations with shadow tables. Shadow table is a column organized copy of a row-organized table within the OLTP environment, and may include all or a subset of columns.  Because the table is column organized, you get the benefit of enhanced performance that BLU Acceleration provides for analytic queries.

How do shadow table work?

shadow tables

Shadow table is implemented as a materialized query table (MQT) that is maintained by replication. IBM InfoSphere Change Data Capture for DB2, available in advanced editions, maintains shadow tables through automatic and incremental synchronization of row-organized tables.

While all applications can access the row-organized table by default, DB2 optimizer will perform the latency-based routing to determine whether a query needs to be routed to shadow tables or the row-organized source.

A truly flexible and trouble-free OLTP world

Shadow tables offer the incredible speed you have come to expect from BLU Acceleration while the source tables remain row-organized to best suit OLTP operations.  In fact, with shadow tables, the performance of analytical queries can improve by 10x or more, with equal or greater transactional performance*.

With instant insight into “as it happens” data for all your questions and all the free time you’ll have with no more indexing/tuning, what’s not to like? Try DB2 today

* Based on internal IBM testing of sample transactional and analytic workloads by replacing 4 secondary analytical indexes in the transactional environment with BLU Shadow Tables. Performance improvement figures are cumulative of all queries in the workload. Individual results will vary depending on individual workloads, configurations and conditions.