02 9482 8200 info@datasync.com.au

IBM DB2

DB2 10.5 with BLU Accelerator

Announced April 3 2013

IBM® DB2® 10.5 with BLU Acceleration changes everything.

BLU Acceleration enables users to have much faster access to key information, leading to better decision-making.  The software extends the capabilities of traditional in-memory systems — which allows data to be loaded into Random Access Memory instead of hard disks for faster performance — by providing in-memory performance even when data sets exceed the size of the memory. During testing, some queries in a typical analytics workload were more than 1000 times faster when using the combined innovations of BLU Acceleration.1

Innovations in BLU Acceleration include “data skipping,” which allows the ability to skip over data that doesn’t need to be analyzed, such as duplicate information; the ability to analyze data in parallel across different processors; and greater ability to analyze data transparently to the application, without the need to develop a separate layer of data modeling. Another industry-first advance in BLU Acceleration is called “actionable compression,” where data no longer has to be decompressed to be analyzed.

DB2 10 offers the following exciting features:

  • Adaptive compression- an advanced row compression technique that uses two compression dictionary types (table-level and a new page-level dictionary) to improve compression ratios, especially when data changes.
  • Multi-temperature data management where the storage groups can be mapped to storage classes in a data warehouse, and you can assign table spaces to storage groups based on the “temperature” of the data that they contain.
  • SQL compatibility enhancements that make it easier to work with the DB2 product if you are more familiar with other relational database products.
  • Time Travel Query- ability to query data as it was at any point in the past or as it will be at some point in the future.
  • Continuous data ingest- a new high-speed ingest utility that streams data from files in various data formats or pipes into DB2 tables.
  • Improved XML support with extremely pureXML feature.
  • Deep data compression via Storage Optimisation Feature – save up to 80% of your storage space and reduce costs while improving database performance.
  • Workload Management – helps prevent, detect and resolve conflicting resource requirements on DB2 in order to avoid performance degradation
  • Query Optimisation Feature – MQT (Materialised Query Tables) and MDCs (Multidimensional Cluster Tables)
  • Advanced Access Control – minimise risk of unauthorised access via LBAC (Label Based Access Control) and RCAC (Row and column access control)
  • Table (Range) Partitioning and Database Partitioning Feature (DPF)
  • STMM – Self Tuning Memory Manager – memory resources are adapted dynamically and configuration parameters are automatically changed without DBA intervention
  • HADR – High Availability and Disaster Recovery – have minimised both planned and unplanned downtime
  • DB2 Data Replication, Federation access, log shipping
  • DB2 pureScale feature
  • Datasync and DB2
  • DB2 Support
  • DB2 Features
  • DB2 Editions

Contact Datasync for more information.

Datasync Consulting and DB2

Datasync has been working with DB2 for 20 years and our experienced consultants know DB2 better than anyone. From simple product installation to complex performance and tuning adjustments, our team is able to help you extract the maximum value from your DB2 software. Datasync can offer:

  • DB2 installations, upgrades and migrations
  • Solution architecture, database design and capacity planning
  • Implementation of High availability solutions including:
    • DB2 HADR – High Availability and Disaster Recovery
    • Log Shipping
    • Table Replication
    • xkoto GRIDSCALE – the “never stop” clustered database solution (Continuous Availability and Data Virtualisation)
  • DB2 Health Checks and Managed Services for a continuous healthy system
  • Performance and Tuning
  • Software Licensing: new licences and renewals

Contact Datasync for more information.

DB2 Support

With the announcement of the end of support dates, Datasync can help you in planning and executing a database upgrade.

With the announcement of end of support dates, Datasync can help you in planning and executing a database upgrade.

DB2 v8.1 and v8.2 End of Support Date: 30 April 2009

DB2 v9.1 End of Support Date: 30 April 2012

DB2 v9.5 End of Support Date: 30 April 2015

DB2 v9.7, v10.2, v10.5  End of Support Date: To be advised

Why should I upgrade?

  • Access to IBM Support for software defects and new releases
  • Recent DB2 versions offer a variety of new features, improving data management, system performance and high availability

Contact Datasync for more information.

DB2 Editions

Which DB2 edition is appropriate to my business needs?

DB2 offers a comprehensive option of editions to cater for small shops through to large organisations. Some features are not available in all editions, although the DB2 core database, functionalities, standards and interfaces are the same across editions as well as operating systems.

Datasync fully understands each DB2 edition, its features and how to correctly licence the software in order to offer you the most cost-effective solution.

Some editions have enforced hardware limitations (i.e.: maximum hardware processor capacity or maximum number of PVUs – Processor Value Units)

There are the following DB2 editions:

  • DB2 Express-C – the free community edition of DB2
  • DB2 Express – a powerful edition for small databases
  • DB2 Workgroup Server Edition – medium to large databases
  • DB2 Advanced Workgroup Server Edition – small OLTP and analytic deployments
  • DB2 Enterprise Server Edition – large to XL databases, all features included
  • DB2 Advanced Enterprise Server Edition – enterprise class OLTP and analytic deployments

To find out more about DB2 Editions and related Solutions:

Contact Datasync for more information.

IBM DB2 XML

DB2 pureXML is a revolution in the management of XML data.

DBAs will be fascinated by the sophisticated capabilities for storing, indexing, validating and querying XML data; with all functions fully integrated to the DB2 relational data engine and management features.

Application development involving XML data becomes easier and faster; database design does not require creation of large objects (CLOBs or BLOBs) to decompose (‘shredding’) large XML documents into tables. Moreover, application deployments benefit from the flexibility and extensibility offered by XML.

Developers and data administrators can use the language they are familiar with in order to retrieve data. DB2 and pureXML supports both traditional SQL and XQuery statements, or even a combination of both.

Refer to the IBM redbook for a comprehensive view of pureXML

Managers can be confident knowing that critical XML data can take advantage of the main DBMS features for security and data availability such as backup, restore and HADR.

Benefits of using DB2 pureXML

  • Lower development costsby reducing:
    • time spent on project preparation and setup
    • development time
    • number of lines of code
    • time and effort to deploy database changes
  • Application performance improvementsthrough:
    • improving agility, spending less time on managing workload
    • processing more information in shorter periods of time
    • reducing time to generate reports for analysis, allowing organisations to makde business decisions more quickly
  • Simplified operating environmentthrough:
    • reducing number of tables and columns requried to store XML information
  • Cost reduction with storage through:
    • using pureXML storage model for your XML data
    • combining it with DB2 data compression, which also compresses XML

Other relational extensions for XML in DB2 9.7

  • Store XML data in a single column
  • Extract elements from an XML document and store their contents in multiple columns of one or more tables (shredding)
    Store XML data type definitions (DTDs) for use in validating XML data.
  • Use of SQL/XML functions and mapping files to return results in XML format
  • Invoke system-supplied stored procedures to administer databases, generate XML documents, or “shred” XML documents into tables.
  • Invoke system-supplied functions to insert XML documents, retrieve XML documents, extract element content or attribute values, and update XML documents.

To find out more about IBM DB2pureXML;

Contact Datasync for more information.