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

You know how to send a message to the system operator message queue. Here’s some code you can use when you need that message to stand out.

Here’s the CL code.

dcl  &Message   *char 434
dcl  &Line1     *char  74  stg(*defined)  defvar(&Message   1)
dcl  &Line2     *char  72  stg(*defined)  defvar(&Message  75)
dcl  &Line3     *char  72  stg(*defined)  defvar(&Message 147)
dcl  &Line4     *char  72  stg(*defined)  defvar(&Message 219)
dcl  &Line5     *char  72  stg(*defined)  defvar(&Message 291)
dcl  &Line6     *char  72  stg(*defined)  defvar(&Message 363)

ChgVar &Line1 '  **************************************+
                 *********************************'
ChgVar &Line2 '*'
ChgVar &Line3 '*  Test message -- please ignore. '
ChgVar &Line4 '*  More important information'

I recently visited the site of a company that had a problem of increasing disk utilization. The staff had run all the GO DISKTASK reports and nothing seemed to be getting bigger. Unfortunately, there hasn’t been an easy way of finding who is using temporary storage. Displaying the amount of used temporary storage was so obscure that most System Administrators had no idea where to look. Let me show you how to see: (1) the amount of temporary storage that is being used; and (2) the jobs are using the most.

Temporary storage is mostly associated with jobs on your