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
Managing your DB2 on Cloud environment Kelly Schlamb
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

DB2 for SAP – Poised for growth

800x400_minn

Like most organizations, your company is pressing ahead to close out projects and prepare new ones for the coming year. Inevitably, these annual evaluations and reviews call into question the preservation of your existing IT investment while exploiting new areas for growth. Some vendors strongly encourage vertically integrated solutions with a promise of seamless operation, but reality dictates a closer look at technology choices.

If you’re currently running an SAP environment with DB2 for Linux, UNIX and Windows software, there are quite a few options available to help you leverage existing DB2 infrastructure and be well positioned for new projects. You are cordially invited to attend a half-day seminar to learn key DB2 insights and considerations for SAP environments.

Our IBM SAP experts will:

  • Outline issues and factors affecting database use with SAP
  • Go over key considerations on selecting solutions
  • Provide a DB2 for Linux, UNIX and Windows Roadmap
  • Showcase breakthrough in-memory technologies
  • Illustrate how your continued use of DB2 for Linux, UNIX and Windows in SAP environment is not just safe but the optimal one for growth

The seminars will be held at 2 cities in North America. Please find below details and register for the one nearest to your city

  1. Cincinnati   – Monday, December 12th, 2016 from 9:30 AM –2:30 PM EST

http://ibm.biz/BdsqQv

     2. New York City –  Tuesday, December 13th, 2016 from 9.30 AM – 2.30 PM EST

 http://bit.ly/2fRPn1B

After all, wouldn’t you want to know how to make existing investment work smarter without the risks of rip and replace?

 

 

 

The value of common database tools and linked processes for Db2, DevOps, and Cloud

Michael

by Michael Connor, Analytics Offering Management

Today we released DB2 V11 for Linux, UNIX and Windows. The release includes updates to Data Server Manager (DSM) V2.1 and Data Server Driver connectivity V11 and Advanced Recovery Feature (ARF) V11.    As many of you may be aware of – 2 years ago we embarked on a strategy to completely rethink our tooling strategy.  The market was telling us we needed to focus more on a simplified user experience, a web console addressing both the power and casual user role, and deliver deep database support in support of production applications.  In  March 2015, we delivered our first iteration of Data Server Manager as part of 10.5.  This year we have yet again extended capability to this valuable platform and in addition extended support across a number of IBM Data stores including DB2, dashDB, DB2 on Cloud, and BigInsights.

First let’s talk about some of the drivers we hear related to Database Delivery.

  1. The LOB and LOB developer communities want access to mission critical data and extend that data through new customer facing OLTP applications.
  2. Business analysts are using more data than ever – in generating and enhancing customer value through Analytic applications.
  3. These new roles need on demand access to data across all aspects of the delivery lifecycle from idea inception to production delivery and support.
  4. While the timelines are lessened, the data expanded and the lifecycle speeded up, quality cannot suffer.

Therefore, the DBA, Development, Testing, and Production support roles are now participating in activities known as Continuous Delivery, Continuous Testing, and DevOps.  With the goal of improving customer service, decreasing cycle and delivery times, without decreasing quality.

DSM pic1Some areas that are addressed by our broader solutions for Continues Delivery, Testing, and DevOps include:

  • High Performance Unload of production data and selective data environment, including test data environment restore with DB2 Recovery Expert
  • Simplified test data management addressing discovery, subsetting, masking, and refresh with Test Data Management.
  • Automated driving of application test and performance based workloads with Rational Functional and Performance Tester.
  • Release Management and Deployment automation with Rational Urbancode.

And finally, areas improved with our latest DB2 releases

  • SQL Development and execution with Data Server Manager
  • Test and Deployment Data Server Monitoring with Data Server Manager
  • SQL capture and analysis with Data Server Manager
  • Client and application Data Access, Workload and Failover management with Data Server Drivers

DSM Pic 2The Benefits of considering a Continuous — Solution include reduced cycle times, lower risk of failure, improved application performance and reduced risk of downtime.

With the V11 Releases we have delivered enhancements including:

  • DSM: DB2 LUW V11 support  and monitoring improvements for PureScale applications, Extended Query history analysis
  • ARF: DB2 LUW V11 support and improvements for Analytics usage with BLU Acceleration
  • DS Driver (Also DB2 Connect): Manageability improvements, Performance enhancements, and extended driver support now for iMAC applications.

DSM Pic 3Many of the improvements noted above are also available for our private Cloud offering in preview DashDB Local – which leverages DSM as an integral component of their dashboard, and our public Cloud offering DB2 on Cloud.

Read more details about the announcement for further information:   http://www-01.ibm.com/common/ssi/ShowDoc.wss?docURL=/common/ssi/rep_ca/9/872/ENUSAP16-0139/index.html&lang=en&request_locale=en

Also check out the DB2 LUW Landing Page:  http://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html

 

Blogger:    Michael Connor, with Analytics offering management, joined IBM in 2001 and has focused early in his IBM career on launching the z/OS Development Tooling business centered on Rational Developer for z.  Since moving to Analytics in 2013, Michael leads the team responsible for Core Database Tooling

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!

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.

Steps toward the Future: How IBM DB2 is changing the Game

toriTori McClellan
Super Awesome Social Media Intern

 

Welcome to the New Age of database technology!

IBM DB2 with BLU Acceleration changes the game for in-memory computing.  Due the importance of in-memory computing, we created a dedicated website to take you through all the details, references, and more: www.ibmbluhub.com !  This website is in place to help clients and prospects understand what next-gen in-memory computing can do for them and why IBM BLU is the ideal in-memory database to deliver fast answers.

A few examples of how IBM BLU has helped other clients find their ideal balance between speed and quality:

  1. Regulatory reporting is a huge challenge for all banks – Handelsbanken, one of the most profitable banks in the world, is currently doing reports monthly but are expected to do them daily in the near future. DB2 with BLU Acceleration has helped Handelsbanken analysts get the data they need for daily reports via columnar store. Learn more by watching this video: http://bit.ly/1u7urAA
  2.  Deploying DB2 with BLU Acceleration is simple – with only a handful of commands, you can turn on analytics mode, create a new or auto-configure an existing database to make best use of your hardware for analytics, and then load the data. Learn more from this IBM Redbook that introduces the concepts of DB2 with BLU Acceleration from ground up and describe the technologies that work hand-in-hand with BLU Acceleration: Architecting and Deploying IBM DB2 with BLU Acceleration in Your Analytical Environment.
  3.  Get the FACTS and stay current by subscribing to the ibmbluhub.com newsletter.

– IBM DB2 with BLU Acceleration is a revolutionary technology and delivers breakthrough performance improvements for analytic queries by using dynamic in-memory columnar technologies.

– Different from other vendor solutions, BLU Acceleration allows the unified computing of online transaction processing (OLTP) and analytics data inside a single database, therefore, removing barriers and accelerating results for users. With observed hundredfold improvement in query response time, BLU Acceleration provides a simple, fast, and easy-to-use solution for the needs of today’s organizations; quick access to business answers can be used to gain a competitive edge, lower costs, and more.

– Subscribe to the newsletter to continue learning about this hot in-memory database.  You will receive a periodic iNews email, which links to what’s new.  Just click and learn: http://www.ibmbluhub.com/blu-inews/

ToriBlog

If this information suits your needs, be sure to follow @IBM_DB2 on twitter. Get your information as it is being published.

Simplifying Oracle Database Migrations

Danny Arnold

Danny Arnold ,  Worldwide Competitive Enablement Team

As part of my role in IBM Information Management, as a technical advocate for our DB2 for LUW(Linux , Unix, Windows) product set, I often enter into discussions with clients that are currently using Oracle Database.

With the unique technologies delivered in the DB2 10 releases (10.1 and 10.5), such as

  • temporal tables to allow queries against data at a specific point-in-time,
  • row and column access control (RCAC) to provide granular row and column level security that extends the traditional RDBMS table privileges for additional data security, pureScale for near continuous availability database clusters,
  • database partitioning feature (DPF) for parallel query processing against large data sets (100s of TBs), and
  • the revolutionary new BLU Acceleration technology to allow analytic workloads to use column-organized tables to deliver performance orders of magnitude faster than conventional row-organized tables,

many clients like the capabilities and technology that DB2 for LUW provides.

However, a key concern is the level of effort to migrate an existing Oracle Database environment to DB2 .  Although DB2  provides Oracle compatibility and has had this capability built into the database engine since the DB2 9.7 release, there is still confusion on the part of clients as to what this Oracle compatibility means in terms of a migration effort.  Today, DB2 provides a native Oracle PL/SQL procedural language compiler, support for Oracle specific ANSII SQL language extensions, Oracle SQL functions, and Oracle specific data types (such as NUMBER and VARCHAR2).  This compatibility layer within DB2 allows many Oracle Database environments to be migrated to DB2 with minimal effort. Many stored procedures and application SQL that are used against Oracle Database can run unchanged against DB2 reducing both the migration effort and migration risk, as the application did not have to be modified. So the testing phase is much less effort than for a changed or heavily modified application SQL and stored procedures. Although the migration effort seems relatively straight forward, there are still questions that come up with clients and there is the need for a clear explanation of the Oracle Database to DB2 migration process.

Recently, a new solution brief entitled “Simplify your Oracle database migrations” published by IBM Data Management , provides a clear explanation of how DB2 and the PureData for Transactions appliance built upon DB2 pureScale can deliver a clustered database environment for migrating an Oracle database to DB2.  This brief provides a clear and concise overview of what an Oracle to DB2 migration requires and the assistance and tooling available from IBM to make a migration straightforward for a client’s environment.  The brief provides a concise description of the IBM tooling, IBM Database Conversion Workbench, which is available to assist a client in moving their tables, stored procedures, and data from Oracle to DB2.

The fact that DB2 for LUW makes migrating from Oracle a task that takes minimal effort, due to the Oracle compatibility built into DB2, is complemented by the PureData for Transactions system. PureData for Transactions provides an integrated, pre-built DB2 pureScale environment that allows a pureScale instance and a DB2 clustered database to be ready for use in a matter of hours. This helps simplify the implementation and configuration experience for the client. Combining the ease of Oracle migration to DB2 with the rapid implementation and configuration possible with PureData for Transactions, provides a winning combination for a client looking for a more cost effective and available alternative to the Oracle Database.

Fraud detection? Not so elementary, my dear.

Radha

Radha Gowda, Technical Marketing, IBM Analytics

Did you know that fraud and financial crime has been estimated at over $3.5 trillion annually1?  Identity theft alone cost Americans over $24 billion i.e. $10 billion more than all other property crimes2?  And, 70% of all companies have experienced some type of fraud3?

While monetary loss due to fraud is significant, the loss of reputation and trust can be even more devastating.  In fact, according to a 2011 study by Ponemon Institute, organizations lose an average of $332 million in brand value in the year following a data breach. Unfortunately, fraud continues to accelerate due to advances in technology, organizational silos, lower risks of getting caught, weak penalties, and economic conditions.  In this era of big data, fraud detection needs to go beyond traditional data sources i.e. not just transaction and application data, but also machine, social, and geospatial data for greater correlation and actionable insights. The only way you can sift through vast amount of structured and unstructured data and keep up with the evolving complexity of fraud is through smarter application of analytics to identify patterns,construct fraud models, and conduct real-time detection of fraudulent activity.

 IBM Watson Foundation portfolio for end-to-end big data and analytics needs

watson

While IBM has an impressive array of offerings addressing all your big data and analytical needs, our focus here is on how DB2 solutions can help you develop and test fraud models, score customers for fraud risk, and conduct rapid, near-real-time analytics to detect potential fraud.  You have the flexibility to choose the type of solution that best fits your needs – select software solutions to take advantage of your existing infrastructure or choose expert-integrated appliance-based solutions for simplified experience and fast time to value.

Highly available and scalable operational systems for reliable transaction data

DB2 for Linux, UNIX and Windows software is optimized to deliver industry-leading performance across multiple workloads – transactional, analytic and operational analytic – while lowering administration, storage, development, and server costs.  DB2 pureScale, with its cluster based, shared disk architecture, provides application transparent scalability beyond 100 nodes, helps achieve failover between two nodes in seconds, and offers business continuity with built-in disaster recovery over distances of a thousand kilometers.

IBM PureData System for Transactions, powered by DB2, is an expert integrated server, storage, network, and tools selected and tuned specifically for the demands of high-availability , high-throughput transactional processing—so you do not have to research, purchase, install, configure and tune the different pieces to work together. With its pre-configured topology and database patterns, you can set up high availability cluster instances and database nodes to meet your specific needs and deploy the same day rather than spend weeks or months. As your business grows, you can add new databases in minutes and manage the whole system using its intuitive system management console.

Analytics for fraud detection

 DB2 Warehouse Analytics  DB2 advanced editions offer capabilities such as online analytical processing (OLAP), continuous data ingest, data mining, and text analytics that are well-suited for real-time enterprise analytics and can help you extract structured information out of previously untapped business text.  Its business value in enabling fraud detection is immense.

IBM PureData System for Operational Analytics, powered by DB2, helps you deliver near-real-time insights with continuous data ingest and immediate data analysis.  It is reliable, scalable, and optimized to handle 1,000s of concurrent operational queries with outstanding performance. You can apply fraud models to identify suspicious transactions while they are in progress, not hours later. This can apply across any industry segment, including financial services, health care, insurance, retail, manufacturing, and government services.  PureData System for Operational Analytics helps with not just real-time fraud detection, but also cross-sell or up-sell offers/services identifying customer preferences, anticipating their behavior, and predicting the optimum offer/server in real-time.

DB2 with BLU Acceleration, available in advanced DB2 editions, uses advanced in-memory columnar technologies to help you analyze data and generate new insights in seconds instead of days.  It can provide performance improvements ranging from 10x to 25x and beyond, with some queries achieving 1,000 times improvement4,  for analytical queries with minimal tuning.  DB2 with BLU Acceleration is extremely simple to deploy and provides good out-of-the-box performance for analytic workloads. From a DBA’s perspective, you simply create table, load and go. There are no secondary objects, such as indexes or MQTs that need to be created to improve query performance.

DB2 with BLU Acceleration can handle terabytes of data to help you conduct customer scoring across your entire customer data set, develop and test fraud models that explore a full range of variables based on all available data.  Sometimes creating a fraud model may involve looking at 100s of terabytes of data, where IBM® PureData™ System for Analytics would fare better.  Once a fraud model is created, you can use DB2 with BLU Acceleration to apply fraud model to every transaction that comes in for speed of thought insight.

IBM Cognos® BI  DB2 advanced editions come with 5 user licenses for Cognos BI, which enable users to access and analyze the information consumers need to make the decisions that lead to better business outcomes.  Cognos BI with Dynamic Cubes, in-memory accelerator for dimensional analysis,enables high-speed interactive analysis and reporting over terabytes of data.  DB2 with BLU acceleration integrated with Cognos BI with Dynamic Cubes offers you a fast-on-fast performance for all your BI needs.

With the array of critical challenges facing financial institutions today, smarter are the ones that successfully protect their core asset – data. IBM data management solutions help you integrate information, generate new insights to detect and mitigate fraud. We invite you to explore and experience DB2 and the rest of Watson foundation offerings made with IBM.

Stay tuned for the second part of this blog that will explore the product features in detail.

1 ACFE 2012 report to the nations
2 BJS 2013 report on identity theft
3Kroll 2013/2014 global fraud report

4 Based on internal IBM tests of analytic workloads comparing queries accessing row-based tables on DB2 10.1 vs. columnar tables on DB2 10.5. Results not typical. Individual results will vary depending on individual workloads, configurations and conditions, including size and content of the table, and number of elements being queried from a given table.

Follow Radha on Twitter @radgo1

incldm

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!