The ADMIN_GET_STORAGE_PATHS table function returns a list of automatic storage paths for each database storage group, including file system information for each storage path.
Refer to Table 1 for a complete list of information that can be returned.
None
SELECT VARCHAR(STORAGE_GROUP_NAME, 30) AS STOGROUP, VARCHAR(DB_STORAGE_PATH, 40)
AS STORAGE_PATH FROM TABLE(ADMIN_GET_STORAGE_PATHS('',-1)) AS T
WHERE DB_STORAGE_PATH_STATE = 'DROP_PENDING'
The following
is an example of the output from this query.STOGROUP STORAGE_PATH
------------------------------ ----------------------------------------
HOTSTORAGE /home/hotel55/hotpath1
1 record(s) selected.
SELECT VARCHAR(STORAGE_GROUP_NAME, 30) AS STOGROUP, VARCHAR(DB_STORAGE_PATH, 40)
AS STORAGE_PATH FROM TABLE(ADMIN_GET_STORAGE_PATHS('',-1)) AS T
The
following is an example of the output from this query.STOGROUP STORAGE_PATH
------------------------------ ----------------------------------------
IBMSTOGROUP /home/hotel55/instowner
HOTSTORAGE /home/hotel55/hotpath1
COLDSTORAGE /home/hotel55/coldpath1
3 record(s) selected.