1、显示当前数据库表空间的使用情况
WINDOWS:
UNIX:
2、中断数据库连接进程
WINDOWS:
UNIX:
WINDOWS:
d:/>for /f "skip=2 tokens=1,3" %a in ('db2 list tablespaces show detail') do @if %a==名称 (echo %a = %b) else (@if %a==总计页数 (echo %a = %b) else (@if %a==高水位标记(页) (echo %a = %b)))
名称 = SYSCATSPACE
总计页数 = 9228
高水位标记(页) = 不适用
名称 = TEMPSPACE1
总计页数 = 1
高水位标记(页) = 不适用
名称 = USERSPACE1
总计页数 = 670
高水位标记(页) = 不适用
名称 = COMMON_TS_GENERAL
总计页数 = 100000
高水位标记(页) = 9504
名称 = COMMON_TS_INDEX
总计页数 = 100000
高水位标记(页) = 6112
名称 = WZGL_TS_GENERAL
总计页数 = 100000
高水位标记(页) = 7712
名称 = WZGL_TS_INDEX
总计页数 = 100000
高水位标记(页) = 6272
名称 = WZGL_TS_LONG
总计页数 = 200000
高水位标记(页) = 102080
名称 = ZTB_TS_GENERAL
总计页数 = 100000
高水位标记(页) = 6240
名称 = ZTB_TS_INDEX
总计页数 = 100000
高水位标记(页) = 6112
名称 = ZTB_TS_LONG
总计页数 = 100000
高水位标记(页) = 1504
名称 = SYSTOOLSPACE
总计页数 = 147
高水位标记(页) = 不适用
名称 = SYSTOOLSTMPSPACE
总计页数 = 1
高水位标记(页) = 不适用
d:/>
UNIX:
或者
$ db2 list tablespaces show detail | awk -F= '/Name/||/Total/||/High/ {printf("%s = %s/n",$1,$2)}'
Name = SYSCATSPACE
Total pages = 12631
High water mark (pages) = Not applicable
Name = TEMPSPACE1
Total pages = 1
High water mark (pages) = Not applicable
Name = USERSPACE1
Total pages = 315
High water mark (pages) = Not applicable
Name = USERTEMP
Total pages = 1
High water mark (pages) = Not applicable
Name = CWGL_DI_L
Total pages = 1502256
High water mark (pages) = 1468288
Name = CWGL_DI_M
Total pages = 206784
High water mark (pages) = 108096
Name = CWGL_DI_S
Total pages = 325000
High water mark (pages) = 208768
Name = CWGL_DR_L
Total pages = 1287760
High water mark (pages) = 1204672
Name = CWGL_DR_M
Total pages = 330880
High water mark (pages) = 259360
Name = CWGL_DR_S
Total pages = 999456
High water mark (pages) = 789440
Name = CWGL_DR_XL1
Total pages = 997952
High water mark (pages) = 997920
Name = CWGL_DR_XL2
Total pages = 624672
High water mark (pages) = 522400
Name = CWGL_DR_XL3
Total pages = 472416
High water mark (pages) = 222784
Name = CWGL_DL
Total pages = 218128
High water mark (pages) = 119264
Name = SYSTOOLSPACE
Total pages = 116
High water mark (pages) = Not applicable
$
$
$ db2 list tablespaces show detail | awk -F= /
> 'BEGIN {printf(" Tablespace Name Total Pages High Warter Mark/n") } /
> /Name/ {printf("%20s",$2)} /Total/ {printf("%20s",$2)} /High/ {printf("%20s/n",$2)}'
Tablespace Name Total Pages High Warter Mark
SYSCATSPACE 12631 Not applicable
TEMPSPACE1 280 Not applicable
USERSPACE1 315 Not applicable
USERTEMP 1 Not applicable
CWGL_DI_L 1502256 1471072
CWGL_DI_M 206784 108096
CWGL_DI_S 325000 208768
CWGL_DR_L 1287760 1204960
CWGL_DR_M 330880 259360
CWGL_DR_S 999456 789440
CWGL_DR_XL1 1097952 1000768
CWGL_DR_XL2 624672 522400
CWGL_DR_XL3 472416 222784
CWGL_DL 218128 119328
SYSTOOLSPACE 116 Not applicable
$
2、中断数据库连接进程
WINDOWS:
F:/>for /f "skip=4 tokens=3,5" %a in ('db2 list applications for db wzgl') do @if %b==WZGL echo db2 force application(%a)
db2 force application(126)
db2 force application(49)
db2 force application(47)
db2 force application(20)
db2 force application(272)
db2 force application(231)
db2 force application(221)
db2 force application(220)
db2 force application(180)
db2 force application(155)
db2 force application(154)
F:/>
UNIX:
$ db2 list applications for db cwgl | awk '$5=="CWGL" {printf("db2 /"force application(%s)/"/n",$3) }'
db2 "force application(1322)"
db2 "force application(1346)"
db2 "force application(1363)"
db2 "force application(1379)"
db2 "force application(1331)"
db2 "force application(1255)"
db2 "force application(1332)"
db2 "force application(1187)"
db2 "force application(1121)"
$