• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Question abt storage pool view

sabrine

ADSM.ORG Member
#1
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
 

sabrine

ADSM.ORG Member
#3
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

ADSM.ORG Member
#4
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
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 18 18.8%
  • Keep using TSM for Spectrum Protect.

    Votes: 58 60.4%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.5%
  • Other (please comement)

    Votes: 8 8.3%

Forum statistics

Threads
31,635
Messages
134,820
Members
21,669
Latest member
sammiehung
Top