New to DB2?

DB2 is IBM’s flagship relational database.

For over thirty years it has been optimised to deliver industry-leading performance across multiple workloads whilst lowering administration, development and server costs.

With new features being added in every release, DB2 remains at the forefront of database technology and supports the latest applications.

As the cornerstone of the IBM Hybrid Data Management Platform, DB2 offers leading performance, scale and reliability across on-premise, cloud and hybrid solutions running on platforms from a simple Docker container to the biggest enterprise-class server clusters.


Security

Advanced access control features allow permissions to be granted from the database level right down to individual rows and columns, with built-in auditing features to track who accesses the data.  Encryption ensures data is inaccessible to unauthorised users.

High Availability

From simple to set up and use warm standby servers using the High Availability Disaster Recovery (HADR) feature to active-active pureScale clusters with up to 128 nodes, DB2 keeps your data available and your business running through planned maintenance and unplanned server outages.

Multi Workload Scalability

DB2 scales up from modest requirements to the largest servers, and can also scale horizontally to support the biggest OLTP and OLAP workloads thanks to the pureScale and Database Partitioning Features.  Converged HTAP workloads are supported by advances in BLU columnar and in-memory database technology.  Response times across all workloads can be protected by the WLM workload management features to ensure every customer gets the best possible user experience.

Autonomics

Self-Tuning Memory Management (STMM) allows DB2 databases to adapt to their workload, ensuring consistently high performance as demands on the database change.  Automated storage management and maintenance policies allow DBAs to focus on high-value tasks rather than keeping the database running.

Compression

Reduce storage and server memory costs with highly effective compression of data and indexes, and benefit from reduced backup bandwidth and storage requirements by compressing backup and log files.

Application Development

Traditional development languages such as C++ and Java along with scripting languages such as Python, Perl, PHP and Ruby have been supported for many years and native plugins are available for popular IDEs such as Eclipse and Microsoft Visual Studio.  DB2 integrates easily into a DevOps pipeline using both commercial and open source tooling such as Docker, Jenkins and Puppet.

Compatibility

Porting applications from other databases such as Oracle, Sybase and MySQL to DB2 is made easier with the option to enable vendor-specific extensions to the SQL syntax.

Linux, UNIX and Windows editions of DB2 share a code base which ensures applications written for any edition can easily be moved to any other edition on any of these platforms, including cloud, allowing an application to scale from the smallest to the largest database platform with no code changes.

Integration

Bring together a disparate database estate without the cost of extracting the data as the federation features enable standard SQL in a DB2 database to query other data sources – both relational such as Oracle, SQL Server, MySQL and PostgreSQL and non-relational such as Hadoop and MongoDB.

DB2 Software Editions

Developer C

Free to download and use all features across all platforms, this edition of DB2 can be used for development, test and production systems.  Available as a full install or download a Docker image and be up and running in minutes.

Workgroup Server Edition

A scalable database solution designed for small to medium sized organisations looking to benefit from the flexibility and lower ownership costs of DB2.

Enterprise Server Edition

Aimed at large enterprise level customers and the most demanding online applications, this edition provides the scalability to handle any workload.

DB2 Direct Edition

A flexible solution aimed at customers who want to run workloads across a hybrid cloud or move databases between on-premise and cloud.

Standard editions of WSE, ESE and DB2 Direct now include features such as pureScale standby node, table partitioning and multi-dimensional clustering, encryption and federation to DB2 and Informix.  Choose the advanced editions to take advantage of high-end features including database partitioning, BLU Acceleration, compression, federation to non-IBM data sources and MQ based replication.

New to DB2 and not sure where to start?  Let Triton help with a POC. Contact us

Need assistance? Consultancy on Demand is the ideal solution for customers who need varying levels of consultancy during the year.

Inherited DB2 and need to support it? Sometimes organisations come across DB2 in their IT estate which they didn’t realise existed or that they hadn’t planned for.  RemoteDBA from Triton is a great insurance policy providing around the clock coverage and support for critical databases. Find out more.

 


Disclaimer:  The features listed may change over time. Please check with Triton before committing to any of the above.

Visit IBM for more details on DB2.