连接到当前数据库后,执行命令:db2 "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&nbs...(more)
方法一db2 "select char((TBSP_NAME),30) as TBSP_NAME,TBSP_ID,TBSP_USING_AUTO_STORAGE from table(snap_get_tbsp('purchase',-1)) as tbsp"如果值为1,则说明已经启用Automatic storage特性。方法二db2 get snapshot for tablespaces on ufwb | grep -i "Using automat...(more)
DB2数据库表损坏无法删除故障处理一例一、故障现象:删除表空间过程提示有表空间无法正常删除:[DWE3:/db2home/db2inst1/fengsh]db2 drop tablespace tbs_dwDB21034E The command was processed as an SQL statement because it was not a valid Command Line Process...(more)