• IBM Consulting

    DBA Consulting can help you with IBM BI and Web related work. Also IBM Linux is our portfolio.

  • Oracle Consulting

    For Oracle related consulting and Database work and support and Migration call DBA Consulting.

  • Novell/RedHat Consulting

    For all Novell Suse Linux and SAP on Suse Linux questions releated to OS and BI solutions. And offcourse also for the great RedHat products like RedHat Enterprise Server and JBoss middelware and BI on RedHat.

  • Microsoft Consulting

    For Microsoft Server 2012 onwards, Microsoft Client Windows 7 and higher, Microsoft Cloud Services (Azure,Office 365, etc.) related consulting services.

  • Citrix Consulting

    Citrix VDI in a box, Desktop Vertualizations and Citrix Netscaler security.

  • Web Development

    Web Development (Static Websites, CMS Websites (Drupal 7/8, WordPress, Joomla, Responsive Websites and Adaptive Websites).

25 November 2013

DB2 11 is here





DB2 11: The Database for Critical Transactions & Analytics


Speed, Simplicity, Savings


DB2 11 for z/OS delivers new innovations: Save money, save time, reduce cost Enhanced continuous availability, scalability, and security for business-critical information Sophisticated Critical business analytics Simpler, faster migration for faster ROI Deep integration between DB2 and System z

IBM DB2 11 overview video:





 So what’s new in DB2 11 that is causing so much excitement? Here is a quick summary of some of the exciting new features and business benefits of DB2 11, about which this book will give you deeper insight:



• Even more out-of-the-box CPU savings


    10 percent complex OLTP

    10 percent update intensive batch

    40 percent queries

    25 percent uncompressed tables and 40% compressed tables



• Enhanced resiliency


    Fewer planned outages, fewer REORGs, faster recovery

    Cost-effective archiving, access warm/cold data in single query

    Business-critical analytics

    DB2 Analytics Accelerator performance enhancements

    Big data integration

    In-transaction real-time scoring

    Advanced QMF analytic capabilities with mobile support



• Simpler, faster upgrades for faster ROI


    6x faster catalog migration

    Protection from incompatible changes

    Repeatable testing with real workloads and integrated cloning



Big Data, IBM DB2 Accelerators:


Join Dan Wardman, VP of Information Management Mainframe Software, as he discusses Big Data and System z and explains why zEnterprise systems are a key data source for Big Data and Business Critical Analytics.

Big data can address a multitude of problems if you know how to use it. The insights gleaned from big data can help organizations deepen customer engagement, optimize operations, prevent threats and fraud, and capitalize on new sources of revenue. But to be successful, you need a clear understanding of the characteristics of big data and the skills required to manage it.





IBM Business Analytics and Optimization






Delivers extremely fast query results for critical business insight


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



DB2 Analytics Accelerator for z/OS helps you:



  •     Query data at high speeds—to significantly improve response times for unpredictable, complex and long-running query workloads.
  •     Extend the capabilities of DB2 for z/OS—to support a cost-effective analytics solution for data warehousing, business intelligence and predictive analytics.
  •     Lower operating costs—by reducing System z disk requirements and offloading query workloads to a high-performance platform.


Offers improved, broader analytics queries with latest release


IBM® DB2® Analytics Accelerator for z/OS delivers new features to support a broader set of applications and provide acceleration capabilities for most DB2 for z/OS customers. The software includes enhancements to support more data, queries, systems and applications, which can offer greater business benefits and cost savings.

The latest version of DB2 Analytics Accelerator for z/OS provides these features and benefits:


  •     Accelerates a broader spectrum of queries with support for Static SQL, multiple-row FETCH and multiple encodings on the same accelerator.
  •     More robust and scalable for the enterprise through enhanced workload balancing, improved incremental update performance and improved monitoring.
  •     Storage saver performance improvements including built-in restore, better access control for archived partitions and protection of moved partitions.
  •     Supports DB2 11 and PureData Analytics N2001 hardware.



DB2 10.5 with BLU Acceleration:





Accelerating Analytics with BLU:





IBM DB2 10.5 Optimized for SAP Software:






IBM DB2 Analytics Accelerator or IDAA


DB2 for z/OS has a new cool feature: the IBM DB2 Analytics Accelerator or IDAA. The IDAA is a marriage of DB2 for z/OS and Netezza technology to accelerate complex queries in a highly secure and available environment. This 60 minute video will explain what it is exactly, how it works and why you would want such an accelerator. Click on the link below to start the presentation (opens new window). Enjoy! - See more at: http://www.db2-symposium.com/articles/category/the-wall/#sthash.Gz1T3zjm.dpuf

How IDAA Accelerators work and Why would want IBM IDAA Accelerators


Look at this article to get a quick introduction into DB2 UDB trace facility:

DB2 Basics: An introduction to the DB2 UDB trace facility


More information on what's new in DB2 11 can be found here:

DB2 11: The Database for Critical Transactions & Analytics

DB2 Information Management Tools and DB2 11 for z/OS Compatibility

from IBM Champion Craig Mullins

from Robert Catterall

from Willie Favero

IBM Data Management on TUMBLR

Flashbook: DB2 11 for z/OS - The Database for Big Data and Analytics

DBI Smarter Tools for Smarter People

DB2 10.5 with BLU Acceleration New Dynamic In-Memory Analytics for the Era of Big Data

SQL Tips for DB2 LUW by Serge Rielau (瑞赛奇) and Rick Swagerman

Discover DB2 for yourself



For more information please contact me at:


Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 

20 November 2013

Oracle Database 12c Migration Overview and how to reduce risk

Oracle Database 12c Architecture Overview


Oracle Database 12c Multitenant Architecture Overview


Oracle Database Upgrade
Upgrading to Oracle Database 12c provides the latest in efficient, reliable, secure data management for mission-critical on-line transaction processing applications, query-intensive data warehouses, and cloud applications. The right planning, preparation, and upgrade steps will make the upgrade process simpler, faster, and more predictable from start to finish.  
White Paper: Upgrading to Oracle Database 12c
This white paper outlines the methods and alternatives available for you to upgrade and migrate your database to Oracle Database 12c.  Learn about different use cases and key factors to consider when choosing the method that best fits your requirements.

Upgrade Compatibility Matrix
Wondering which versions are supported for direct upgrade to Oracle Database 12c? Here is the support note with that information.

Mike Dietrich's Upgrade Blog
Database Upgrade Team member Mike Dietrich maintains a BLOG relating to Database Upgrade presentation, events and topics.

Upgrade and Migration to Oracle Database 12c - Workshop Presentation   
This presentation covers a full day database upgrade and migration workshop with plenty of background information from installation and patching to various upgrade and migration techniques covering also fallback strategies, performance managements and application upgrades.

Manual Upgrades
This document provides a checklist to review prior to performing a manual Upgrade.

DBUA Upgrades
If you plan on using the Database Upgrade Assistant to perform your upgrade, this document provides a check-list you should review first.

Upgrade Migrate & Consolidate to Oracle Database 12c


Different Ways to Upgrade, Migrate & Consolidate with Oracle Database 12c

Oracle Database 12c : What's new in Database Upgrade?

Oracle Database 11g Release 2 information
 Much of this information applies to Oracle Database 12c as well, but the white papers and documents below were produced for Oracle Database 11g Release 2.
Upgrade Methods
Get an overview of various Upgrade Methods that may be used to upgrade to Oracle Database 11g Release 2.

Best Practices
Review Oracle's Best Practices for upgrading your Oracle Database.

Customer Migration: Fujitsu SPARC Enterprise
Read about using Oracle Real Application Testing as part of a database migration from Oracle9i Database to Oracle Database 11g.

Oracle Database 11g Customer Upgrade
A paper discussing a customer Upgrade project taking their installed base from Oracle 9i to Oracle Database 11g. The paper covers planning through execution

Minimal Downtime Upgrade using Oracle GoldenGate
The Oracle Grid Center is a joint effort between Oracle and Fujitsu to provide solutions that deliver safety and security to clients, including system construction, joint verification, and post-installation support. This white paper discusses procedures for upgrading Oracle Database using Oracle GoldenGate, Oracle’s real-time data integration software, as well as the results of such upgrades.

Downgrade Methods
A white paper describing the available methods for downgrading to an earlier release of Oracle Database.

Oracle Database 11.2 Upgrade Methods


Partner Webcast -- Oracle Database 12c: Reducing Upgrade Risk - 26/09/2013 (Part 1of2)
Oracle Database 12c includes exciting new features such as the Oracle Multitenant option, Oracle Active Data Guard Far Sync, information lifecycle management enhancements and new data types just to name a few.

Anyone wishing to take advantage of these and other new features will need to upgrade their existing databases to the latest Oracle Database 12c. Upgrading the database is a task that Database Administrators plan for, ahead of time, with great caution. This is because of the risk involved in upgrading a production system. This risk can be summarized in the following question:
How will the application(s) hosted by the database behave next to the upgrade?


Partner Webcast -- Oracle Database 12c: Reducing Upgrade Risk - 26/09/2013 (Part 2of2)
Oracle Database 12c includes exciting new features. Anyone wishing to take advantage of these and other new features will need to upgrade their existing databases to the latest Oracle Database 12c. Upgrading the database is a task that Database Administrators plan for, ahead of time, with great caution. This is because of the risk involved in upgrading a production system. This risk can be summarized in the following question:
How will the application(s) hosted by the database behave next to the upgrade?

This covers performance, but also functionality. Upgrading to Oracle Database 12c provides the latest in efficient, reliable, secure data management for mission-critical on-line transaction processing applications, query-intensive data warehouses, and content management and Web2.0 applications. The right planning, preparation, and upgrade steps will make the upgrade process simpler, faster, and more predictable from start to finish.




Complete Lifecycle Management of Pluggable Databases (aka Multitenant Option)





All Migration slides from Oracle ISV Migration Center: