- 论坛徽章:
- 0
|
shell环境下运行以下命令:
su - sybase -c sybasedbcheck.sh apdb (sybasedbcheck.sh获取了isql环境执行命令的输出结果,可是是表格式)
输出如下:
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
apdb 3072.0 MB apdbo 4
Mar 14, 2003
select into/bulkcopy/pllsort, trunc log on chkpt
(1 row affected)
device_fragments size usage
free kbytes
------------------------------ ------------- --------------------
----------------
d_apdsdb 2048.0 MB data only
2012364
d_apdslog 1024.0 MB log only
not applicable
--------------------------------------------------------------
log only free kbytes = 1044478
(return status = 0)
如果需要逐个检查并获得device_fragments中各个device(如d_apdsdb,d_apdslog)的 size和free kbytes的值并执行逻辑判断,各位有什么好的方法可以实现么? |
|