After upgrading to Version 10.5,
enhance the functionality and improve the performance of your database
applications by adopting new Version 10.5 functionality.
Before you begin
You must upgrade your DB2® server
to Version 10.5.
Procedure
For applications that access upgraded databases, perform
any of the following steps to adopt the specified Version 10.5 functionality:
- Enable the batch CALL statement support in CLI applications
to optimize network flow by specifying an array size with the SQL_ATTR_PARAMSET_SIZE
statement attribute and provide argument data in form of an array.
For more details, see Calling stored procedures from CLI
applications.
- Use NOT ENFORCED primary key and unique constraints to
avoid performance costs during insert, update, and delete operations
on a table and space requirements that are associated with enforcing
a unique constraint when it is known that the data already conforms
to the unique constraint. It also provides the same potential performance
benefits for queries. Fore more details, see Informational constraints.
What to do next
If you upgraded from DB2 Version
9.7,
adopt functionality introduced in DB2 Version
9.7 in
your database applications and routines. See Adopting new DB2 Version
9.7 functionality in database applications and routines in
the Upgrading to DB2 Version
9.7 guide for details.