DB2 Version 10.1 for Linux, UNIX, and Windows

Deprecated or discontinued functionality that affects DB2 server upgrades

You should be aware of functionality that is deprecated or discontinued in Version 10.1 that can affect the upgrade of your DB2® server. Also, you should be aware of the DB2 products that are no longer supported because upgrade from these products to Version 10.1 is unsupported.

To deal with these functionality changes, you must perform additional tasks before or after upgrade. The following list describes changes that are not included in the pre-upgrade and post-upgrade tasks for DB2 servers:

DB2 JDBC Type 2 driver has been discontinued.
The DB2 JDBC Type 2 driver for Linux, UNIX, and Windows has been discontinued and it is no longer available. You should use the IBM® Data Server Driver for JDBC and SQLJ instead. For more details, see DB2 JDBC Type 2 driver has been discontinued.
Control Center tools have been discontinued

The Control Center tools have been discontinued in Version 10.1. See Control Center tools have been discontinued for a completed list of the tools that have been discontinued.

Start using IBM Data Studio and IBM Optim™ tools. For a mapping between these recommended tools and Control Center tools, see Table of recommended tools versus Control Center tools.

Deprecated or discontinued commands

Review Upgrade impact from DB2 command changes to learn what commands are deprecated and discontinued in Version 10.1 and how to manage this impact on your database applications and routines.

Raw logs

The use of raw devices for database logging has been deprecated since DB2 Version 9.1 and will be removed in a future release. You should use a file system instead of a raw device. Using a file system with non-buffered I/O capabilities enabled, such as Concurrent I/O (CIO) or Direct I/O (DIO), can give you performance comparable to that of using raw devices. The following example illustrates how to change the newlogpath parameter setting to a file system directory:

  db2 UPDATE DATABASE CONFIGURATION USING newlogpath /disk2/newlogdir

The new setting does not become effective until the database is in a consistent state and all users are disconnected from the database. The database manager moves the logs to the new location after the first user connects to the database.

DB2 Products

The Net Search Extender (NSE) has been deprecated and might be discontinued in a future release. See Net Search Extender has been deprecated for details on how to start using equivalent features or commands.

For NSE environments with comparative small workloads, if you are not using these deprecated features or commands, consider migrating to DB2 Text Search to take advantage of functionality not supported in NSE such as linguistic processing in all supported languages and search improvements on XML documents. See Migration to DB2 Text Search for details.

Query Patroller is discontinued. See http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.qb.upgrade.doc/doc/t0053461.html for details on how to migrate.

'Functionality that was deprecated or discontinued in DB2 Version 9.7
If you are upgrading from DB2 Version 9.5 you must also review the changes made in DB2 Version 9.7 that might impact your environment after ugprading to Version 10.1. Review the following topic to learn about additional possible impacts on the upgrade of your DB2 server: