S
Stefan Marquardt
Guest
Hit% 91.57 Commits: 3,813 New RM: 3,553 Oldest TRX: 00:00:00 Connections: 15 Log Reads: 11,346 Undos: 0 From RM: 3,549 Curr BIClstr: 84 Brokers: 1 OS Reads: 956 Lock Tbl HWM: 388 From Free: 3 Oldest BIClstr: 83 4gl Servers: 1 Rec Reads: 3,815 Curr # Locks: 4 Examined: 3,699 Checkpoints: 83 SQL Servers: 0 LogRd/RecRd: 2.97 Modified Bufs: 10,361 Front2Bk: 0 Curr AI Extent: Disabled 4gl Clients: 5 Log Writes: 16,256 IO Response: 6.38 Remove Lk: 0 Curr AI Seq#: 0 SQL Clients: 0 OS Writes: 1,056 BogoMIPS: 4.17 Empty AI Exts: -1 App Server: 3 Rec Creates: 0 BogoMIP%: 91.67 Full AI Exts: -1 BIW: 1 Rec Updates: 3,813 AIW: 0 Rec Deletes: 0 Notes: 23,885 0 APW Writes: 1,034 APWs: 3 Rec Locks: 7,624 BIW/AIW Write% 94 0 APW Write% 98 WDOG: 1 Rec Waits: 0 Writes to Log: 370 0 Bufs Scanned: 32 Local: 1 Idx Blk Spl: 0 BIW/AIW Writes: 346 0 APW Scan Wrts: 0 Remote: 0 Resrc Waits: 837 Partial Buf Wr: 1 0 APW Q Wrts: 0 Batch: 7 Latch Waits: 29 Busy Buf Waits: 9 0 Chkpt Q Wrts: 1,034 TRX: 1 Empty Buf Wts: 30 0 Flushed Bufs: 0 Blocked: 0 ┌───────────────────────────────────────────────────────── Table Activity ───────────────────────────────────────────────────────── │ Tbl# Area# Table Name #Records Turns Create Read v Update Delete OS Read │ ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── │ √ 17 15 Table1 0.00 0 2,734 2,734 0 56 │ 267 20 Table2 0.00 0 1,115 1,115 0 900 │ 338 11 Table3 0.00 0 0 0 0 0 ┌───────────────────────────────────────────────────────── Index Activity ───────────────────────────────────────────────────────── │ Idx# Area# Index Name Blocks Util Idx Root Create Read v Split Delete BlkDl Note │ ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── │ √ 27 16 Table1.Main 0 0% 87 0 2,698 0 0 0 P │ 589 21 Table2.Main 0 0% 15 0 1,113 0 0 0 P │ 767 16 Table3.Main 0 0% 1983 0 1 0 0 0 PU ┌──────────────────────────────────────────────────────── User IO Activity ──────────────────────────────────────────────────────── │ Usr# Name PID Flags Blk Ac v OS Rd OS Wr Hit% Rec Lck Rec Wts Line# Program Name │ ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── │ √ 17 User1 700 S4B* 16111 57 22 99.65% 5479 0 │ 18 User2 59852 S4B* 7435 898 0 87.93% 2226 0 │ 19 6748 6748 S4 12 0 0 100.00% 0 0 ┌────────────────────────────────────────────────────────── Checkpoints ─────────────────────────────────────────────────────────── │ Chkpt# v Start Finish Length Dirty ChkPtQ Scan APW Q Flushed Duration Sync Time │ ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── │ √ 83 May 20 14:32:37 ? 11,766 8,245 0 0 0 0.12 0.11 │ 82 May 20 14:32:27 14:32:37 00:00:10 11,053 11,053 2 0 0 0.35 0.34 │ 81 May 20 14:32:15 14:32:26 00:00:11 10,789 10,786 0 0 0 0.14 0.13 │ 80 May 20 14:32:04 14:32:14 00:00:10 10,862 10,855 0 0 0 0.21 0.19
Continue reading...
Continue reading...