同一台服务器有5个分区,怎么看到其他分区的情况?
asker : 同一台服务器上有5个分区,怎么从命令行看到其他分区的情况?好象有个表空间满了
reply : db2 list dbpartitionnums
asker : UNIX系统,用裸设备的
reply : tbs full? The best way is to check if disk full.
reply : yes, dev also has space usage ,in linux, df -h could check it. df -h
asker : 用实例用户登陆,只能看到0分区的情况,不知道如何看1-5分区的表空间使用情况
df是看文件系统的,我这是裸设备
reply : db2_all; db2 terminate; "db2 list tablespaces show detail"
asker : 没用, 老是说我没连接数据库
reply : db2_all; db2 terminate;db2 connect to ;"db2 list tablespaces show detail"
asker :我刚才用了export db2node=3 然后db2 "values (current dbpartitionnum)" 看到的活动分区还是0
reply :db2_all
enter your command, omit trailing ;, or enter null to quit, or enter ? for help
db2 terminate;db2 connect to ;db2 list tablespaces show detail;
asker : $
$ db2 terminate
DB20000I The TERMINATE command completed successfully.
$ export db2node=3
$ db2 "values (current dbpartitionnum)"
SQL1024N A database connection does not exist. SQLSTATE=08003
$ db2 connect to acrm
Database Connection Information
Database server = DB2/AIX64 8.2.9
SQL authorization ID = HZIN
Local database alias = ACRM
$ db2 "values (current dbpartitionnum)"
1
-----------
0
1 record(s) selected.
reply : are u sure it is partition db?
asker : 是的
$ cat db2nodes.cfg
0 HZCRM-ACRM-SJK01 0
1 HZCRM-ACRM-SJK01 1
2 HZCRM-ACRM-SJK01 2
3 HZCRM-ACRM-SJK01 3
4 HZCRM-ACRM-SJK01 4
5 HZCRM-ACRM-SJK01 5
$
reply : db2_all
enter your command, omit trailing ;, or enter null to quit, or enter ? for help
db2 terminate;db2 connect to ;db2 list tablespaces show detail;
asker :
#db2_all
db2 terminate
db2 connect to acrm
db2 list tablespaces show detail
这样吗?
reply :
db2_all
type:
db2 terminate;db2 connect to ;db2 list tablespaces show detail;
asker : 问题解决
Ps;群消息整理