SNAPSTORAGE_PATHS administrative view

esta funcion regresa los path del automatic storage de la db

>db2 "SELECT SUBSTR(DB_NAME,1,8) AS DB_NAME, SUBSTR(DB_STORAGE_PATH,1,8) AS DB_STORAGE_PATH, STO_PATH_FREE_SIZE FROM SYSIBMADM.SNAPSTORAGE_PATHS"

DB_NAME  DB_STORAGE_PATH STO_PATH_FREE_SIZE
-------- --------------- --------------------
TEST      /db2/TEST                 61039665152
TEST      /db2/TEST                 61039677440
TEST      /db2/TEST                 61039644672
TEST      /db2/TEST                 61039689728
TEST      /db2/TEST                 61039640576
TEST      /db2/TEST                 60928073728

  6 record(s) selected.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.rtn.doc/doc/r0022006.html

carlos hiram