IBM DB2 is a relational DBMS that natively supports a number of NoSQL capabilities , including XML, Graph Store, and Java Script Object Notation (JSON). Used by companies of all sizes, DB2 provides a data platform for transactional and analytic operations. By ensuring the continued availability of data, it ensures the efficiency of transactional workflows and analytics.
Operating systems supported by DB2
DB2 is available for three main platforms:
workstations with DB2 for LUW (Linux, Unix and Windows);
the mid-range with DB2 for iSeries;
the mainframe with DB2 for z / OS, the mainframe relational DBMS that dominates the market.
DB2 supports the following Unix variants: AIX, Solaris, and HP-UX; Linux variants include Red Hat, SUSE, Ubuntu, and Linux on pSeries and System z.
“DB2 for i” is preinstalled on the iSeries server, so we will not process it here.
The current version of DB2 for LUW is 10.5, released in the second quarter of 2013. Its great novelty, the BLU Acceleration component , enhances DB2 with a basic functionality in columns.
To that, IBM has added three features and improvements. The first, the actionable compressed data (actionable compression), significantly reduces the storage space required. This compression is said to be exploitable because the new algorithms make it possible to evaluate the predicates without decompressing the data and the values with the highest occurrence are compressed the most.
The second innovation that BLU Acceleration brings is the use of SIMD (Single Instruction Multiple Data) capabilities of modern UCs. Overall, the concept of HMIS is that a single instruction can act on several elements in parallel, which obviously shortens the duration of treatment.
Finally, BLU Acceleration adds data jump technology. To summarize, it is a question of ignoring the data useless to the resolution of the request. Metadata is associated with recordsets. DB2 accesses it and determines if there is something of interest in that dataset. If this is not the case, this data is ignored.
DB2 for LUW 10.5 also provides native encryption capabilities and enhancements for PureData, the IBM database appliance.
Currently, the current release of DB2 for z / OS is 11, released in October 2013. Other strengths of DB2 11 for z / OS include enhanced performance and availability, improved analytics, application compatibility features , better stability of the access path and greater transparency of the archives.
IBM also offers the IBM DB2 Analytics Accelerator, a component that, added to DB2 for z / OS, speeds up analytic queries.
DB2 for LUW requires two configuration files: one for the database manager , which contains the configuration parameters for a complete instance, and the database configuration files for each database .
DB2 for LUW is pre- integrated with the IBM PureData Database Appliance – getting rid of the tedious tasks of installing and configuring a typical DBMS installation, you get a turnkey implementation of DB2.
DB2 for z / OS is installed as a subsystem whose components are responsible for database services, lock management, distributed query processing, and connection to other mainframe agents. The subsystem is configured with a parameter set called DSNZPARM.
IBM offers six editions of DB2 for LUW.
DB2 Advanced Enterprise Server Edition offers the widest range of features available for DB2. It is suitable for transactional, data warehouse and mixed workloads. This edition does not impose a limit on processors, memory, or database size. It comes with a complete set of complementary warehousing tools, InfoSphere Optim and IBM Data Studio.
DB2 Advanced Workgroup Server Edition is comparable to DB2 Advanced Enterprise Server Edition but is subject to processor, memory, and database size restrictions. This edition is best suited for deploying to a department, workgroup, or medium business.
DB2 Enterprise Server Edition is suitable for transactional and mixed workloads. Like the advanced version, it is not subject to any CPU, memory, or database size limit. However, unlike the advanced version, it does not include column- based, in-memory database, data compression, workload management, replication, or distributed partitioning features. .
DB2 Workgroup Server Edition is used primarily for transactional workloads. This edition places limits on the number of processors, memory, and database size. It is ideal for medium workloads.
DB2 Express Server Edition is a DB2 data server with full functionality. Sold at an entry-level price, it is intended for the SME market.
DB2 Developer Edition is designed to enable an application developer to design, build, and prototype applications for deployment on any IBM Information Management server or client platform.
In addition, IBM also offers a free entry-level edition of the DB2 data server, DB2 Express-C , for the developer and partner community. It can be installed on physical or virtual systems, regardless of the number of CPUs and the amount of memory. This edition is optimized to use at most two cores and 16 GB of memory.
DB2 data types
DB2 supports standard numeric, character, and date / time datatypes, and XML types, either user-defined or industry-defined. The support JSON is ensured through DB2 JSON, a pilot-based solution which provides a JSON data representation in the context of an RDBMS.
DB2 performance evaluation
IBM has released numerous TPC DB2 performance assessments for all supported platforms.
IBM sells DB2 for LUW directly, via business partners or online. IBM also offers special application licensing programs that allow vendors like SAP to license and sell the DB2 relational DBMS with its own applications.
The rates are based on the Process Value Unit (PVU) , a unit of measurement that IBM uses to sell software licenses. IBM assigns a number of PVUs to each processor core. The price is then calculated based on the number of PVUs for the processor and the number of processors available to DB2.
The license of the edition of the developers is granted by authorized user, it does not depend on the unit VPU.