Category: Upgrade

file0001696162701 1

DB2 Upgrade Detail: Upgrading Explain Tables

Explain tables change in structure from version to version of DB2. If you want to continue to use the same set of explain tables across a DB2 upgrade, you must take special action to upgrade them. Explain Tables Explain tables are used when generating a human-readable version of the access plan for a query. They may be implicitly created by...


Binding DB2 Base Packages for Various Versions

When connecting between different versions of DB2, you generally need to bind packages from the different versions against the DB2 database. Just because you’ve bound db2ubind and db2cli on the server does not mean that all possible clients connecting in are covered. Sometimes binds happen implicitly, but sometimes they don’t. And you don’t necessarily want to grant a user rights...