HOST上VSAM TableSpace SPACE check
SYSカタログから取得SQL:
SELECT
A.DBNAME,
A.NAME,
A.EXTENTS,
A.UPDATESTATSTIME,
CHAR(B.PQTY*4) AS PQTY,
CHAR(B.SQTY*4) AS SQTY
FROM SYSIBM.SYSTABLESPACESTATS A,
SYSIBM.SYSTABLEPART B
WHERE A.DBNAME = B.DBNAME
AND A.NAME = B.TSNAME
AND SUBSTR(A.DBNAME,1,4) IN ('KQXX','IGXX')
ORDER BY A.DBNAME, A.NAME
A.NAME,
A.EXTENTS,
A.UPDATESTATSTIME,
CHAR(B.PQTY*4) AS PQTY,
CHAR(B.SQTY*4) AS SQTY
FROM SYSIBM.SYSTABLESPACESTATS A,
SYSIBM.SYSTABLEPART B
WHERE A.DBNAME = B.DBNAME
AND A.NAME = B.TSNAME
AND SUBSTR(A.DBNAME,1,4) IN ('KQXX','IGXX')
ORDER BY A.DBNAME, A.NAME