DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
You should be aware of functionality that is deprecated or discontinued in DB2® Version 10.5 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 DB2 Version 10.5 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:
The db2IdentifyType1 command and the STATISTICS YES parameter of the LOAD command are discontinued. For more information, see DB2 command and SQL statement changes summary for details.
Review Upgrade impact from DB2 command changes to learn what commands are deprecated and discontinued in DB2 Version 10.5 and how to manage this impact on your database applications and routines.
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/newlogdirThe 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.