Top ten reasons to love IBM Data Server Manager

Radha

By Radha Gowda

DB2 and PureData Sales Enablement & Product Marketing Manager

Today many in-house or multi-vendor data management tools lack end-to-end visibility, usability and scalability. Database administrators often struggle to keep workflows and analytics operating at optimum efficiency and are unable to provide the continuous availability needed for ever-increasing transaction volumes. By effectively integrating database management functions, organizations can streamline routine maintenance and free up resources for more strategic, business-enhancing projects.

 IBM presents IBM® Data Server Manager, an integrated database management tool, to administer, monitor, manage and optimize the performance of hundreds of IBM DB2® for Linux, UNIX and Windows databases across the enterprise. It is easy to install, cloud ready and can be accessed remotely from any supported browser.

Find out more reasons to love Data Server Manager from this infographic.

IBM Data Server Manager Top10

Continuous availability benefits of pureScale now available in a new low cost DB2 offering

KellySchlambKelly Schlamb
DB2 pureScale and PureData Systems Specialist, IBM

Today, IBM has announced a set of new add-on offerings for DB2, which includes the IBM DB2 Performance Management Offering, IBM DB2 BLU Acceleration In-Memory Offering, IBM DB2 Encryption Offering, and the IBM DB2 Business Application Continuity Offering. More details on these offerings can be found here. Generally speaking, the intention of these offerings is to make some of the significant capabilities and features of DB2 available as low cost options for those not using the advanced editions of DB2, which already include these capabilities.

If you’ve read any of my past posts you know that I’m a big proponent of DB2’s pureScale technology. And staying true to form, the focus of my post here is on the IBM DB2 Business Application Continuity (BAC) offering, which is a new deployment and licensing model for pureScale. This applies to DB2 10.5 starting with fix pack 5 (the current fix pack level released in December 2014).

For more information on DB2 pureScale itself, I suggest taking a look here and here. But to boil it down to a few major points, it’s an active/active, shared data, clustering solution that provides continuous availability in the event of both planned and unplanned outages. pureScale is available in the DB2 Advanced Workgroup Server Edition (AWSE) and Advanced Enterprise Server Edition (AESE). Its architecture consists of the Cluster Caching Facilities (CF), which provide centralized locking and data page management for the cluster, and DB2 members, which service the database transaction requests from applications. This multi-member architecture allows workloads to scale-out and workload balance across up to 128 members.

While that scale-out capability is attractive to many people, some have told me that they love the availability that pureScale provides but that they don’t have the scalability needs for it. And in this case they can’t justify the cost of the additional software licenses to have this active/active type of environment – or to even move from their current DB2 Workgroup Server Edition (WSE) or Enterprise Server Edition (ESE) licensing up to the corresponding advanced edition that contains pureScale.

This is where BAC comes in. With BAC – which is a purchasable option on top of WSE and ESE – you can create a two member pureScale cluster. The difference, and what makes this offering interesting and attractive for some, is that the cluster can be used in an active/active way, but it’s licensed as an active/passive cluster. Specifically, one member of the cluster is used to run your application workloads and the other member is available as a standby in case that primary member fails or has to be brought down for maintenance. But isn’t that passive? No… and the reason is that this secondary member doesn’t just sit idle waiting for that to happen. Under the BAC offering terms, you are also allowed to run administrative operations on this secondary “admin” member. In fact, you are allowed to do all of the following types of work on this member:

  • Backup, Restore
  • Runstats
  • Reorg
  • Monitoring (including DB2 Explain and any diagnostic or problem determination activities)
  • Execution of DDL
  • Database Manager and database configuration updates
  • Log based capture utilities for the purpose of data capture
  • Security administration and setup

By offloading this administrative work off of the primary member, you leave it with more capacity to run your application workloads. And with BAC, you are only fully licensing the one primary member where your applications are running (for either WSE or ESE plus BAC). The licensing of the secondary member, on the other hand, falls under DB2’s warm/idle standby licensing which means a much reduced cost for it (e.g. for PVU pricing the secondary member would only be 100 PVUs of WSE or ESE plus 100 PVUs of BAC). For more details on actual software costs, please talk to your friendly neighborhood IBM rep.

BACgraphicAnd because this is still pureScale at work here, if there’s a failure of the primary member, the application workloads will automatically failover to the secondary member. Likewise, the database will stay up and remain accessible to applications on the secondary member when the primary member undergoes maintenance – like during a DB2 fix pack update. In both of these cases the workload is allowed to run on the secondary member and when the primary member is brought back up, the workloads will failback to it. All of the great availability characteristics of pureScale at a lower cost!

If you contrast this with something like Oracle RAC One Node, which has some similar characteristics to IBM DB2 BAC, only the primary node (instance) in Oracle RAC One Node is active and the standby node is not. In fact, it’s not even started until the work has to failover, so there’s a period of time where the cluster is completely unavailable. So a longer outage, slower recovery times, and no ability to run administrative work on this idle node like you can do with BAC.

Sounds great, right?

And for those of you that do want the additional scale-out capability, but like the idea of having that standby admin member at a reduced cost, IBM has thought of you too. Using AWSE or AESE (the BAC offering isn’t involved here), you can implement a pureScale cluster with multiple primary members with a single standby admin member. The multiple primary members are each fully licensed for AWSE or AESE, but the single standby admin member is only licensed as a passive server in the cluster (again, using the PVU example that would only be 100 PVUs of either AWSE or AESE). In this case, you can do any of that administrative work previously described on the standby member, and it’s also available for workloads to failover to if there are outages for one or more of the primary members in the cluster.

Happy clustering!

Join Us For Our Next DB2 CrowdChat – DB2 Into The Future!

jason

By Jason Burns
ITSO Social Business Manager for DB2

In the 20 years since DB2 was launched on the Linux, Unix and Windows platforms, the product has seen amazing transformations! It is used by database professionals around the world and continues to evolve and increase in popularity.

As we look forward to the next 20 years, our clients and partners will continue to play an important role in shaping the future of DB2. What is it you like about DB2? What features are helping you achieve your goals: from the reliability and safety that is core to database technology, to the power of accessing any kind of data faster than ever before.

In this month’s CrowdChat, we’re assembling a who’s who of IBM DB2 professionals to talk about what you like about DB2 and how you envision its future. Panelists include: Sam Lightstone, Kelly Schlamb, Ember Crocks, Amit Patel, Lynn Chou, and Iqbal Goralwalla.

Questions for this month’s CrowdChat include:

• FP5 was just released and included new features. Could you tell us more about this?
• BLU Acceleration is available on new platforms (Windows and zLinux). How will this broadened platform support help you and your clients?
• What benefits will I see if I use BLU Shadow Tables?
• What is new with the pureScale feature?
• How easy is it for a DB2 DBA to manage a pureScale environment?
• Security is a top business concern! How does native encryption help improve security in business?
• Does native encryption vary for operational reporting vs transactional data?
• In the past, it seemed that special hardware was required to run pureScale. Is that still the case?
• What are some of the best use cases you have seen for DB2 with BLU Acceleration?

What is a CrowdChat?
A CrowdChat is a free community virtual event platform that works seamlessly with Facebook, Twitter, and LinkedIn to allow users to engage in an online conversation held at a pre-arranged time around a topic using a specific #hashtag. You can sign in using your Twitter, Facebook or LinkedIn account. It’s easy (and fun!) to participate in a CrowdChat.

Use your Twitter, LinkedIn or Facebook credentials to log into http://www.crowdchat.net. The chat can also be followed on Twitter using the hashtag #DB2. Anyone and everyone is welcome to join, especially the developer community!

Date: Thursday, January 22
Time: 1:00 PM ET
Link to Chat: http://www.CrowdChat.net/db2
Chat hashtag: #db2

Creating Real World Sensor-to-Business Value Internet of Things Applications

sajanBy Sajan Kuttappa SWG
Informix Social Media Marketing & Communications Manager, IBM

Consider the following scenarios:

  • Analysis of data from shoppers’ mobile devices is delivering insights about which store location within a mall will guarantee a retailer the highest footfall
  • Consumers are optimizing their energy consumption by better analyzing their power usage patterns over regular time intervals. Utility companies are using this data to build more responsive grids
  • Public transport /shared transport is being revolutionized with a better understanding of how and when people travel

The aforementioned scenarios are not just a futuristic outlook on the potential benefits of connected devices – rather they are some of the existing applications of the insights gained from machines talking to each other. These are exciting times in the world of connected devices. Devices today are helping companies and consumers learn a lot more about their ecosystem and are helping create new services and evolve new business models.

Hildebrand’s Smart platform powered by IBM Informix

Hildebrand is one such company which is focused on helping develop solutions for the retail, energy and transport industries using their Smart Platform. They recently used their Smart platform to launch a retail “footfall” tracking solution that collects and analyzes 250 million data points per day to deliver insights to retailers about dwell time, frequency of return visits. Apart from this, Hildebrand solutions continue to play an important role in the domain of energy usage and transport systems.

To tackle the big data, Hildebrand deployed IBM Informix database, which has built-in ability to handle massive amounts of Time-stamped data easily while providing faster storage, retrieval and real-time analytics

Constructing the IoT solution

IBM and Hildebrand are hosting a special event in London on December 10, 2014 focused on creating real world sensor-to-business value Internet of Things applications. This half-day event will feature a real world solution using IBM Cloud TimeSeries technology with Hildebrand data collection and analytics solutions.

If you are interested in learning how real-world IoT solutions are built, you can attend this half-day event on Dec 10th starting at 09.30 AM at the IBM Executive Briefing Center, Southbank, London and take the opportunity to meet the IBM team supporting IoT Industry solutions in the UK.

You can book your place by registering for the event here http://www.hildebrand.co.uk/IoTLondon/

If you would like to stay updated, follow @IBM_Informix on Twitter for the latest Informix announcements, and updates!

Bringing Informix Technology to the World’s Fastest Growing Database Market

By Sajan Kuttappa SWG
Informix Social Media Marketing & Communications Manager, IBM

If someone wanted more proof that Informix is technologically a step ahead of competitors, IBM provided evidence in China! Even the hardest cynic would find it difficult to rebuff the fact that the adoption of a locally innovated version of the Informix database for the burgeoning database market in China is a masterstroke

Why Informix over other competitors?

When one of the fastest growing markets in the world embraces Informix over other open source projects, it merits taking a second look (or maybe more) at what differentiates Informix from the rest of the competitors.

Before I begin extolling the virtues of the Informix database you can find details of the deal that was signed between IBM and GBASE here:  GBASE and IBM to collaborate on locally innovated database in China.

IBM Informix is a high-performance Enterprise Class Database that provides you with competitive advantage with its low cost, no administrative overhead, and powerful innovative features like OLTP and OLAP capabilities. Informix offers high availability in a significantly less complex, less expensive manner compared to competition for both distributed and centralized deployments.

Analysts agree that where database infrastructures must meet the challenges of the future, Informix is an obvious candidate. You can read the comparative analysis here.  IBM Informix – The database for high availability and data replication

The Proof of the pudding is in the eating.

A growing database market like China adopting Informix technology to create their locally innovated database is strong reference for the technological superiority of Informix. While a lot has been said about the superior capabilities of the Informix product, this deal will go a long way in reinforcing Informix as the number one reliable and highest performing database for most applications including the “Internet of Things”.

If you would like to stay updated, follow @IBM_Informix on Twitter for the latest Informix announcements, and updates!

Follow me on Twitter, LinkedIn, Google+

CrowdChat: Join Our Expert Panel And Get To Know dashDB

jasonBy Jason Burns
ITSO Social Business Manager for DB2

Are you facing challenges with your current data warehousing and analytics architecture? What role do cloud technologies play in your data architecture? Join us November 18th at 2:00 PM ET for an IBM Information Management CrowdChat as we take a deeper look at these questions and introduce you to dashDB, a powerful new cloud based data warehousing and analytics solution.

dashDB-checklistv2Don’t miss out on the many benefits that analytics on the cloud will bring for your organization. Get to know more about dashDB during this one hour open chat with experts Alan Hoffman, founder of Cloudant, Nancy Hensley, Director, Strategy and Marketing, Database Software, Sam Lightstone Chief Architect for Data Warehousing, and Adam Ronthal, Product Marketing & Strategy – Big Data, Cloud. Questions we’ll be addressing with our expert panel:

  1. What role do cloud technologies play in your data architecture?
  2. How do you see this role changing in the next 18 months?
  3. What are the benefits of analytics on the cloud for your organization?
  4. What are the pressures you are feeling from your lines of business around analytics?
  5. What would you like to know about dashDB?

What is a CrowdChat?

A CrowdChat is a free community virtual event platform that works seamlessly with Facebook, Twitter, and LinkedIn to allow users to engage in an online conversation held at a pre-arranged time around a topic using a specific #hashtag. You can sign in using your Twitter, Facebook or LinkedIn account. It’s easy (and fun!) to participate in a CrowdChat.

#dashDBCrowdChat details

Use your Twitter, LinkedIn or Facebook credentials to log in to the service using the URL below or by clicking here. The chat can also be followed on Twitter using the hashtag #dashDBChat. Anyone and everyone is welcome to join, especially the developer community!

Date: Tuesday, November 18th
Time: 2:00 PM ET
Link to Chat: http://www.CrowdChat.net/dashDB
Chat hashtag: #dashDBChat

Be sure to listen to the postcast before the chat: http://bit.ly/dashDBpodcast  Don’t forget to follow dashDB on Twitter @getdashDB

http://www.via-cc.at/020vc

Learn about DB2 at Kolkata India DB2 user event

There is nothing more exciting than hearing how to revolutionize your business with DB2 for Linux, UNIX and Windows, so here is your chance to unlock the best practices and learn from the experts. I encourage you to weave this event into your busy schedule this week. I promise you won’t be disappointed!
Join technical experts form TCS Capegemini and IBM to learn how to maximize your IT opportunities using the keys to master the DB2 LUW locking
During this half-day agenda, you will learn how to make the right decisions for your current and future architecture:

There is NO REGISTRATION FEE to attend this Non-IBM event & the LUNCH on event day will be SPONSORED by IBM
When : 15th Nov 2014 (Saturday) from 9:30 Am to 3:30 PM
Venue : Techno India Campus,Salt Lake,Sector V, Kolkata, India
Who can join : Anyone who is having interest in DB2 or working on DB2
How to book your seat : Send a mail from your official mail id to kidug.india@gmail.com with subject line “I will attend”

Leading Speakers from : Capgemini, MJunction, TCS, IBM
KIDUG_Nov2014_DB2_Event_Invite_mailer

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!

Inside IBM Insight 2014: What You Need To Know About The dev@Insight Program

Steve

By Steven Miller
Data Maestro, Talent & Skills Ecosystem

Something new and interesting is taking place at IBM conferences this year.  Maybe you’ve noticed the dev@ events?  If not, let me tell you about dev@Insight.

IBM Insight is a meeting of minds for data and anaytics. Big data and analytics are necessary to help your team improve every decision, optimize every process, and inform every interaction.  dev@Insight is a developers and architect-specific program that takes place along-side the Insight conference to give you the know-how, skills, and best practices for you to harness this all-important data and analytics. This is your opportunity to build new skills, learn how to build serious mobile & cloud data driven applications, to get to know technology experts, and to network with peers.

Join the thousands of architects, scientists and practitioners who will share their insights, experience and expertise in more than 130 hands-on labs, sessions, workshops, Ignite® talks, hackathons and certifications.  Learn from leading data and analytics experts, work through technical exercises at your own pace, and explore innovative new technologies.

dev@Insight is open to everyone who attends Insight 2014 with a valid registration. 

For full details, click here.

The Sunday kick-off starts at 4:30pm. Monday’s night’s main event starts at 7pm. Wednesday night’s finale starts hosted by the Cloudant team starts at 5:30pm (registration required).  Beer will be served at the evening events.

Book your build consult or hands-on lab now:

20 Quick Tips for Making the Most of Your Time at IBM Insight

Melanie StopferBy Melanie Stopfer
Consulting Learning Specialist, Information Management, IBM
If you’ve been to as many conferences as I have, you’ll know that there are certain habits that you can follow with so much going on around you.  Here are my 20 tips to make life easier for you at IBM Insight 2014 taking place October 26 – 30.

Tip #1: Get organized! Build your agendas at IBM Insight Conference Connect Center.    Log in with the username and password given to you in the registration confirmation letter.  Download the mobile version so you can take your agenda with you.  If there are too many sessions for you to navigate through, be sure to read the blog entries to help you choose the best sessions.

Tip #2: Avoid lines! Pickup you IBM Insight badge in the Bayside Foyer Mandalay Bay CC South Level 1 as soon as you can.  They are open on Saturday from 10AM-9:30PM  and Sunday from 7:30AM-9:00PM.

Tip #3: New to IBM Insight? You can walk many miles during a conference. Wear comfortable shoes and your fitbit! #HighHeelsRNotYourFriend

Tip #4: Meet experts, grab coffee and schedule meetings in the IBM Business Partner Café at IBM Insight.  Sign up at the Cafe welcome desk.

Tip #5: Register for InsightGo and stay connected at IBM Insight.  This is a free interactive digital platform for virtual conference experience.  This can be used even by those not attending the conference this year!

Tip #6: Follow IBM Insight social media on Tumblr, Facebook, Twitter, LinkedIn, Google+

Tip #7: Spend IBM Insight time at @StopHungerNow Expo Booth & package meals for malnourished kids. Register early.

Tip #8: Bring photo ID when pickup badge at IBM Insight registration. License, passport, or work ID required.  Your badge is GOLD – don’t lose it!

Tip #9: Interact, explore, network, kickback at InsightGO Lounge at IBM Insight. Contests, giveaways, video wall & charging stations!

Tip #10: For $30 take Test C2090-311:  IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 at the IBM Insight Certification Testing Center.

Tip #11: read Susan Visser’s blog to prepare for Certification Exams at IBM Insight.

Tip #12: Read IBM Insight Navigation, Tips, & Hints by Ember Crook.

Tip #13; Kick off IBM Insight right! Network & preview wide-ranging technology exhibits at Grand EXPO Welcome Reception, Sun. 6:00-8:30 PM.

Tip #14: Get grounded on what technology is hot at IBM Insight EXPO Theater.

Tip #15: Take charge of your career at #WIT panel. Learn how executives manage careers. Networking reception follows.

Tip #16: Baby it’s cold in there! Pack a sweater, wrap or jacket for IBM Insight. #MeatLockerTemps

Tip #17: Networking opportunities galore at IBM Insight. Pack a lot of business cards, get out there & mingle at EXPO, receptions & lunches.

Tip #18: Meet an author!  17 books are featured this year at IBM Insight with either a book signing, giveaway or both: Book Signings and Giveaways at IBM Insights 2014

Tip #19: Have fun at a No Doubt Concert!  Join us for Tuesday night’s special event featuring No Doubt!   No Doubt has won two Grammy Awards and five MTV Video Music Awards, launched international sold-out tours and were invited to perform for Paul McCartney and the President at the annual Kennedy Center Honors in 2010.

Tip #20: Get inspired!  Attend the general sessions to hear from Keynote speakers: Kevin Spacey, Captain Richard Phillips, Grant Imahara, and Terry Jones.

Follow

Get every new post delivered to your Inbox.

Join 51 other followers