|
아직 informix 에대해서 전혀 모르는 초보 입니다.
인터넷 여기 저기 찾아다녀 보니 lock에 대한 확인법과 로지컬 로그 확인법이 있어서 수행해 봤습니다.
아래와 같은 수치를 보이는데 도무지 무슨 말인지 모르겠네요.
아래의 내용에 대해 설명좀 부탁드립니다.
그리고 informix 에 대해 학원 또는 교육을 받지 않고 개인적으로 공부 하려면 참고해야 하는 곳도 좀 알려주세요.
물론 database.sarang.net 말고요 ^^
--------------------------------------------------------------------------------------------------------------------------------------
locking 확인 법
onstat -k
Informix Dynamic Server 2000 Version 9.21.UC6 -- On-Line -- Up 113 days 01:54:32 -- 631808 Kbytes
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
0 active, 200000 total, 65536 hash buckets, 0 lock table overflows
--------------------------------------------------------------------------------------------------------------------------------------
로지컬 로그 확인법.
onstat -l
Informix Dynamic Server 2000 Version 9.21.UC6 -- On-Line -- Up 113 days 01:56:57 -- 631808 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 32 336540 19957 16.86
phybegin physize phypos phyused %used
200035 374750 46610 0 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 16 22234 17173 17103 1.3 1.0
Subsystem numrecs Log Space used
OLDRSAM 22234 1468660
address number flags uniqid begin size used %used
b153750 1 U-B---- 15 330d75 25000 25000 100.00
b15376c 2 U-B---- 16 349415 25000 25000 100.00
b153788 3 U-B---- 17 34f5bd 25000 25000 100.00
b1537a4 4 U-B---- 18 300035 25000 25000 100.00
b1537c0 5 U-B---- 19 3061dd 25000 25000 100.00
b1537dc 6 U-B---- 20 30c385 25000 24999 100.00
b1537f8 7 U-B---- 21 31252d 25000 25000 100.00
b153814 8 U-B---- 22 3186d5 25000 25000 100.00
b153830 9 U-B---- 23 31e87d 25000 25000 100.00
b15384c 10 U---C-L 24 324a25 25000 12035 48.14
b153868 11 U-B---- 11 32abcd 25000 25000 100.00
b153884 12 U-B---- 12 336f1d 25000 25000 100.00
b1538a0 13 U-B---- 13 33d0c5 25000 25000 100.00
b1538bc 14 U-B---- 14 34326d 25000 25000 100.00
--------------------------------------------------------------------------------------------------------------------------------------
onstat -d
Informix Dynamic Server 2000 Version 9.21.UC6 -- On-Line -- Up 113 days 02:30:08 -- 631808 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
1830e7d0 1 0x1 1 4 N informix rootdbs
1899c018 2 0x1 2 1 N informix plogdbs
1899c160 3 0x1 3 1 N informix llogdbs
1899c2a8 4 0x2001 4 1 N T informix tempdbs1
1899c3f0 5 0x2001 5 1 N T informix tempdbs2
1899c538 6 0x2001 6 1 N T informix tempdbs3
1899c680 7 0x2001 7 1 N T informix tempdbs4
1899c7c8 8 0x1 8 4 N informix test_dbs1
1899c910 9 0x1 12 2 N informix commer
9 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
1830e918 1 1 1024 250000 6940 PO- /usr/informix/DBS/root_chk
1834d398 2 2 251024 375000 197 PO- /usr/informix/DBS/plog_chk
1834d508 3 3 626024 375000 24947 PO- /usr/informix/DBS/llog_chk
1834d678 4 4 1024 250000 249247 PO- /usr/informix/DBS/temp_chk01
1834d7e8 5 5 251024 250000 249247 PO- /usr/informix/DBS/temp_chk02
1834d958 6 6 501024 250000 249247 PO- /usr/informix/DBS/temp_chk03
1834dac8 7 7 751024 250000 249247 PO- /usr/informix/DBS/temp_chk04
1834dc38 8 8 1024 1000000 6 PO- /usr/informix/DBS/test_chk01
1834dda8 9 8 1024 1000000 159875 PO- /usr/informix/DBS/test_chk02
1830ea88 10 8 1024 1000000 999997 PO- /usr/informix/DBS/test_chk03
1830ebf8 11 8 1024 1000000 999997 PO- /usr/informix/DBS/test_chk04
1830ed68 12 9 1024 1000000 995713 PO- /usr/informix/DBS/commer_chk01
1833ea30 13 9 1024 1000000 999997 PO- /usr/informix/DBS/commer_chk02
1833eba0 14 1 1024 125000 8 PO- /usr/informix/DBS/root_chk01
1833ed10 15 1 0 2500 10 PO- /usr/informix/DBS/root_chk02
1833ee80 16 1 0 125000 90931 PO- /usr/informix/DBS/root_chk03
16 active, 2047 maximum
|
