Upgrading your existing database
applications to DB2® Version 10.5 involves managing the changes between DB2 Version 10.5 and previous releases that impact these applications
and verifying that these applications function as expected. Managing
these changes might require that you modify your applications code
and rebuild your applications.
You only need to modify
your application code to manage changes in DB2 Version 10.5 that impact your applications, to remove the use of
deprecated or discontinued functionality in DB2 Version 10.5, or to use new functionality.
Before you begin
Restrictions
This
procedure only applies to database applications programmed in C, C++,
COBOL, FORTRAN, Java™, Perl,
PHP, REXX,
and .NET languages.
Procedure
To upgrade your database applications to DB2 Version 10.5:
- If you identified changed DB2 commands, changed SQL statements, and changed system catalog views and built-in functions that
impact your applications, edit your application code or scripts to
modify:
- DB2 CLP and system command
syntax
- SQL statements syntax
- SQL statements using catalog views and SQL Administrative views
and routines
- SQL statements using target tables for write-to-table event monitors
- User defined routine names that are not fully qualified with a
schema name
- DB2 API calls
- Application programming interface calls such as JDBC, ODBC and
CLI
- If your applications or scripts read from the command output,
modify them to read the changed output format.
- If you identified changes specific to the development environment that
impact your applications, modify them to support these changes. Upgrade
your:
- Rebuild all changed database applications programmed in
C/C++, COBOL, FORTRAN, and REXX, using the appropriate DB2 build file and specifying the appropriate DB2 shared library path.
- Test your database applications to verify your changes
and to ensure that they run as expected using DB2 Version 10.5.
What to do next
After upgrading your database applications,
perform the recommended post-upgrade tasks
for database applications to ensure that your upgrade was successful.