Upgrading your existing scripts that use DB2® command line processor (CLP) commands, DB2 system commands or SQL statements
involves managing the changes between DB2 Version 10.5 and previous releases related to SQL statements, DB2 CLP and system commands, SQL
Administrative views and routines, built-in functions, and catalog
views.
Before you begin
Restrictions
This
procedure only applies to scripts that use DB2 CLP commands, DB2 system
commands or SQL statements.
Procedure
To upgrade your scripts with DB2 CLP commands to DB2 Version 10.5:
- Run your scripts to detect any incompatibilities with DB2 Version 10.5. If your scripts run successfully, you do not need
to perform any additional steps. However, consider performing the
remaining steps to remove deprecated functionality in DB2 Version 10.5 before they become discontinued or to use new command
functionality.
- Remove the DB2 CLP
and system commands that display or update registry variables and
configuration parameters that are deprecated or discontinued:
- If your scripts perform snapshot or event monitoring, you
need to modify your scripts to remove references to discontinued monitor
elements or use a new name when they have been replaced by a new monitor
element.
- Determine the upgrade impact from system catalog changes. Using the changed
views and routines requires that you:
- Test your scripts to ensure that they run as expected using DB2 Version 10.5.
What to do next
After upgrading your scripts, perform
the remaining steps in the upgrading database
applications task.