Tech Talks – DB2 for Linux, UNIX and Windows

by Sajan Kuttappa, Content Marketing Manager

IBM DB2 for Linux, UNIX and Windows database software is the foundation that powers many IBM Analytics offerings. In conjunction with the International DB2 Users Group (IDUG®), the DB2 product team hosts a series of monthly webinars highlighting key capabilities, use scenarios, and various aspects of data management needs. Below, you will find a listing of past webinars and upcoming topics. If there are topics that you would like us to cover, please email us at ibmdatamgmnt@gmail.com

2017
Topic Presenters
Extending SQL: Exploring the hidden JSON capabilities in DB2 George Baklarz
Jump Start 2017 with a new DB2 11.1 Matt Huras, Roger Sanders
2016
Topic Presenters
dashDB for Transactions – Fully managed Andrew Hilden
DB2 on the Cloud – Moving to the cloud with full control Jon Lind, Regina
BM DB2 on SAP – V11.1 Update and Recent Developments Karl Fleckenstein
DB2 Security: From the Data Center to the Cloud Roger Sanders
DB2 Tech Talk: Data Server Manager and DB2 connect Mike Connor, Anson Kokkat, Shilu Mathai
DB2 Tech Talk: DB2 V 11 performance update Peter Kokosielis
DB2 V11.1 Deep Dive on BLU & Analytics Enhancements John Hornibrook, David Kalmuk
Breaking scalability barriers: A DB2 V11.1 Technology Review Matt Huras / George Baklarz
DBaaS for Developers on IBM Cloud. Andrew Buckler
Can you use your SQL skills for big data? Paul Yip
What’s New in IBM Data Server Manager V1.1.2 Anson Kokkat

IBM DB2 sessions at IBM Insight at World of Watson conference

by Sajan Kuttappa,  Marketing Manager- IBM Analytics Platform

As organizations develop next-generation applications for the digital era, many are using cognitive computing ushered in by IBM Watson technology. To make the most of these next-generation applications, you need a next-generation database that must handle a massive volume of data while delivering high performance to support real-time analytics. At the same time, it must provide data availability for demanding applications, scalability for growth and flexibility for responding to changes

IBM DB2 enables you to meet these challenges by providing enterprise-class scalability while also leveraging adaptive in-memory BLU Acceleration technology to support the analytics needs of your business. DB2 also handles structured and semi-structured data from a variety of sources to provide deep insight. With the ability to support thousands of terabytes, you can use historic and current data to identify trends and make sound decisions. The new release DB2 11.1 that was announced earlier this year comes packed with many enhancements for BLU, OLTP, PureScale, security, SQL, and more!

Whether you are interested in an overview of the improvements available with the new release or an in-depth understanding of the new enhancements, IBM World of Watson is the place to be.  The IBM Insight conference is now part of IBM World of Watson 2016 on October 24-27 and continues to be the premiere industry event for data and analytics professionals, delivering unmatched value and exciting onsite opportunities to connect with peers, hear from thought leaders, experience engaging content, and receive training and certification.  This article will highlight the key DB2 sessions at the IBM World of Watson conference.

We will start with Session #3483 by Matt Huras, IBM DB2 Architect who will provide a technical overview of the new release and the value the new features provide for your installations. We also have the following sessions that provide deeper coverage for the new enhancements available with the new release

  • DB2 11.1 includes significant enhancements in the area of availability — particularly around the pureScale feature. You can attend the Session #1433 – “The Latest and Greatest on Availability and pureScale in DB2 11.1” to learn about these enhancements, including simplification of deployment, new operating system and virtualization options, HADR updates, and improvements in the areas of management and multitenancy.
  • DB2 11.1 packs several enhancements to protect your data whether they are on-premises or on the cloud. Do look out for Session #1038 – “DB2 Security: From the Data Center to the Cloud” for an overview of the various security mechanisms that are available with the latest version of DB2 for Linux, UNIX, and Windows, as well as introduce you to several things that must be taken into consideration if you plan on moving your DB2 database environment from the data center to the cloud.
  • There is a lot of talk about in-memory computing and columnar multi-partitioned databases to improve analytic query performance. DB2 1 brings MPP scale to BLU! If you need a detailed step-by-step approach to implement the newest version of DB2, come learn about often overlooked but very important best practices to understand before and after upgrading by attending the Session #1290– “Upgrading to DB2 with the Latest Version of BLU Acceleration”  
  • DB2 11.1 is the foundation for hybrid cloud database deployments. In addition to being available to install on cloud-based infrastructure it is also the foundation of DB2 on Cloud and dashDB cloud data service offerings. Attend the Session #1444 – “Hybrid Cloud Data Management with DB2 and dashDB” to learn more about these different options and when you’d want to choose one over another.
  • If you are deploying DB2 for SAP applications, we have lined up Session #2629 by SAP and IBM experts – “IBM DB2 on SAP – V11.1 Update and Recent Developments”.  In this session, we will give an overview of recent SAP on DB2 extensions and which DB2 V11.1 features are most important for SAP applications.  One of our clients – BCBS of TN will also share their experiences with DB2 V11.1 around analytics and the benefits that they’ve seen.

Our clients Nordea Group and Argonne National Laboratory will also share their experience with deploying IBM Data Server Manager.  The hands–on-labs HOL 1766B – “DB2 High Availability and Disaster Recovery with Single or Multiple Standby Databases” allows you to configure and manage a production database with single or multiple standby databases using DB2 HA/DR facilities.

If you are a new user of DB2, you can also read this guide to the introductory DB2 sessions . Whether you are determining your next move or optimizing your existing investments in data and analytics capabilities, the IBM World of Watson 2016 conference is the place for you. This is your opportunity to get the training, answers, certifications and insights you need to be at the top of your game . If you have not yet registered for the conference, we suggest you visit this link and register yourself  –  bit.ly/WorldofWatson 

IBM DB2 – the database for the cognitive era at IBM World of Watson 2016

sajan

 

 

by Sajan Kuttappa,  Marketing Manager- IBM Analytics Platform

IBM Insight, the premiere data, analytics and cognitive IBM conference, is now part of IBM World of Watson 2016 to be held at Las Vegas from October 24-27.  This year attendees will be able to experience first-hand a world of cognitive capabilities that IBM has been at the forefront of. World of Watson incorporates the kind of information you gained from IBM Insight — the tools and best practices to manage your data — and raises the game. You’ll also see how Watson’s capabilities give you a broad view of your business, its competitive landscape and what it takes to make your customers act. Our CEO – Ginni Rometty will deliver a keynote at this year’s conference. And on the evening of October 26th, our special event will feature Grammy winner Imagine Dragons.

Whether you’re a beginner or a seasoned DB2 professional, there is a treasure trove of information that you could walk away with. IBM experts and your peer speakers will share information about migration guidelines, new features of recent releases, implementation experiences, and much more. Likewise, our hands-on-labs (HOL) complement these topics to further enrich the experience.

For users new to DB2, we recommend attending session 3585 on “DB2 v11.1 Fundamentals” by Roger Sanders.  This presentation will provide a great overview of DB2 for Linux, UNIX and Windows. It will take attendees through the concepts covered on the DB2 11.1 Fundamentals certification exam: planning, security, working with databases and data objects, using SQL, and data concurrency. It will also provide a brief introduction to other DB2 based offerings like DB2 on Cloud and dashDB.

IBM provides number of database options for organizations who would like to deploy applications on the cloud – be it fully managed or hosted environment.  IBM dashDB for transactions provides a fully managed database service in the cloud that is optimized for online transaction processing workloads. DB2 on Cloud is a hosted service that offers the agility of cloud deployment and the management control you enjoy with the on-premises software.

  • If you would like to understand the capabilities of the dashDB for Transactions offering, consider attending session 3471 on “dashDB for Transactions: Fully Managed and Truly Awesome,” where we will discuss key features of this enterprise class service and its design and implementation for availability and performance.
  • DB2 on Cloud offering gives you everything you know and love about DB2 for Linux, UNIX and Windows software in a cloud environment hosted by IBM. You still have full DBA control to customize the database. You can rapidly provision it for instant productivity. And the monthly subscription-based licensing makes it easier to predict and control costs. As with any OLTP database supporting your critical applications, high availability and disaster recovery concerns are top of mind. We have lined up a session (Session #1439) that will help you understand how to “Implement High Availability and Disaster Recovery for DB2 on the Cloud.”

You can learn how to further optimize DB2 performance with management tools like IBM Data Server. The Hands-on-Lab  3141A- Secrets of the Pros: Using Data Server Manager to Monitor, manage and Mitigate Performance Problems will teach you how to use the latest version of IBM Data Server Manager to diagnose and resolve performance problems.

We hope that you can take advantage of these sessions by attending the World of Watson conference. Stay tuned for our next article on sessions for “Intermediate” skill sets and “Advanced” users.

We look forward to seeing you in Vegas. If you have not yet registered, please visit this link for more details – http://bit.ly/WorldofWatson

Golf, Beaches and Informix – Welcome to Florida!

By Sajan Kuttappa, Marketingsajan Manager – Analytics Platform Services, IBM

IBM Informix has forged new frontiers with its ability to effectively manage large amounts of data from the Internet of Things. You can also seamlessly integrate non-standard data types, with a rich set of APIs including REST, that enhance development simplicity, flexibility and time to market. All of this without compromising on availability, scalability and security which make it the most powerful enterprise class database in the market today

While Informix has evolved over the years to stay in tune with rapid advances in technology, the annual IIUG conference has established itself as the premiere data and analytics conference and the best place to learn about the latest updates from the technology world. The best brains are selected to share their expertise during 3 days of educational sessions that will help the audience develop key skills for career advancement while also providing great networking opportunities with IBM executives, Informix development team and more.

In 2015 we celebrated 20 years of the IIUG and I am sure the emotional moments from the conference held at San Diego last year will be etched in the memories of all those who attended. The 2016 conference will be held from May 4th – 8th at the Sawgrass Marriott Golf Resort & Spa, Ponte Vedra Beach, Florida, USA and the lineup of speakers and sessions looks very promising.

At the home of the PGA tour, you will be served an excellent platter of technical educational sessions that cover everything from the benefits of Hybrid databases, Spark analytics with Informix, Tools and technologies for the world of Internet-of-Things (IoT). You can further benefit from the optional tutorials on May 8th around database administration, application development and tools on Sunday. Become IBM Informix Certified by taking the IBM Informix Professional Certification exams or almost any other IBM Information Management exam (the first exam is usually free at a savings of about $150).   IIUG banner

Visit www.iiug2016.org for more details and register yourself. Paid registration includes full access to IIUG 2016 from May 4 – 8 including continental breakfast and lunch each day, the Wednesday evening reception and admission to IIUG party on May 5 and 6. IIUG members who register online get $100.00 off registration fees

So get ready to tee off with the best minds in the technology world. Welcome to Florida!

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

Rapid Insight With Results: Harnessing Analytics in the Cloud

basirBy Basiruddin Syed
DB2 Social Marketing Manager

“It’s Now or Never” is a popular song recorded by Elvis Presley and the lyrics of this song seem to appeal to us now more than ever. Every day we are making decisions in our lives, both personal and financial. We are often seen contemplating which holidays to book, is this right time to invest, etc. We are constantly making decisions and our decisions are based on information, user reviews, and recommendations.

When individuals are facing such pressure to make quick decisions, Imagine how much harder it must be for larger organizations.

Decision-making can be regarded as the cognitive process resulting in the selection of a belief or a course of action among several alternative possibilities.

Individuals are facing a lot of pressure to make rapid decisions and choose the best course of action within a short span of time, and it much more difficult when the time drastically reduces for organizations who’s needs are much higher and the time frame is compressed.

Today’s data-driven organization is faced with magnified urgency around data volume, user needs and compressed decision time frames. In order to address these challenges, Organizations are exploring cloud based BI and analytical technology to accelerate decision making and enhance business performance.

Find out more on how organizations are making this possible “Rapid Insight with results: Harnessing analytics in the cloud”

 

incldm

Whatever you do, stay uncompromised!

Radha

Radha Gowda, Technical Marketing, IBM Analytics

That is the new marketing campaign for all new Audi A3 – a luxury without compromise at an affordable price. How does Audi AG accomplish that? By creating super-efficient business processes for a start.

Audi AG, facing growing competition from global auto companies, teamed up with IBM and implemented server virtualization using IBM PowerVM® and migrated over 100 SAP systems from HP-UX with Oracle 10g database to IBM AIX 6.1 with IBM DB2 9.7. With the IBM private cloud ready infrastructure underpinning its SAP systems, Audi now has a robust, flexible, and high-performance platform for managing its business operations. As the company tackles increasing competition, the ability to expand and contract its SAP solutions in line with changing demands will help Audi to ensure that it has the right IT resources in place, at the right cost of ownership.

Need for a more sustainable infrastructure

With over eight production plants across the world and increasing competition, the IT Services Department at Audi needed to help the company address multiple business challenges – increasing demands from employees, customers and suppliers, variable sales volumes, rising cost pressures, and the need for new technologies. They envisioned a flexible virtualized infrastructure that is more flexible and sustainable, and equally important was the availability and performance of over 100 business-critical SAP systems.

“IBM created an environment that enabled us to compare DB2 9.7 with a reorganized Oracle 10g database, both running on IBM Power Systems servers. The results were clear: storage savings in the range of 50 to 70 percent, and much higher performance when using DB2.”
— Markus Wierl,Service Owner of SAP Infrastructure AUDI AG

Cloud for flexibility and speed

Teaming with IBM, Audi implemented server virtualization using IBM PowerVM® and migrated over 100 SAP systems, including more than 30 SAP landscapes and 26 high-availability clusters, from HP-UX with Oracle 10g database to IBM AIX 6.1 with IBM DB2 9.7. The new SAP landscape runs on dual-data-center, symmetrically implemented ‘private cloud ready’ infrastructure, with the infrastructure hosted by Audi and managed by IBM. Virtualization enabled Audi to pack a large number of separate business systems onto a small number of physical servers, pushing up utilization and eliminating costly unused capacity. Rather than having each logical system tied to a particular physical server, and only able to expand through the physical addition of new hardware, Audi can now reallocate resources on the fly from one system to another as required, and respond faster and more cost-effectively to new business requirements.

This really was an impressive accomplishment by the IBM team: migrating more than 100 SAP systems to a completely new operating system and database in six months and with no disruption.” — Markus Wierl

Supporting business excellence

We trust the IBM infrastructure to run our production systems, which are absolutely business-critical,” says Markus Wierl “Any significant unplanned downtime could lead to a stoppage on our production lines. Modern automotive manufacturing is based on just-in-time concepts, and involves a large and complex partner ecosystem. So any minor disruption to production can rapidly turn into a major problem for multiple parties. For this reason, we highly value the robustness and availability of the IBM Power Systems and BladeCenter technology for our SAP solutions.

Download how Audi gears up for continued success with IBM private cloud for complete details.

Migration is a factor in natural selection. Stay uncompromised as you evolve your data management systems.

Follow Radha on Twitter @radgo1

It’s the Most Wonderful Time of the Year

Melanie Stopfer

Melanie Stopfer , Consulting Learning Specialist, Information Management, IBM

It’s getting close to one of my favorite weeks of each year – IDUG North America Technical Conference.  Break out the eggnog and mistletoe.  I feel like a child before Christmas that’s counting the days to open presents.  This year there’s even a bigger present waiting because my 83-year old mother and younger sister live in the Phoenix area. IDUG DB2 2014 Technical Conference will be held at Sheraton Downtown Phoenix Hotel and Convention Center, May 12-16.

IDUG is the foremost independent, user-driven community that provides a direct channel to thousands of professional DB2 users across the globe.  At the conference you gain access to influential decision makers.  You can also raise your profile by gaining a deeper understanding of marketplace needs and the competitive environment.  There are so many opportunities to engage with current and potential customers looking to learn about DB2 and related technologies to improve business performance.

Use the following tidbits to provide justification for your attendance.  Sometimes planning your week can be a little time consuming and for the new attendee a little overwhelming so use the following information to experience a very successful week.

Monday, May 12 – IDUG One Day Seminars
Take a deep dive into specific aspects of DB2 with some of the most renowned speakers in our industry.  You will not only have the opportunity to listen to these speakers but will have the opportunity to ask them specific questions as well.  There is an additional registration fee for these seminars of $425 for paid full IDUG Conference delegates ($475 for unpaid) which includes lunch and a hard copy of the materials. Select from the following session topics:

  • Advanced SQL Coding and Performance (Dan Luksetich)
  • DB2 10 for z/OS System Admin Crammer class for Certification Exam 617 (Judy Nall)
  • DB2 10.1 for Linux, UNIX, and Windows Database Administration Certification Exam (Exam 611) Preparation (Roger Sanders)
  • DB2 11 for z/OS Database Administration Certification Crammer Course (Susan Lawson)
  • DB2 LUW Problem Determination and Troubleshooting Workshop (Pavel Sustr and Samir Kapoor)
  • DB2 V10+ for LUW Top Gun Performance Workshop (Martin Hubel and Scott Hayes)
  • The BEST of the BEST of the THINGS I WISH I”D TOLD YOU 8 YEARS AGO (Bonnie Baker)

Tuesday, May 13 – Keynote Speaker
Donald Feinberg, vice president and distinguished analyst in Gartner Intelligence Information Management group, is responsible for Gartner’s research on database management systems and data warehousing infrastructure and Big Data.  I can’t wait to hear his insights.

Tuesday, May 13 through Friday, May 16 – Attend your selected technical sessions  Build your personalized conference agenda using IDUG’s My Conference feature .  Customize your week at IDUG with technical sessions, technical networking sessions and social networking opportunities. The My Conference feature also allows you to evaluate sessions and the overall conference. You can download your custom agenda or sync with your calendar (Google Calendar, Outlook 2010, etc.) and have the information at their fingertips.  Check out the agenda by technical track, time, or title.  Just click on the title to get speaker bio, session abstract, and session objectives.  Don’t forget about the new track Big Data and Analytics.  You can choose technical sessions from the following tracks:

  • Ala Carte
  • Big Data and Analytics
  • DB2 for Developers
  • DB2 for LUW – I
  • DB2 for LUW – II
  • DB2 for z/OS – I
  • DB2 for z/OS – II

Consider selecting my two presentations:

  • Wed May 14, 8:00 AM, Paradise Valley – C05 Best Practices Upgrade to DB2 10.5 with BLU Acceleration
  • Thu May 15, 1:00 PM, Camelback – D11 Using Row and Column Access Controls (RCAC) with DB2 LUW 

Wednesday, May 14, 3:30-4:45  – Special Interest Groups (SIGS)
Get face-to-face with developers and technical experts and discuss what’s hot.  Where does your special interest lie?  Wish I could clone myself and attend more than one SIG.  Walid Rjaibi, IBM’s Chief Security Architect for Information Management, Rebecca Bond, R Bond Consulting, Inc., and I will co-chair SIG1F – Security and Data Masking.

  • SIG1A – DB2 Memory Usage, Futures and Features
  • SIG1B – Fun with SQL
  • SIG1C – Maintaining Big Data
  • SIG1D – DB2 BLU Acceleration
  • SIG1E – DB2 Compression – What are the options? What are the license implications?
  • SIG1F – Security and Data Masking
  • SIG1G – DB2 in the Cloud (SIGS)

Thursday, May 15, 7:30-8:30 AM – Call for Volunteers Breakfast

IDUG relies on its members to leverage the technical and business acumen of DB2 professionals. It is because of dedicated members that IDUG exists.  To continue to provide the best networking and education to IDUG members worldwide, IDUG is always looking for active volunteers. Take part!  Get involved!  Help build IDUG’s future.

Thursday, May 15, 12:00-1:00 PM – Speaker Feedback Lunch

A great opportunity for speakers to discuss their experiences with the IDUG NA conference team.  Meet for lunch in Encanto A and provide valuable feedback to planning committee to improve the process for next year.

Thursday, May 15, 4:45-6:00 PM – Mini-Panels

You can submit your questions early at the registration help desk.  Always a lively Q&A with lots of technical answers and often hints of what is coming in the future.

  • SIG2A – z/OS Mini Panel
  • SIG2C – LUW Mini Panel (SIGS)

Thursday, May 15, 6:30 PM – DINE AROUND EVENT

FILL IN THE BLANK:  ”10 DBAs walk into a restaurant and ­­­­­­­­­­­­­____________.”
Seriously, the night is your oyster.  What a great opportunity to make new friends and renew previous relationships.  Every year, I have such a great time meeting new people and learning about them.  Don’t miss this event.  Sign up early with your favorite speaker’s restaurant since the limited number of spots go quickly.  Each diner receives a separate check for their charges. Ember Crooks, IBM Champion and db2commerce.com blogger, and I are the speakers assigned to dine at Pizzeria Bianco.  Who wants to join us for Italian?

Friday, May 16, 8:00 AM to 2 PM  –  Complimentary Technical Workshops
Wowza – who doesn’t love a free workshop?  What a great opportunity to build your technical skills!  You register for the workshops when completing your conference registration.

  • DB2 BLU Acceleration for the Cloud Workshop – Learn about the exciting new enhancements with DB2 BLU, how they relate to Cloud implementations and how they can provide data insights to your organization fast and easily.
  • DB2 11 Migration Planning Workshop –  DB2 11 gives back with more out of the box performance improvements, greater migration flexibility, many optimization’s, administration, and application features.  Leave the session with materials that you can use to start your installation/migration immediately, or in the future.

FREE IBM CERTIFICATION EXAMS

All DB2 Tech Conference attendees can take a FREE IBM CERTIFICATION EXAM! Each attendee may take one exam for free and if they pass they are eligible for a second free exam. Additional exams will be offered at the low discounted price of $25. Prepare by attending one of the pre-certification education seminars on Monday listed above. The closing time listed is the last seating for the day. Go early in the week because time slots fill up towards end of the week.  Exams will be administered:

  • Tuesday, May 13: 10:00 – 17:00
  • Wednesday, May 14: 9:00 – 16:00
  • Thursday, May 15: 8:00 – 17:00
  • Friday, May 16: 8:00 – 12:00

Products and Services Expo
Walk the exhibit hall and take advantage of the excellent opportunity to learn more about the latest DB2 technologies.  While you pick up some great souvenirs, absorb the technical content you need to be successful.  Several vendors will be handing out invitations to parties where you can network the nights away.  The expo is open:

  • Tuesday, May 13, 5:30 pm – 7:30 pm
  • Wednesday, May 14, 11:30 am – 1:00 pm, 4:30 pm – 6:00 pm
  • Thursday, May 15, 11:30 am – 1:00 pm

First Time Attendees and IDUG Mentors Discount
Discount!  Did someone mention $$$SAVINGS$$$? The IDUG Mentor program recognizes and helps loyal IDUG attendees, IBM Champions and RUG Leaders share their DB2 knowledge with first time attendees. If you fall into one of these categories you are eligible to apply for a coupon worth 80% off the registration rate for a first time attendee. First time attendees can take advantage of this offer by reaching out to a co-worker that falls into one of these categories. To apply or for more information about the IDUG Mentor Program visit the IDUG Mentor webpage:

Justification for Attending IDUG Conference

Go to the IDUG website and download the Justification Letter and How to Justify list.

Tips

  • Remember to register for a complimentary technical workshop when completing your conference registration.
  • Build your agenda before arriving so that you don’t overlook your favorite speaker or topic.  There is so much happening during the week that you will want to take advantage of every opportunity.
  • IDUG NA Conference home website
  • Build time in your agenda to take at least one complimentary certification exam.  All results are private unless you decide to share the news.
  • Make “lunch dates” with fellow attendees or speakers.  No one likes to eat alone.  Your invitation will make someone’s day. 
  • Bring a light jacket, sweater or wrap.  Convention Centers are really meat lockers in disguise.
  • Sign up to moderate at least one session.  Besides the thread chair becoming your new friend, you get to meet the speaker, and become involved with a great organization.  What a great and easy way to get involved!
  • Pack extra business cards.
  • Use the #idug hashtag in your Tweets.
  • On Friday technical sessions end at 11:45 AM and complimentary technical workshops end at 2:00 PM.

If you are interested in networking opportunities with fellow users, product developers and solution providers, user-driven product training and quality continuing education, IDUG DB2 Technical Conference is for you!

Watch out Santa because I’m opening my presents early – IDUG is coming to Phoenix.  See you there.

——–

Melanie Stopfer is a Consulting Learning Specialist and Developer for IBM Software Group. She is recognized worldwide as an advanced database specialist. As a Certified DB2 LUW 10.5 Technical Expert and Learning Facilitation Specialist, she has provided in-depth technical support to IM customers specializing recovery, performance and database upgrade and migration best practices since 1988. In 2009, Melanie was the first DB2 LUW speaker to be inducted into the IDUG Speaker Hall of Fame and was again selected Best Overall Speaker at IDUG EMEA 2011 and 2012 and IDUG NA 2012. In 2013, IOD rated her presentations in top two for customer satisfaction.

Connect with Melanie on :

Data Analytics, or How Much Info for a Buck?

Bill Cole

Bill Cole – Competitive Sales Specialist,Information Management, IBM

Leave only footprints; take only pictures.  Have you seen that slogan in a national park?  My wife (she’s now an ex) didn’t believe the signs that told us to leave everything exactly where it was.  She didn’t want to just enjoy the beauty.  She wanted to take some home with us.  The flashing light of the Park Ranger car told me we were in trouble for picking up a few rocks along the side of the road.  The nice man in the Smokey hat told me to put the rocks back.  The scenery is for consumption with your eyes, your camera, not for taking home.  I did as instructed, happy to be leaving with my wallet in one piece.

I’ve always produced data and then turned it into information by adding other bits of data together and adding some context.  My users guided me for a while and then I both guided and pushed them.  This seemed to be the natural order of things, sort of like factories and the folks who buy the goods from those factories.

The IT/BI/DA teams accumulate and store the data and then massage to build what are essentially standard reports.  Standard reports are good for standard thinking, of course.  If you know the answer you’re looking for, a standard report probably has it in there somewhere, like those old balance sheets and ledgers that I ran so long ago.  But there was nothing in those reports that would help think outside of the data on those reports.  In fact, there was so little insight in them that one of the plant managers actually asked me what good these reports were.  There’s really not a good response to that one.

Insights are gained when the lines of business can chase an idea through all sorts of non-standard iterations.  Almost like chasing one of those happy mistakes from science, like penicillin, or those ubiquitous not-very-sticky note sheets that we all stick all over everything so we can easily keep track of passwords, etc.  LOL, like you haven’t done that.

So how do we get to this idea-chasing sort of thing?  This place where the data analysts or, better still, the line of business user can see something interesting and start chasing it?  This is custom-developed solution, a virtual pair of bespoke shoes that were for your situation and only for your situation.  The person in the next cubicle needn’t look over your shoulder.  It would do them no good after all.  There’s a scene in the Maureen O’Hara/John Wayne move “The Quiet Man” in which John asks directions and the local says “Do you see that road over there?  Don’t take it, it’ll do you no good.”  Insights are like that.  You need to know not to walk down a road that will do you no good.

The trick, it seems to me, is having the right tools.  Let’s start with the database (you know I’m a practicing DBA and that means all discussions start with the database).  DB2 BLU is exactly the right repository for your decision-making data.  After all, it offers both row- and column-oriented models in a single database!  This means you’re getting performance no matter which way your data chooses to be represented.  Moreover, there are different kinds of compression to ensure you save space and improve performance.  What could be better?  And all for the price of an upgrade!  Easy.  No-brainer.

There’s a neat coda to this, too.  You’re not confined to the old solution of finding a server, building it and installing the software, then building the database.  Let’s talk choices, folks.  Lots of choices.  Maybe every choice.  On premise, just like we’ve always done, works.  Maybe your own cloud would be better.  Build your BI/DA system in a PureFlex or PureApp or PureData cloud hosted in your own data center.  There’s a simple solution with lots of benefits including workload management.  Set it and forget it and go on about your business.  Maybe DBaaS works better.  Virtualize the workload and database in an existing private cloud to make use of those “excess” mips.  (Parkinson’s Law says that any organization grows to fill all the space available.  I think the demand for mips grows to fill the available servers, thus negating the concept of “Excess mips.”)  There’s SoftLayer for either a public or private cloud.  Remember, they’ll go all the way to bare metal if that’s what you need.  Finally, maybe best, is DB2 BLU available in the cloud. I championed this a while back and it’s now reality.  A pre-configured database that IBM manages and maintains, including backups and upgrades.  Talk about easy!  Go ahead, get some sleep.  We’ve got this one.

One last thought about the tools.  InfoSphere Analytics Server will do the analysis for you and present your users with suggested insights right out of the box.  And it will help the folks find their own insights by helping them look, filter and massage the data in any way that suits them.  It’s a cool tool for those times when you need the freedom to find your own way through the forest of data.

Finally, I’ve always kept two Robert Frost poems on my wall.  Perhaps, “Two Roads Diverged in a Yellow Wood” is the one for this post.  We in IT need to give the folks in the lines of business the right tools to chase down the new roads, new insights.  We’ll give the GPS for the roads less traveled by.  Good luck on your journeys of exploration!

The other poem is “Stopping By Woods On a Snowy Evening,” of course.  We all have miles to go before we sleep, before our work is complete, and using the right tools makes those miles ever so much more productive.  Bundle up on those snowy evenings and enjoy the ride.

Follow Bill Cole on Twitter : @billcole_ibm

Visit the IBM BLU HUB to learn more about the next gen in-memory database technology!

Datawarehousing on the Cloud – Twitterchat

#IBMBLU Twitterchat on Wednesday March 26th – 11 am to 12 pm ET

Enterprises thrive when the primary focus is on innovation and achieving business goals, without distractions related to the underlying infrastructure or large capital expenditures. Cloud computing technology is the rage right now, due to the flexible infrastructure and services that it provides and the agile methodology that enterprises can adopt, as a result.

Datawarehousing and analytic solutions help businesses glean valuable game changing insights from the huge torrent of data that heads their way – every day. Traditionally this would mean complex data management environments, a large team of experts and investments in infrastructure and technology so as to stay at the forefront of emerging trends.

The emergence of Datawarehousing solutions on the Cloud helps simplify and accelerate the delivery of insights from data, without the need for sophisticated environments and big budgets. BLU Acceleration for Cloud from IBM breaks the cost and complexity barriers and brings market leading technology to everyone with the need to analyze vast amounts of data. Powered by IBM BLU Acceleration, breakthrough in-memory database technology, and combined with Cognos BI, users can experience a simple, agile cloud solution.

Join us for an #IBMBLU Twitterchat on the topic of Datawarehousing on the cloud – March 26th, from 11:00 am to 12:00 pm ET.

Our special guests for this Twitterchat are Antonio Cangiano – IM Cloud Computing Center of Competence and Evangelism, Leon Katsnelson -Director, IM Cloud Computing & Mobile, Adam Ronthal – Product Marketing & Strategy – Big Data, Cloud, Appliances, Grant Hutchison – Educator, Big Data University,  Rav Ahuja – Senior Program Manager – Cloud Computing and Big Data.

You can follow along—and join the discussion using the hashtag #IBMBLU.

We look forward to your thoughts and comments on the #IBMBLU twitterchat hosted by @IBM_DB2.

Here are some questions that we’ll discuss on the twitterchat, and additional reference topics to help inspire the conversation.

  • What use cases and applications for analytics and data warehousing in the cloud do you see as particularly relevant?
  • What are your biggest concerns about analytics and data warehousing in the cloud?
  • What are the biggest advantages you see in embracing cloud for these types of application?
  • What sources of data do you see as most relevant for data warehousing in the cloud?
  • How can cloud computing augment your existing on-premise systems?
  • What analytic tools do you need to be able to use in the cloud? (BI, predictive modeling, ETL, etc…)
  • How big are the datasets you would want to use cloud data warehousing for?
  • What is best approach to securing data in the cloud?

The Enterprise Data Warehouse is Virtualizing into the Big-Data Cloud – James Kobielus
What will you do with your 5 hours? – Grant Hutchison
When is the Cloud Appropriate for Data Warehousing and Analytics? – Adam Ronthal
BLU Acceleration for Cloud Is Now Available to Everyone – Antonio Cangiano

How do you join in?

If you use a Twitter client like Tweetdeck or HootSuite, create a search column for the term ‘#IBMBLU’. Then as participants tweet with the #IBMBLU hashtag, those tweets will appear in your column.

How do you participate?

It’s as easy as BLU. Read- Tweet- Share!

Review the discussion questions posted in advance so you can prepare your thoughts and answers. When the question is posed, begin your response with A1: for question 1 and A2: for question 2, and so on. This makes it easier to follow the conversation throughout the chat. No answer is wrong!

For more information on twitterchats – take a look at the slideshare below!