Print
Category: DB2
Hits: 3139

ALTER TABLESPACE USERSPACE1 AUTORESIZE YES MAXSIZE 200 G
db2 "ALTER TABLESPACE USERSPACE1 MAXSIZE 10 G"


db2 ALTER TABLESPACE USERSPACE1 AUTORESIZE YES
db2 "ALTER TABLESPACE USERSPACE1 RESIZE (ALL 256 M)"
db2 "ALTER TABLESPACE USERSPACE1 RESIZE (ALL 188)"


db2 "select tbspace,pagesize from sysibm.systablespaces"

db2 "ALTER TABLESPACE USR_TBSPC_32K RESIZE (ALL 766608)"


db2 "SELECT SUBSTR(TBSP_NAME,1,15) NAME, TBSP_TYPE TYPE,
TBSP_AUTO_RESIZE_ENABLED AUTO_RESIZE, TBSP_NUM_CONTAINERS CONTAINERS,
TBSP_TOTAL_PAGES TOTAL_PGS, TBSP_USED_PAGES USED_PGS, TBSP_FREE_PAGES FREE_PGS,
TBSP_MAX_SIZE MAX_SZ, TBSP_PAGE_SIZE PG_SZ
FROM SYSIBMADM.TBSP_UTILIZATION
WHERE TBSP_CONTENT_TYPE IN ('ANY','SYSTEMP')"

https://www.ibm.com/support/knowledgecenter/ru/SSEPGG_9.7.0/com.ibm.db2.luw.qb.upgrade.doc/doc/t0022269.html


число_страниц = ( используется_страниц - свободно_страниц ) /
число_контейнеров_в_SYSCATSPACE
(554944-211520)/3
db2 "ALTER TABLESPACE USR_TBSPC_32K EXTEND (ALL 114475)"