Technical Blog Post
Abstract
Why SNAPSTORAGE_PATHS admin view returning "-" against some of the columns and how to fix it
Body
SYSIBMADM.SNAPSTORAGE_PATHS administrative view is not returning values against some of the columns. Instead it's showing "-".
Example,
$ db2 "select FS_TOTAL_SIZE, FS_USED_SIZE, STO_PATH_FREE_SIZE from sysibmadm.snapstorage_paths"
FS_TOTAL_SIZE FS_USED_SIZE STO_PATH_FREE_SIZE
-------------------- -------------------- --------------------
- - -
1 record(s) selected.
The reason being, it does not show those column values unless DFT_MON_BUFPOOL dbm config is turned ON.
So turn it ON using,
$ db2 update dbm cfg using DFT_MON_BUFPOOL ON
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
Then,
force applications, terminate, db2stop, db2start, connect to db back.
It will show the values after that.
Example,
$ db2 "select FS_TOTAL_SIZE, FS_USED_SIZE, STO_PATH_FREE_SIZE from sysibmadm.snapstorage_paths"
FS_TOTAL_SIZE FS_USED_SIZE STO_PATH_FREE_SIZE
-------------------- -------------------- --------------------
67645734912 48189661184 19388964864
1 record(s) selected.
UID
ibm11140580