ããdb2 æ¥ç表空é´ä½¿ç¨ç
ãã1. ç»è®¡ææèç¹è¡¨ç©ºé´ä½¿ç¨ç
ããselect substr(TABLESPACE_NAME,1,20) as TBSPC_NAME,bigint(TOTAL_PAGES * PAGE_SIZE)/1024/1024 as "TOTAL(MB)",
used_pages*PAGE_SIZE/1024/1024 as "USED(MB)", free_pages*PAGE_SIZE/1024/1024 as "FREE(MB)"
from table(snapshot_tbs_cfg('DB_NAME', -2)) as snapshot_tbs_cfg
2ãæ¥ç表空é´ä½¿ç¨ç
ããselect substr(tbsp_name,1,20) as TABLESPACE_NAME,substr(tbsp_content_type,1,10) as TABLESPACE_TYPE,sum(tbsp_total_size_kb)/1024 as TOTAL_MB,
sum(tbsp_used_size_kb)/1024 as USED_MB,sum(tbsp_free_size_kb)/1024 as FREE_MB,tbsp_page_size AS PAGE_SIZE
from SYSIBMADM.TBSP_UTILIZATION group by tbsp_name,tbsp_content_type,tbsp_page_size
ããorder by 1
3ãéè¿åå¨è¿ç¨æ¥çæ°æ®åºå¤§å°å容é
db2 call GET_DBSIZE_INFO (?,?,?,0)
ãã è¾åºåæ°çå¼
ãã --------------------------
ãã åæ°åï¼ SNAPSHOTTIMESTAMP
ãã åæ°å¼ï¼ 2008-05-26-10.53.06.421000
ãã åæ°åï¼ DATABASESIZE
ãã åæ°å¼ï¼ 1203863552
ãã åæ°åï¼ DATABASECAPACITY
ãã åæ°å¼ï¼ 4281493504
ããunit=byte, byte/1024/1024=m
ããdb2 call GET_DBSIZE_INFO (?,?,?,0)
ãã注æï¼
aãä»V8以ä¸çæ¬æ¯æï¼æ¤åå¨è¿ç¨çæ°æ®åºå¤§å°å容éï¼å¦æè¦çå表空é´ä½¿ç¨æ
åµä¸é¢çsqlæ¹ä¾¿ï¼
ãã bãè¿æDPFç¯å¢ä¸ï¼db2 call GET_DBSIZE_INFO (?,?,?,0)åªè½çdbsize大å°ï¼æ æ³çdbç容é
SYSIBM.SYSTABLESPACES
SYSIBM.SYSTBSPACEAUTH
2.db2æ¥ç表空é´åå¢å 表空é´å®¹é
Db2 connect to xxx
Db2 âLIST TABLESPACES SHOW DETAILâ
Tablespace ID = 7
Name = TSASNAA
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 14800
Useable pages = 14752
Used pages = 12864
Free pages = 1888
High water mark (pages) = 12864
Page size (bytes) = 8192
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
å¢å 表空é´å¤§å°
DB2æ°æ®åºä½¿ç¨æ¶ï¼å¦æ表空é´æ»¡äºï¼è¯¥å¦ä½æ©å®¹å¢ï¼ä¸æå°æç»æ¨DB2æ°æ®åºè¡¨ç©ºé´æ©å®¹çæ¹æ³ï¼ä¾æ¨åèï¼å¸æ对æ¨ææ帮å©ã
1ï¼ç´æ¥æ·»å ä¸ä¸ªå®¹å¨çä¾åï¼
db2 " ALTER TABLESPACE PAYROLL ADD (DEVICE '/dev/rhdisk9' 10000) "
å 容å¨ä¹åDB2ä¼æä¸ä¸ªèªå¨balanceçè¿ç¨,å¯è½ä¼æç»å 个å°æ¶!!! ä¸å®è¦æ³¨æ该é项,ä¿®æ¹å确认该é项æ¯å¦è½æ»¡è¶³ä¸å¡éæ±!
2ï¼æ¹åç°æ容å¨ç大å°(该æ¹æ³ä¸ä¼è§¦åbalance,ä½å¦æ表空é´å»ºç«å¨è£¸è®¾å¤ä¸,åè¦æ©å²è£¸è®¾å¤ç©ºé´):
db2 " ALTER TABLESPACE TS1 RESIZE (FILE '/conts/cont0' 2000, DEVICE '/dev/rcont1' 2000, FILE 'cont2' 2000) "
注æè¿ç§æ¹å¼å°±æ¯å°åæçç¸åºå®¹å¨é½æ¹æ大å°æ¯2000页
db2 "ALTER TABLESPACE TS1 RESIZE (ALL 2000)"
è¿ç§æ¹å¼å°±æ¯æ表空é´ä¸ææç容å¨å¤§å°é½æ¹æ2000页
db2 " ALTER TABLESPACE TS1 EXTEND (FILE '/conts/cont0' 1000, DEVICE '/dev/rcont1' 1000, FILE 'cont2' 1000) "
è¿ç§æ¹å¼å°±æ¯å°ç¸åºç容å¨é½æ©å¤§1000页ï¼ä¹å°±æ¯å¢å 1000页ã
db2 " ALTER TABLESPACE DATA_TS EXTEND (ALL 1000)"
è¿ç§æ¹å¼å°±æ¯å°ææç容å¨é½å¢å 1000页ã
ãã3.db2æ°æ®åå
¸
select name from sysibm.systables where type='T' and creator='USERID' and tbspace='TS4R_DNJC' order by name;
select name from sysibm.systables where type='V' and creator='USERID' order by name;
type:æ°æ®åºè¡¨ç¨T表示ï¼æ°æ®åºè§å¾ç¨V表示
creator:æ°æ®åºå¯¹è±¡çå建è
select * from sysibm.syscolumns
ããselect tabname from syscat.tables where tabschema=current schema ;
è·åå½å模å¼ä¸é¢çææç¨æ·è¡¨
describe table XXXX
ããSELECT NAME
,COLNO
,COLTYPE || '('
|| CAST(LENGTH AS CHAR(5)) || ','
|| CAST(SCALE AS CHAR(5)) || ')'
,CASE WHEN NULLS = 'N'
THEN 'NOT NULL' ELSE ' ' END
,TBNAME
WHERE TBCREATOR = 'TEST' -- < OR 'TEST'
-- AND (NAME = 'YOUR_COL_NAME' -- < COLUMN NAME \ ONLY USE ONE
AND (TBNAME = 'T_QUICK_MENU' -- < TABLE NAME /
)
ORDER BY TBNAME, COLNO
SELECT NAME FROM SYSIBM.SYSCOLUMNS
温馨提示:答案为网友推荐,仅供参考