Object Dependency Tracking In DB2 For i
July 21, 2015 Michael Sansoterra
The DB2 for i catalog tables and views present a plethora of valuable information about the various SQL objects defined on your system and their relationship to one another. In this tip, I discuss the dependency tracking views. If you ever wanted to make changes to one of your application’s primary SQL objects (such as a table, view or procedure) but feared the unknown (what related objects are affected?), then it’s time to investigate these special catalog views.
What Are The Dependency Catalog Views?
The “dependency” catalog views under consideration are:
SYSROUTINEDEP–Records the objects used by stored procedures and