- 论坛徽章:
- 0
|
sco unix 505 +informix 7.23 库联不上!!!
Sat Mar 18 14:00:35 2006
14:00:35 Event alarms enabled. ALARMPROG = '/usr/informix/log_full.sh'
14:00:41 DR: DRAUTO is 0 (Off)
14:00:42 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
14:00:43 Physical Recovery Started.
14:00:43 Physical Recovery Complete: 0 Pages Restored.
14:00:43 Logical Recovery Started.
14:00:46 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
14:00:47 Dataskip is now OFF for all dbspaces
14:00:47 On-Line Mode
14:00:47 Checkpoint Completed: duration was 0 seconds.
14:00:49 listener-thread: err = -952: User's password is not correct for the d.
14:00:49 listener-thread: err = -952: User's password is not correct for the d.
14:00:49 listener-thread: err = -952: User's password is not correct for the d.
14:00:49 listener-thread: err = -952: User's password is not correct for the d.
14:00:49 listener-thread: err = -25571: Cannot create user thread. On NT check.
$ onstat
INFORMIX-OnLine Version 7.23.UC6 -- On-Line -- Up 01:44:37 -- 14624 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
82842014 ---P--D 1 informix - 0 0 0 20 4
82842450 ---P--F 0 informix - 0 0 0 0 0
8284288c ---P--B 5 informix - 0 0 0 0 0
82843540 ---P--D 8 informix - 0 0 0 0 0
4 active, 128 total, 17 maximum concurrent
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
33 69 392 91.58 4 4 0 0.00
isamtot open start read write rewrite delete commit rollbk
16 4 5 3 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 3.10 4.86 1 2
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
1 0 19 0 0 0 0 0
ixda-RA idx-RA da-RA RA-pgsused lchwaits
5 0 0 3 20
$ onstat -p
INFORMIX-OnLine Version 7.23.UC6 -- On-Line -- Up 01:52:02 -- 14624 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
33 69 392 91.58 4 4 0 0.00
isamtot open start read write rewrite delete commit rollbk
16 4 5 3 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 3.10 5.13 1 2
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
1 0 19 0 0 0 0 0
ixda-RA idx-RA da-RA RA-pgsused lchwaits
5 0 0 3 20
$ onstat -d
INFORMIX-OnLine Version 7.23.UC6 -- On-Line -- Up 01:52:34 -- 14624 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
828400ec 1 1 1 1 N informix rootdbs
1 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
No response from server process.
Warning: blob chunk page usage statistics may be inaccurate.
82840158 1 1 0 100000 64617 PO- /usr/informix/data/rt
1 active, 2047 maximum
$ onstat -l
INFORMIX-OnLine Version 7.23.UC6 -- On-Line -- Up 01:53:17 -- 14624 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 16 0 0 0.00%
phybegin physize phypos phyused %used
10003f 5000 2854 0 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 16 1 1 1 1.0 1.0
address number flags uniqid begin size used %used
82201c0c 1 U-B---- 739 1013c7 2500 2500 100.00%
82201c28 2 U---C-L 740 101d8b 2500 1363 54.52%
82201c44 3 U-B---- 735 10274f 2500 2500 100.00%
82201c60 4 U-B---- 736 103113 2500 2500 100.00%
82201c7c 5 U-B---- 737 103ad7 2500 2500 100.00%
82201c98 6 U-B---- 738 10449b 2500 2500 100.00% |
|