DB2 V9.1 New Feature

What’s new for Version 9.1

Highlights of Version 9.1 summary

Application development enhancements

Application development enhancements summary

l         BINARY, VARBINARY, and DECFLOAT data type support in .NET and CLI client applications

l         Client support for trusted connections to DB2 for z/OS databases

l         Command line processor (CLP) 64 KB limit for SQL statements has been removed

l         DB2 .NET Data Provider enhancements and support for the .NET Framework 2.0

l         Developer Workbench replaces the Development Center

l         External table function support across database partitions

l         IBM Database Add-Ins for Microsoft Visual Studio 2005 enhancements

l         Java routine class loader enhancements

l         JDBC and SQLJ enhancements

l         New and changed development software support

l         TRIM and STRIP scalar functions added                              

 

 

 

More agile application development, using an enhanced set of application development tools:

l         Application development tools and support for the new native XML data store feature, which enable applications to access and store both XML and relational data.

l         An enhanced DB2 Driver for JDBC and SQLJ that complies with JDBC 3.0 specifications and includes support for SQLJ statements that perform functions equivalent to most JDBC methods. Other key features include support for many new data types, new DB2-only methods to support trusted connections to DB2 Version 9.1 for z/OS® (DB2 for z/OS) data servers, and heterogeneous pooling and connection reuse.

l         The DB2 Developer Workbench, which is a comprehensive development environment for creating, editing, debugging, testing, and deploying DB2 stored procedures and user-defined functions. You can also use Developer Workbench to develop SQLJ applications and to create, edit, and run SQL statements and XML queries.

l         Additional support for Visual Studio 2005, which includes support for Web services, full support for the native XML data store, and the ability to build applications and Web sites without writing code.

l         An enhanced DB2 Runtime Client which includes 64-bit support, coexistence with other DB2 products on the same computer, and free-distribution licensing with applications that you sell to other companies.

                                       

New automated database administration features that improve productivity:

l         Adaptive, self-tuning memory allocation, which helps reduce or eliminate the task of configuring your DB2 server by continuously updating configuration parameters, resizing buffer pools and dynamically determining the total amount of memory to be used by the database.

l         Automated health monitoring for DB2 UDB for z/OS objects, which allows you to automate object maintenance policy evaluations for DB2 UDB for z/OS objects through the Control Center’s Create and Change Object Policy wizard.

l         Automatic storage support, which automatically grows the size of your database across disk and file systems, is now available for multi-partition databases.

l         Automated statistics collection, which is enabled by default when you create a new database.

l         Automatic configuration of prefetchers and page cleaners based on DB2 database system environment characteristics.

l         New policy options for automated table and index reorganization, which provide your database administrator with more capabilities for managing table and index reorganizations.

l         Improved large database management, using table partitioning

 

 

What’s changed from Version 8.2

 

Changes in existing functionality

Changes in existing functionality summary

Installation, migration, and fix pack changes Installation, migration, and fix pack changes summary

l         Application and routine migration changes

l         db2_deinstall command parameter changes (Linux and UNIX)

l         DB2 install images package format changes (Linux and UNIX)

l         Documentation updates are available between product releases

l         Installation CD changes for national language versions of DB2 products (Linux and UNIX)

l         Licensing support changes

l         Locally installed Information Center installation restrictions

l         Migration support changes during installation (Windows)

l         Migration support changes for DB2 database systems

l         Multiple CD installation now required for some products (Linux and UNIX)

Database setup changes

Database setup changes summary

l         Authority required to start the database manager has changed (Windows)

l         Automatic configuration of prefetchers and page cleaners enabled by default

l         Automatic self-tuning memory enabled by default during database creation

l         Automatic statistics collection enabled by default during database creation

l         Automatic storage enabled by default during database creation

l         Configuration Advisor enabled by default during database creation

l         Configuration parameters default value changes

l         Databases require additional space

l         database_memory configuration parameter change                                                          

l         Increased log, table space, and memory requirements due to larger record identifiers (RIDs)

l         Lock lists require additional space

l         Registry and environment variables default value changes

32-bit DB2 database instance support changes

External routine support changes                

l         Limited support for 32-bit external routines created in DB2 UDB Version 8 to continue working in DB2 Version 9

l         32-bit routines defined using the NOT FENCED clause created in DB2 UDB Version 8 will no longer work on 64-bit DB2 Version 9 database servers in AIX, HP, SUN, Linux for AMD64 and Intel EM64T, Linux on POWER, Linux on zSeries environments

l         Updated sample build scripts are available for building new routine　

Administration changes

Administration changes summary

l         Application ID format changed

l         Backup image naming convention has changed (Windows)

l         Catalog table changes in support of table partitioning

l         Collating sequence IDENTITY replaces BINARY in command output

l         Data movement utilities changes

l         db2mtrk command changes (Windows)

l         DMS table space type default value changed to LARGE

l         Handling of new database connections has changed

l         Load from cursor incompatibilities with previous releases

l         Location of diagnostic messages for automatic maintenance                                            

l         New DB2 agents may affect MAX_CONNECTIONS configuration and application monitor output

l         REORGCHK command output changes

l         ROLLFORWARD DATABASE output has changed

l         SET SESSION AUTHORIZATION requires SETSESSIONUSER privilege

l         sheapthres_shr parameter change

l         Table space-level point-in-time rollforward operations restrictions

l         TSM management class no longer used for filtering when restoring or retrieving logs

l         Write-to-table event monitor changes

Application development changes

Application development changes summary

Application and routine feature support changes

Client application connection support changes

n         Client applications using DB2 Version 6 or Version 7 client instances cannot connect to DB2 Version 9 database server

Client application environment variable changes

n         There are new environment variable values

External routine support changes

n         32-bit unfenced routines (stored procedures and user-defined functions) created in DB2 Universal Database Version 8 will no longer work on 64-bit DB2 database servers in the AIX, HP, SUN, Linux on POWER, Linux for AMD64 and Intel EM64T, and Linux on zSeries environments. Migrating these routines to DB2 Version 9 requires that you rebuild them on the target 64-bit database server.

SQL procedure support changes

n         SQL procedures that you created for 32-bit instances of DB2 Universal Database Version 8 prior to V8.2 (V8.1 FP7) will not run on 64-bit instances of DB2 Version 9. To successfully migrate these SQL procedures to DB2 Version 9, you must drop and recreate the SQL procedures using the target 64-bit database server.

n         SQL procedures created for 32-bit instances of DB2 Universal Database Version 7 or Version 8 with any FixPak will continue to work on the supported 32-bit instances of DB2 Version 9. However, it is recommended that such procedures be recreated to take advantage of significant performance improvements introduced in later releases of DB2.

JVM support changes

n         Only a 64-bit JVM is provided with 64-bit DB2 database servers.

n         A 32-bit JVM is provided only for the Linux x86 and Windows on x86 operating systems

n         Java external routines require a 32-bit JVM for 32-bit DB2 database servers and a 64-bit JVM for 64-bit DB2 database servers.

 

l         Changed parameters and output for the db2batch command

l         Cursor blocking is disabled in SQL procedures

l         DB2 Embedded Application Server updated

l         IBM Software Development Kit (SDK) for Java 5.x support added (AIX, Linux, and Windows)

l         Removal of mutating table conflicts when calling procedures from triggers

l         Reverse scans enabled by default for indexes, primary keys and unique keys

l         Sample build scripts updated

Deprecated functionality

Deprecated functionality summary

l         Check pending table state is replaced and iCheckPending parameter is deprecated

l         CLISchema CLI keyword no longer supported

l         COLNAMES column in SYSCAT.INDEXES is deprecated

l         db2ilist command options are deprecated (Linux and UNIX)

l         DB2LINUXAIO registry variable is deprecated

l         db2secv82 command is deprecated

l         External routines now require an explicit entry point specification

l         Database logging using raw devices is deprecated

l         Some SQL administrative routines have been replaced                                                     

l         ADD PARTITIONING KEY clause of the ALTER TABLE statement is deprecated

l         DROP PARTITIONING KEY clause of the ALTER TABLE statement is deprecated

l         Type 1 indexes are deprecated                                         

l         DB2 JDBC Type 2 driver is deprecated

l         The -w option of the db2icrt, db2ilist, and db2iupdt commands is ignored

Discontinued functionality

Discontinued functionality summary

l         Alternate FixPak images are discontinued (UNIX)

l         Autoloader utility (db2atld) is no longer supported

l         Audio, Image, and Video (AIV) Extenders are no longer supported

l         Data Links Manager no longer supported

l         The Data Warehouse Center and the Information Catalog Center are no longer included

l         db2reg2large utility for converting DMS table space size is discontinued

l         db2profc and db2profp utilities are discontinued

l         DB2_SCATTERED_IO registry variable is discontinued (Linux)

l         Desktop icon and folder making utilities are no longer supported (Linux)

l         Extended Storage option for buffer pools is discontinued

l         Fast communications manager (FCM) no longer uses virtual interface (VI) architecture

l         NetBIOS and SNA communication protocols are no longer supported

l         DB2 Administration Tools are no longer supported on some platforms

l         In previous releases, the DB2 Administration Tools—for example, the Control Center— were supported on all platforms. In Version 9.1, the DB2 Administration Tools are supported only on the Windows x86, Windows x64 (for AMD64 and Intel EM64T), 32-bit Linux x86, and Linux for AMD64 and Intel EM64T operating systems.

l         Text Extender is no longer supported

l         Type 3 JDBC support is discontinued

l         Vendor load API (sqluvtld) is discontinued

l         VSE and VM objects are no longer supported in the DB2 Control Center