IBM Data Management magazine Issue 2, 2009

SQL compatibility
features make DB2 9. 7 for
Linux, UNIX, and Windows
easier for application
developers to adopt.

t take over a database. DBAs can use the same technology to increase the priority of certain workloads at key thresholds, such as time, to make sure important queries that must meet service-level agreements get resource priority.

The new version of DB2 9. 7 for LUW also makes it easy o manage mixed workloads on your system, such as a high-volume transactional system with reporting or a BI system with occasional trickle feeds. A newly added “currently committed” locking syntax eliminates the conflict between

Figure 1: The PL/SQL compilation process with IBM DB2 9. 7 for Linux, UNIX, and Windows has three basic steps.

PL/SQL code

The process begins with existing or new PL/SQL code.

DB2 Unified
Runtime
Engine

Console output

PL/SQL is compiled to machine code for the DB2 Unified Runtime Engine to execute.

Results from the compiled PL/SQL requests are sent back to the console.

ti read and write workloads so the database can deliver a true point-in-time response.

In addition to new features for managing database me, DB2 9. 7 also helps administrators minimize downtime by making it possible to move database schemas without taking the system down. Changing tables—even changing column type—can be done with no downtime, as can moving a table from one table space to another. In fact, you can transfer an entire schema, including all the tables and associated objects, from development to QA to performance-testing and incur no downtime.

DB2 9.7: Simplifying life for both DBAs and developers

With advances in compression, development, administration, virtualization support, and development, DB2 9. 7 is poised to help database managers use server and storage resources more efficiently, automate workload management, and simplify application development. Application developers and ISVs familiar with the Oracle DBMS can more rapidly get applications and tools running on DB2 with new PL/SQL support and flexible concurrency model and data-typing technology (see Figure 1). The new DB2 9. 7 release also offers organizations more options in security management and high availability.