Troubleshooting
Problem
Warning DBT5534W during db2ckupgrade command
Cause
Dependency of database objects on discontinued routine
Resolving The Problem
Sometime due to dependency of database objects on discontinued routine, db2ckupgrade command returns warning DBT5534W.
For example -
DBT5534W The db2ckupgrade command found a database object which has a dependency on system built-in routines that are discontinued. Object name: "DB2INST1.DB2$MON_TBS_CFG". Object type: "VIEW". Discontinued routine upon which the object depends: "SYSPROC.SNAPSHOT_TBS_CFG".
Here SYSPROC.SNAPSHOT_TBS_CFG is the system built-in routines which is discontinued
DB2INST1.DB2$MON_TBS_CFG is an object which has a dependency
VIEW is the object type.
Mostly the dependent objects are user defined. Such objects can either be dropped or altered to use other routines and tested. You should also ascertain the use of such objects in code and database before dropping/altering. If there is no reference of the object in code and database it can be dropped.
You may like to retain its DDL before dropping/altering, it can be done using db2look.
If the object is a package check for dependency:
select pkgschema, pkgname, btype, bschema, bname from SYSCAT.PACKAGEDEP where pkgname='<pkg name>'
If the object is a routine check for dependency via technote How to determine what database objects a SQL routine is dependent on from the Related URL section.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21982817