DB2 Version 9.7 for Linux, UNIX, and Windows

Monitoring storage paths

A database snapshot includes the list of storage paths associated with the database.

If the number of automatic storage paths is 0, automatic storage is not enabled for the database:

    Number of automatic storage paths  = ##
    Automatic storage path             = <1st path>
    Automatic storage path             = <2nd path>
    ...

If the buffer pool monitor switch is on, the following elements are also set:

    File system ID                     = 12345
    File system free space (bytes)     = 20000000000
    File system used space (bytes)     = 40000000000000
    File system total space (bytes)    = 40020000000000

This data is set on a per path basis: on a single database partition system per path, and per each database partition on a multi-database partitioned environment.

In addition, the following information is set within a table space snapshot. The information indicates whether or not the table space was created as an automatic storage table space:

    Using automatic storage            = Yes or No