Question abt storage pool view

[sabrine]

Hello everyone,
i'm working on generating dashboard for storage pool capacity so i want to know where to find this informations in db2 because when i was looking in db2 tables i just found STGPOOLS which is a an empty view. So my question is why this view is empty no records and when i run a command on TSM server i get the result. So i want to know where TSM server stores this information why i can't get it in db2 view
Thank you in advance

 

[dicowins]

select * from STGPOOLS has the data Capacity is a rounded division by 1024.

 

[sabrine]

Thank you
Yes i found it yet i still have a small issue right now why some DB2 tables contains data only if i pass a select command from tsm console. Is it a feature related to TSM Server ?

 

[dicowins]

I created one script to list tables and another to list firelds in a table.
List Tables
select cast((TABNAME) as char(50)) as "Table name" from syscat.tables order by TABNAME
List Fields
select cast((colname) as char(50)) as "Fieldname",cast((length) as char(20)) as "Length" from syscat.columns where tabname='$1 ' order by colname

The List fields is run by run SCRIPTNAME DB_TABLENAME

So IF I run against STGPOOLS I get

Fieldname Length
--------------------------------------------------- ---------------------
ACCESS 128
ACTIVEDATASTGPOOLS 311
AUTOCOPY 12
BUCKETNAME 64
CACHE 5
CHG_ADMIN 65
CHG_TIME 10
CLOUDSTORAGECLASS 41
CLOUD_ID 256
CLOUD_LOCATION 256
CLOUD_TYPE 101
CLOUD_URL 871
COLLOCATE 20
COMPRESSED 3
COMP_SPACE_SAVED_MB 8
COPYCONTINUE 5
COPYSTGPOOLS 311
CRCDATA 5
DATAFORMAT 12
DEDUPLICATE 5
DEDUP_REQ_BKUP 3
DEDUP_SPACE_SAVED_MB 8
DESCRIPTION 255
DEVCLASS 31
ENCRYPTED 3
EST_CAPACITY_MB 20
HAS_CLIENT_DEDUP_DATA 12
HIGHMIG 4
IDENTIFYPROCESS 4
LASTPROTECTLOCAL_DATE 10
LASTPROTECT_DATE 10
LOCAL_EST_CAPACITY_MB 20
LOCAL_PCT_LOGICAL 5
LOCAL_PCT_UTILIZED 5
LOWMIG 4
MAXSCRATCH 4
MAXSIZE 20
MAX_WRITERS 12
MIGCONTINUE 20
MIGDELAY 4
MIGPROCESS 4
MIGR_MB 20
MIGR_RUNNING 5
MIGR_SECONDS 4
NEXTSTGPOOL 31
NUMSCRATCHUSED 4
OFFSITERCLMLIMIT 12
OVFLOCATION 256
PCT_ENCRYPTED 6
PCT_LOGICAL 5
PCT_MIGR 5
PCT_UTILIZED 5
POOLTYPE 31
PROTECTLOCALSTGPOOLS 311
PROTECTPROCESS 4
PROTECTSTGPOOL 31
RECLAIM 4
RECLAIMPROCESS 4
RECLAIMSTGPOOL 31
RECLAIM_LIMIT 12
RECLAMATIONTYPE 25
RECL_RUNNING 5
REMOVERESTOREDCOPYBEFORELIFETIMEEND 12
REUSEDELAY 4
SHRED_COUNT 4
SPACE_SAVED_MB 8
SPACE_USED_FOR_PROTECTED_DATA 25
STGPOOL_NAME 31
STG_TYPE 13
TOTAL_CLOUD_SPACE_MB 4
TOTAL_UNUSED_PENDING_MB 25
TRIGGER_PCT_UTIL 5
USED_CLOUD_SPACE_MB 4

Thank you
Yes i found it yet i still have a small issue right now why some DB2 tables contains data only if i pass a select command from tsm console. Is it a feature related to TSM Server ?

Im not sure