IBM Support

Why SNAPSTORAGE_PATHS admin view returning "-" against some of the columns and how to fix it

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.

 

 

 

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11140580