sybase 11을 쓰고 있습니다. (hp unix)
그런데 갑자기 지정한 할당량의 디스크가 (db만 사용) 100% 사용으로 되었습니다.
그래서 log 파일을 삭제하고 (dump tran kang with no_log)
error_log 파일도 삭제하고 db를 재기동했으나 100%에서 더이상 줄지 않습니다.
기존에는 50% 정도 사용하고 있었습니다.
데이타베이스 상태는 다음과 같습니다.
1> sp_spaceused syslogs
2> go
name rowtotal reserved data index_size
unused
-------------------- ---------- --------------- --------------- --------------
-----------
syslogs Not avail. 16 KB 16 KB 0 KB
Not avail.
(return status = 0)
1> sp_helpdb
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
-----------------------------------------------------------------------
mydb 9300.0 MB sa 7
Dec 10, 1996
select into/bulkcopy, trunc log on chkpt
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
my_data00 2000.0 MB data only 1841360
my_data01 2000.0 MB data only 2048000
my_data02 2000.0 MB data only 2048000
my_data03 2000.0 MB data only 2048000
my_data 1000.0 MB data only 363424
my_log 300.0 MB log only 307184
device
segment
------------------------------
my_data00
default
my_data00
system
my_data01
default
my_data01
system
my_data02
default
my_data02
system
my_data03
default
my_data03
system
my_data
default
my_data
system
my_log
logsegment
1> sp_spaceused
2> go
database_name database_size
------------------------------ -------------
mydb 9300.0 MB
reserved data index_size unused
--------------- --------------- --------------- ---------------
863844 KB 189086 KB 670368 KB 4390 KB
(return status = 0)
$ bdf -i
Filesystem kbytes used avail %used iused ifree %iuse Mounted on
/dev/vg00/lvol1 700691 460016 170605 73% 27361 84127 25% /
/dev/vg00/lvol3 956955 858556 2703 100% 19034 133222 13% /usr
/dev/vg01/lvol4 600571 419015 121498 78% 846 94834 1% /user1
$ df
/user1 (/dev/vg01/lvol4 ): 242996 blocks 94834 i-nodes
/usr (/dev/vg00/lvol3 ): 5406 blocks 133222 i-nodes
/ (/dev/vg00/lvol1 ): 341210 blocks 84127 i-nodes
$ find /usr -xdev -size +5000000c -exec ls -lrt {} \;
find: cannot open /usr/newconfig/etc/sam/custom
-r--r--r-- 1 bin bin 8451874 Nov 3 1999 /usr/conf/lib/libhp-ux.a
-r-xr-xr-x 1 bin bin 5570216 Jun 2 1995 /usr/conf/vmunix.client
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/helpview
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vueaction
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vueannotator
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuecolor
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuedialog
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuefile
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuegreet
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuepad
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuehello
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vueicon
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuelock
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuelogin
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuesession
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuestyle
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuetypes
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/vuewm
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/xload
-r-sr-sr-x 18 root sys 5693432 Jul 30 1996 /usr/vue/bin/hpterm
-r-sr-sr-x 1 root sys 5005312 May 23 1995 /usr/vue/bin/##xload
-rwxr-xr-x 1 sybase rdbms 15782804 Mar 5 1996 /usr/sybase/bin/diagbs
-rwxr-xr-x 1 sybase rdbms 27841804 Mar 6 1996 /usr/sybase/bin/diagservr
-rw-rw-rw- 1 sybase rdbms 41943040 Feb 20 19:50 /usr/sybase/master.dat
-rw-rw-rw- 1 sybase rdbms 26214400 Feb 20 19:39 /usr/sybase/sybprocs.dat
-rw-r--r-- 1 sybase rdbms 5543564 Jul 21 1995 /usr/sybase/devlib/libcoma
-rw-r--r-- 1 sybase rdbms 13395480 Jul 21 1995 /usr/sybase/devlib/libcta
-rw-rw-rw- 1 sybase rdbms 52428800 Feb 20 19:39 /usr/sybase/temp_dev.dat
-rw-rw-rw- 1 sybase rdbms 331694080 Feb 13 15:25 /usr/sybase/tApedum
어떻게 free 를 확보할 수 있는지 도와주세요....
|