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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm11140580