 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Informix Topics / June 2008Speed issues 9.4
I am not sure what has happened but over the last week we went from zero complaints about speed to a lot of complaints. No app changes. The DB Server is a Sun V490 with 24 FC 15k drives configured as Raid 10. Checkpoints are averaging 0 seconds. IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 5 days 03:42:4 8 -- 2612224 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 228057060 779495368 2164074103 89.61 12488020 47951408 124371428 91.10 isamtot open start read write rewrite delete commit rollbk 1074256246 94337976 369843143 3789933033 43977852 7225917 4844460 1843268 213 4 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 61744.94 22718.42 602 1488 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 23845959 2399 3763015321 0 0 386 1045516 4462000 ixda-RA idx-RA da-RA RA-pgsused lchwaits 21349917 2718532 80138637 103942631 694834 onstat -g iov IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 5 days 03:39:2 6 -- 2612224 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors kio 0 s 116.6 51897068 49539166 2357902 0 98048287 0.5 0 kio 1 i 111.2 49480269 46984299 2495970 0 93220077 0.5 0 kio 2 s 30.4 13534186 12093534 1440652 0 24848841 0.5 0 kio 3 s 63.5 28278503 26432019 1846484 0 52454339 0.5 0 kio 4 i 14.9 6640466 5595584 1044882 0 12376862 0.5 0 kio 5 i 20.4 9081038 7929376 1151662 0 16730461 0.5 0 kio 6 s 45.1 20064775 18232398 1832377 0 36375647 0.6 0 msc 0 i 0.9 396585 0 0 0 395863 1.0 0 aio 0 i 0.5 216593 64458 20553 0 216504 1.0 0 aio 1 i 0.0 127 30 2 0 194 0.7 0 aio 2 i 0.0 9 5 0 0 14 0.6 0 aio 3 i 0.0 10 4 0 0 6 1.7 0 aio 4 i 0.0 8 1 0 0 4 2.0 0 aio 5 i 0.0 7 1 0 0 4 1.8 0 aio 6 i 0.0 4 1 0 0 3 1.3 0 pio 0 i 0.0 0 0 0 0 1 0.0 0 lio 0 i 0.0 0 0 0 0 1 0.0 0 db1:/ # onstat -R IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 5 days 03:39:4 7 -- 2612224 Kbytes 128 buffer LRU queue sets priority levels # type set total % of length LOW HIGH 0 f 7031 99.8% 7020 6191 829 1 m 0.2% 11 2 9 2 f 7031 99.7% 7010 6200 810 3 m 0.3% 21 6 15 4 f 7031 99.7% 7012 6228 784 5 m 0.3% 19 4 15 6 f 7032 99.7% 7012 6174 838 7 m 0.3% 20 5 15 8 f 7031 99.7% 7013 6204 809 9 m 0.3% 18 3 15 10 f 7032 99.8% 7021 6193 828 11 m 0.2% 11 2 9 12 f 7031 99.7% 7008 6171 837 13 m 0.3% 23 4 19 14 f 7032 99.6% 7005 6146 859 15 m 0.4% 27 5 22 16 f 7031 99.6% 7003 6212 791 17 m 0.4% 28 5 23 18 f 7031 99.6% 7003 6171 832 19 m 0.4% 28 8 20 20 f 7031 99.6% 7003 6183 820 21 m 0.4% 28 5 23 22 f 7031 99.5% 6999 6181 818 23 m 0.5% 32 7 25 24 f 7031 99.7% 7013 6213 800 25 m 0.3% 18 6 12 26 f 7031 99.6% 7006 6211 795 27 m 0.4% 25 4 21 28 f 7031 99.8% 7015 6202 813 29 m 0.2% 16 8 8 30 f 7031 99.6% 7001 6156 845 31 m 0.4% 30 4 26 32 f 7031 99.5% 6999 6183 816 33 m 0.5% 32 7 25 34 f 7032 99.7% 7008 6225 783 35 m 0.3% 24 5 19 36 f 7032 99.7% 7011 6187 824 37 m 0.3% 21 4 17 38 f 7031 99.6% 7001 6157 844 39 m 0.4% 30 4 26 40 f 7032 99.5% 6995 6192 803 41 m 0.5% 37 11 26 42 f 7033 99.6% 7002 6145 857 43 m 0.4% 31 5 26 44 F 7030 99.7% 7010 6183 827 45 m 0.3% 20 5 15 46 f 7031 99.7% 7011 6214 797 47 m 0.3% 20 6 14 48 f 7031 99.7% 7013 6214 799 49 m 0.3% 18 3 15 50 f 7031 99.6% 7003 6216 787 51 m 0.4% 28 6 22 52 f 7032 99.7% 7014 6161 853 53 m 0.3% 18 3 15 54 f 7031 99.6% 7002 6206 796 55 m 0.4% 29 5 24 56 f 7031 99.5% 6996 6195 801 57 m 0.5% 35 9 26 58 f 7032 99.8% 7018 6215 803 59 m 0.2% 14 3 11 60 f 7031 99.7% 7012 6179 833 61 m 0.3% 19 3 16 62 f 7031 99.7% 7012 6217 795 63 m 0.3% 19 1 18 64 f 7032 99.6% 7003 6202 801 65 m 0.4% 29 6 23 66 f 7032 99.6% 7002 6175 827 67 m 0.4% 30 4 26 68 f 7031 99.6% 7006 6229 777 69 m 0.4% 25 2 23 70 f 7032 99.8% 7020 6217 803 71 m 0.2% 12 1 11 72 f 7031 99.7% 7013 6196 817 73 m 0.3% 18 5 13 74 f 7032 99.7% 7010 6197 813 75 m 0.3% 22 3 19 76 f 7031 99.7% 7009 6195 814 77 m 0.3% 22 8 14 78 f 7031 99.6% 7005 6157 848 79 m 0.4% 26 0 26 80 f 7031 99.6% 7006 6211 795 81 m 0.4% 25 5 20 82 f 7031 99.8% 7017 6232 785 83 m 0.2% 14 2 12 84 f 7031 99.7% 7013 6243 770 85 m 0.3% 18 2 16 86 f 7030 99.7% 7011 6212 799 87 m 0.3% 19 4 15 88 f 7031 99.8% 7019 6191 828 89 m 0.2% 12 5 7 90 f 7031 99.7% 7007 6227 780 91 m 0.3% 24 9 15 92 f 7030 99.8% 7013 6252 761 93 m 0.2% 17 3 14 94 f 7030 99.7% 7012 6215 797 95 m 0.3% 18 3 15 96 f 7031 99.7% 7008 6212 796 97 m 0.3% 23 5 18 98 f 7032 99.7% 7012 6194 818 99 m 0.3% 20 5 15 100 f 7031 99.7% 7011 6150 861 101 m 0.3% 20 2 18 102 f 7031 99.5% 6997 6194 803 103 m 0.5% 34 8 26 104 f 7030 99.7% 7008 6204 804 105 m 0.3% 22 3 19 106 f 7031 99.8% 7017 6184 833 107 m 0.2% 14 1 13 108 f 7031 99.6% 7006 6149 857 109 m 0.4% 25 7 18 110 f 7031 99.6% 7000 6193 807 111 m 0.4% 31 6 25 112 f 7031 99.7% 7008 6182 826 113 m 0.3% 23 3 20 114 f 7031 99.9% 7021 6172 849 115 m 0.1% 10 2 8 116 f 7031 99.8% 7015 6188 827 117 m 0.2% 16 5 11 118 f 7031 99.7% 7010 6144 866 119 m 0.3% 21 3 18 120 f 7031 99.5% 6993 6174 819 121 m 0.5% 38 12 26 122 f 7032 99.5% 6997 6183 814 123 m 0.5% 35 9 26 124 f 7031 99.7% 7008 6178 830 125 m 0.3% 23 3 20 126 f 7031 99.6% 7003 6153 850 127 m 0.4% 28 7 21 128 f 7031 99.9% 7022 6224 798 129 m 0.1% 9 1 8 130 f 7032 99.6% 7006 6185 821 131 m 0.4% 26 4 22 132 f 7031 99.4% 6990 6146 844 133 m 0.6% 41 15 26 134 f 7031 99.7% 7008 6203 805 135 m 0.3% 23 2 21 136 f 7031 99.6% 7002 6176 826 137 m 0.4% 29 4 25 138 f 7031 99.7% 7009 6207 802 139 m 0.3% 22 6 16 140 f 7031 99.6% 7001 6192 809 141 m 0.4% 30 6 24 142 f 7031 99.7% 7011 6222 789 143 m 0.3% 20 4 16 144 f 7031 99.8% 7019 6215 804 145 m 0.2% 12 2 10 146 f 7031 99.7% 7009 6200 809 147 m 0.3% 22 3 19 148 f 7030 99.8% 7014 6217 797 149 m 0.2% 16 4 12 150 f 7031 99.5% 6999 6182 817 151 m 0.5% 32 6 26 152 f 7032 99.8% 7018 6224 794 153 m 0.2% 14 2 12 154 f 7031 99.8% 7018 6181 837 155 m 0.2% 13 4 9 156 f 7031 99.7% 7011 6223 788 157 m 0.3% 20 2 18 158 f 7029 99.7% 7009 6144 865 159 m 0.3% 20 0 20 160 f 7031 99.7% 7011 6181 830 161 m 0.3% 20 1 19 162 f 7031 99.6% 7005 6189 816 163 m 0.4% 26 6 20 164 f 7031 99.7% 7013 6197 816 165 m 0.3% 18 2 16 166 f 7031 99.7% 7013 6170 843 167 m 0.3% 18 3 15 168 f 7032 99.6% 7004 6164 840 169 m 0.4% 28 5 23 170 f 7030 99.7% 7008 6160 848 171 m 0.3% 22 4 18 172 f 7031 99.6% 7006 6204 802 173 m 0.4% 25 6 19 174 f 7033 99.7% 7013 6194 819 175 m 0.3% 20 1 19 176 f 7031 99.7% 7012 6196 816 177 m 0.3% 19 8 11 178 f 7031 99.7% 7009 6188 821 179 m 0.3% 22 4 18 180 f 7032 99.6% 7005 6218 787 181 m 0.4% 27 5 22 182 f 7031 99.7% 7007 6228 779 183 m 0.3% 24 3 21 184 f 7031 99.7% 7009 6200 809 185 m 0.3% 22 7 15 186 f 7031 99.7% 7011 6229 782 187 m 0.3% 20 4 16 188 f 7031 99.7% 7010 6194 816 189 m 0.3% 21 7 14 190 f 7032 99.7% 7011 6201 810 191 m 0.3% 21 3 18 192 f 7032 99.7% 7009 6227 782 193 m 0.3% 23 3 20 194 f 7032 99.6% 7005 6203 802 195 m 0.4% 27 2 25 196 f 7031 99.7% 7009 6191 818 197 m 0.3% 22 1 21 198 f 7031 99.8% 7014 6236 778 199 m 0.2% 17 1 16 200 f 7031 99.7% 7011 6201 810 201 m 0.3% 20 2 18 202 f 7032 99.8% 7020 6212 808 203 m 0.2% 12 3 9 204 f 7031 99.7% 7009 6196 813 205 m 0.3% 22 4 18 206 f 7031 99.5% 6993 6173 820 207 m 0.5% 38 12 26 208 f 7030 99.7% 7006 6159 847 209 m 0.3% 24 4 20 210 f 7032 99.7% 7010 6217 793 211 m 0.3% 22 3 19 212 f 7032 99.8% 7016 6208 808 213 m 0.2% 16 2 14 214 f 7032 99.8% 7018 6203 815 215 m 0.2% 14 2 12 216 f 7031 99.6% 7006 6165 841 217 m 0.4% 25 0 25 218 f 7031 99.7% 7008 6241 767 219 m 0.3% 23 2 21 220 f 7031 99.8% 7016 6201 815 221 m 0.2% 15 6 9 222 f 7031 99.6% 7002 6209 793 223 m 0.4% 29 6 23 224 f 7031 99.6% 7005 6220 785 225 m 0.4% 26 5 21 226 f 7031 99.7% 7013 6176 837 227 m 0.3% 18 3 15 228 f 7031 99.8% 7016 6186 830 229 m 0.2% 15 3 12 230 f 7031 99.6% 7006 6200 806 231 m 0.4% 25 3 22 232 f 7031 99.8% 7016 6231 785 233 m 0.2% 15 4 11 234 f 7031 99.8% 7014 6182 832 235 m 0.2% 17 3 14 236 f 7032 99.6% 7007 6207 800 237 m 0.4% 25 5 20 238 f 7031 99.7% 7012 6217 795 239 m 0.3% 19 6 13 240 f 7032 99.7% 7012 6181 831 241 m 0.3% 20 3 17 242 f 7031 99.7% 7011 6191 820 243 m 0.3% 20 5 15 244 f 7032 99.7% 7012 6222 790 245 m 0.3% 20 2 18 246 f 7031 99.6% 7003 6207 796 247 m 0.4% 28 4 24 248 f 7031 99.8% 7014 6213 801 249 m 0.2% 17 1 16 250 f 7031 99.5% 6999 6193 806 251 m 0.5% 32 6 26 252 f 7031 99.7% 7011 6174 837 253 m 0.3% 20 3 17 254 f 7033 99.7% 7012 6192 820 255 m 0.3% 21 7 14 2853 dirty, 899992 queued, 900000 total, 1048576 hash buckets, 2048 buffer size start clean at 1.000% (of set total) dirty, or 70 buffs dirty, stop at 0.000% db1:/ # onstat -F IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 5 days 03:39:5 4 -- 2612224 Kbytes Fg Writes LRU Writes Chunk Writes 0 9390271 1415294 address flusher state data 8a3ee630 0 I 0 = 0X0 8a3eec48 1 I 0 = 0X0 8a3ef260 2 I 0 = 0X0 8a3ef878 3 I 0 = 0X0 8a3efe90 4 I 0 = 0X0 8a3f04a8 5 I 0 = 0X0 8a3f0ac0 6 I 0 = 0X0 8a3f10d8 7 I 0 = 0X0 8a3f16f0 8 I 0 = 0X0 8a3f1d08 9 I 0 = 0X0 8a3f2320 10 I 0 = 0X0 8a3f2938 11 I 0 = 0X0 8a3f2f50 12 I 0 = 0X0 8a3f3568 13 I 0 = 0X0 8a3f3b80 14 I 0 = 0X0 8a3f4198 15 I 0 = 0X0 8a3f47b0 16 I 0 = 0X0 8a3f4dc8 17 I 0 = 0X0 8a3f53e0 18 I 0 = 0X0 8a3f59f8 19 I 0 = 0X0 8a3f6010 20 I 0 = 0X0 8a3f6628 21 I 0 = 0X0 8a3f6c40 22 I 0 = 0X0 8a3f7258 23 I 0 = 0X0 8a3f7870 24 I 0 = 0X0 8a3f7e88 25 I 0 = 0X0 8a3f84a0 26 I 0 = 0X0 8a3f8ab8 27 I 0 = 0X0 8a3f90d0 28 I 0 = 0X0 8a3f96e8 29 I 0 = 0X0 states: Exit Idle Chunk Lru db1:/ # onstat -B|tail -5 1b6502ac 0 806 5:32303318 8944a000 3 2801 0 0 0 1b650310 0 806 5:66917672 8944a800 23 890 0 0 0 1b650374 0 806 5:66954694 8944b000 24 890 0 0 0 2966 modified, 900000 total, 1048576 hash buckets, 2048 buffer size db1:/ # onstat -l IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 5 days 03:40:1 4 -- 2612224 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 4 16 937912 70282 13.34 phybegin physize phypos phyused %used 3:53 300000 249160 836 0.28 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/ io L-2 7 16 37573709 2195378 181601 17.1 12.1 Subsystem numrecs Log Space used OLDRSAM 37573709 55124208 address number flags uniqid begin size used %used 8a42ee40 7 U-B---- 138753 4:53 2500 2500 100.00 8a42ee88 8 U-B---- 138754 4:2553 2500 2500 100.00 8a42eed0 9 U-B---- 138755 4:5053 2500 2500 100.00 8a42ef18 1 U-B---- 138756 4:7553 2500 2500 100.00 8a42ef60 2 U-B---- 138757 4:10053 2500 2500 100.00 8a42efa8 3 U-B---- 138758 4:12553 2500 2500 100.00 8a41ec30 4 U-B---- 138759 4:15053 2500 2500 100.00 8a41ec78 5 U-B---- 138760 4:17553 2500 2500 100.00 8a41ecc0 6 U-B---- 138761 4:20053 2500 2500 100.00 8a41ed08 10 U-B---- 138762 4:22553 2500 2500 100.00 8a41ed50 11 U-B---- 138763 4:25053 2500 2500 100.00 8a41ed98 12 U-B---- 138764 4:27553 2500 2500 100.00 8a41ede0 13 U-B---- 138765 4:30053 2500 2500 100.00 8a41ee28 14 U-B---- 138766 4:32553 2500 2500 100.00 8a41ee70 15 U-B---- 138767 4:35053 2500 2500 100.00 8a41eeb8 16 U-B---- 138768 4:37553 2500 2500 100.00 8a41ef00 17 U-B---- 138769 4:40053 2500 2500 100.00 8a41ef48 18 U-B---- 138770 4:42553 2500 2500 100.00 8a41ef90 19 U-B---- 138771 4:45053 2500 2500 100.00 8a113b18 20 U-B---- 138772 4:47553 2500 2500 100.00 8a113b60 21 U-B---- 138773 4:50053 2500 2500 100.00 8a113ba8 22 U-B---- 138774 4:52553 2500 2500 100.00 8a113bf0 23 U-B---- 138775 4:55053 2500 2497 99.88 8a113c38 24 U-B---- 138776 4:57553 2500 2500 100.00 8a113c80 25 U-B---- 138777 4:60053 2500 2500 100.00 8a113cc8 26 U-B---- 138778 4:62553 2500 2500 100.00 8a113d10 27 U-B---- 138779 4:65053 2500 2500 100.00 8a113d58 28 U-B---- 138780 4:67553 2500 2500 100.00 8a113da0 29 U-B---- 138781 4:70053 2500 2500 100.00 8a113de8 30 U-B---- 138782 4:72553 2500 2500 100.00 8a113e30 31 U-B---- 138783 4:75053 2500 2500 100.00 8a113e78 32 U-B---- 138784 4:77553 2500 2500 100.00 8a113ec0 33 U-B---- 138785 4:80053 2500 2500 100.00 8a113f08 34 U-B---- 138786 4:82553 2500 2500 100.00 8a113f50 35 U-B---- 138787 4:85053 2500 2500 100.00 8a113f98 36 U-B---- 138788 4:87553 2500 2500 100.00 8ad93018 37 U-B---- 138789 4:90053 2500 2500 100.00 8ad93060 38 U-B---- 138790 4:92553 2500 2500 100.00 8ad930a8 39 U-B---- 138791 4:95053 2500 2500 100.00 8ad930f0 40 U-B---- 138792 4:97553 2500 2500 100.00 8ad93138 41 U-B---- 138793 4:100053 2500 2500 100.00 8ad93180 42 U-B---- 138794 4:102553 2500 2500 100.00 8ad931c8 43 U-B---- 138795 4:105053 2500 2500 100.00 8ad93210 44 U-B---- 138796 4:107553 2500 2500 100.00 8ad93258 45 U-B---- 138797 4:110053 2500 2500 100.00 8ad932a0 46 U-B---- 138798 4:112553 2500 2500 100.00 8ad932e8 47 U-B---- 138799 4:115053 2500 2500 100.00 8ad93330 48 U-B---- 138800 4:117553 2500 2500 100.00 8ad93378 49 U-B---- 138801 4:120053 2500 2500 100.00 8ad933c0 50 U-B---- 138802 4:122553 2500 2500 100.00 8ad93408 51 U-B---- 138803 4:125053 2500 2500 100.00 8ad93450 52 U-B---- 138804 4:127553 2500 2500 100.00 8ad93498 53 U-B---- 138805 4:130053 2500 2500 100.00 8ad934e0 54 U-B---- 138806 4:132553 2500 2500 100.00 8ad93528 55 U-B---- 138807 4:135053 2500 2500 100.00 8ad93570 56 U-B---- 138808 4:137553 2500 2500 100.00 8ad935b8 57 U-B---- 138809 4:140053 2500 2500 100.00 8ad93600 58 U-B---- 138810 4:142553 2500 2500 100.00 8ad93648 59 U-B---- 138811 4:145053 2500 2500 100.00 8ad93690 60 U-B---- 138812 4:147553 2500 2500 100.00 8ad936d8 61 U-B---- 138813 4:150053 2500 2500 100.00 8ad93720 62 U-B---- 138814 4:152553 2500 2500 100.00 8ad93768 63 U-B---- 138815 4:155053 2500 2500 100.00 8ad937b0 64 U-B---- 138816 4:157553 2500 2500 100.00 8ad937f8 65 U-B---- 138817 4:160053 2500 2500 100.00 8ad93840 66 U-B---- 138818 4:162553 2500 2500 100.00 8ad93888 67 U-B---- 138819 4:165053 2500 2500 100.00 8ad938d0 68 U-B---- 138820 4:167553 2500 2500 100.00 8ad93918 69 U-B---- 138821 4:170053 2500 2500 100.00 8ad93960 70 U-B---- 138822 4:172553 2500 2500 100.00 8ad939a8 71 U-B---- 138823 4:175053 2500 2500 100.00 8ad939f0 72 U-B---- 138824 4:177553 2500 2500 100.00 8ad93a38 73 U-B---- 138825 4:180053 2500 2500 100.00 8ad93a80 74 U-B---- 138826 4:182553 2500 2500 100.00 8ad93ac8 75 U-B---- 138827 4:185053 2500 2500 100.00 8ad93b10 76 U-B---- 138828 4:187553 2500 2500 100.00 8ad93b58 77 U-B---- 138829 4:190053 2500 2500 100.00 8ad93ba0 78 U-B---- 138830 4:192553 2500 2500 100.00 8ad93be8 79 U-B---- 138831 4:195053 2500 2500 100.00 8ad93c30 80 U-B---- 138832 4:197553 2500 2500 100.00 8ad93c78 81 U-B---- 138833 4:200053 2500 2500 100.00 8ad93cc0 82 U-B---- 138834 4:202553 2500 2500 100.00 8ad93d08 83 U-B---- 138835 4:205053 2500 2500 100.00 8ad93d50 84 U-B---- 138836 4:207553 2500 2500 100.00 8ad93d98 85 U-B---- 138837 4:210053 2500 2500 100.00 8ad93de0 86 U-B---- 138838 4:212553 2500 2500 100.00 8ad93e28 87 U-B---- 138839 4:215053 2500 2500 100.00 8ad93e70 88 U-B---- 138840 4:217553 2500 2500 100.00 8ad93eb8 89 U-B---- 138841 4:220053 2500 2500 100.00 8ad93f00 90 U-B---- 138842 4:222553 2500 2500 100.00 8ad93f48 91 U-B---- 138843 4:225053 2500 2500 100.00 8ad93f90 92 U-B---- 138844 4:227553 2500 2500 100.00 8ad94018 93 U-B---- 138845 4:230053 2500 2500 100.00 8ad94060 94 U-B---- 138846 4:232553 2500 2500 100.00 8ad940a8 95 U-B---- 138847 4:235053 2500 2500 100.00 8ad940f0 96 U-B---- 138848 4:237553 2500 2500 100.00 8ad94138 97 U-B---- 138849 4:240053 2500 2500 100.00 8ad94180 98 U-B---- 138850 4:242553 2500 2500 100.00 8ad941c8 99 U-B---- 138851 4:245053 2500 2500 100.00 8ad94210 100 U-B---- 138852 4:247553 2500 2500 100.00 8ad94258 101 U-B---- 138853 4:250053 2500 2500 100.00 8ad942a0 102 U-B---- 138854 4:252553 2500 2500 100.00 8ad942e8 103 U-B---- 138855 4:255053 2500 2500 100.00 8ad94330 104 U-B---- 138856 4:257553 2500 2500 100.00 8ad94378 105 U-B---- 138857 4:260053 2500 2500 100.00 8ad943c0 106 U-B---- 138858 4:262553 2500 2500 100.00 8ad94408 107 U-B---- 138859 4:265053 2500 2500 100.00 8ad94450 108 U-B---- 138860 4:267553 2500 2500 100.00 8ad94498 109 U-B---- 138861 4:270053 2500 2500 100.00 8ad944e0 110 U-B---- 138862 4:272553 2500 2500 100.00 8ad94528 111 U-B---- 138863 4:275053 2500 2500 100.00 8ad94570 112 U-B---- 138864 4:277553 2500 2500 100.00 8ad945b8 113 U-B---- 138865 4:280053 2500 2500 100.00 8ad94600 114 U-B---- 138866 4:282553 2500 2500 100.00 8ad94648 115 U-B---- 138867 4:285053 2500 2500 100.00 8ad94690 116 U-B---- 138868 4:287553 2500 2500 100.00 8ad946d8 117 U-B---- 138869 4:290053 2500 2500 100.00 8ad94720 118 U-B---- 138870 4:292553 2500 2500 100.00 8ad94768 119 U-B---- 138871 4:295053 2500 2500 100.00 8ad947b0 120 U-B---- 138872 4:297553 2500 2500 100.00 8ad947f8 121 U-B---- 138873 4:300053 2500 2500 100.00 8ad94840 122 U-B---- 138874 4:302553 2500 2500 100.00 8ad94888 123 U-B---- 138875 4:305053 2500 2500 100.00 8ad948d0 124 U-B---- 138876 4:307553 2500 2500 100.00 8ad94918 125 U-B---- 138877 4:310053 2500 2500 100.00 8ad94960 126 U-B---- 138878 4:312553 2500 2500 100.00 8ad949a8 127 U-B---- 138879 4:315053 2500 2500 100.00 8ad949f0 128 U-B---- 138880 4:317553 2500 2500 100.00 8ad94a38 129 U-B---- 138881 4:320053 2500 2500 100.00 8ad94a80 130 U-B---- 138882 4:322553 2500 2500 100.00 8ad94ac8 131 U-B---- 138883 4:325053 2500 2500 100.00 8ad94b10 132 U-B---- 138884 4:327553 2500 2500 100.00 8ad94b58 133 U-B---- 138885 4:330053 2500 2500 100.00 8ad94ba0 134 U-B---- 138886 4:332553 2500 2500 100.00 8ad94be8 135 U-B---- 138887 4:335053 2500 2500 100.00 8ad94c30 136 U-B---- 138888 4:337553 2500 2500 100.00 8ad94c78 137 U-B---- 138889 4:340053 2500 2500 100.00 8ad94cc0 138 U-B---- 138890 4:342553 2500 2500 100.00 8ad94d08 139 U-B---- 138891 4:345053 2500 2500 100.00 8ad94d50 140 U-B---- 138892 4:347553 2500 2500 100.00 8ad94d98 141 U-B---- 138893 4:350053 2500 2500 100.00 8ad94de0 142 U-B---- 138894 4:352553 2500 2500 100.00 8ad94e28 143 U-B---- 138895 4:355053 2500 2500 100.00 8ad94e70 144 U-B---- 138896 4:357553 2500 2500 100.00 8ad94eb8 145 U-B---- 138897 4:360053 2500 2500 100.00 8ad94f00 146 U-B---- 138898 4:362553 2500 2500 100.00 8ad94f48 147 U-B---- 138899 4:365053 2500 2500 100.00 8ad94f90 148 U-B---- 138900 4:367553 2500 2500 100.00 8ad95018 149 U-B---- 138901 4:370053 2500 2500 100.00 8ad95060 150 U-B---- 138902 4:372553 2500 2500 100.00 8ad950a8 151 U-B---- 138903 4:375053 2500 2500 100.00 8ad950f0 152 U-B---- 138904 4:377553 2500 2500 100.00 8ad95138 153 U-B---- 138905 4:380053 2500 2500 100.00 8ad95180 154 U-B---- 138906 4:382553 2500 2500 100.00 8ad951c8 155 U-B---- 138907 4:385053 2500 2500 100.00 8ad95210 156 U-B---- 138908 4:387553 2500 2500 100.00 8ad95258 157 U-B---- 138909 4:390053 2500 2500 100.00 8ad952a0 158 U-B---- 138910 4:392553 2500 2500 100.00 8ad952e8 159 U-B---- 138911 4:395053 2500 2500 100.00 8ad95330 160 U-B---- 138912 4:397553 2500 2500 100.00 8ad95378 161 U-B---- 138913 4:400053 2500 2500 100.00 8ad953c0 162 U-B---- 138914 4:402553 2500 2500 100.00 8ad95408 163 U-B---- 138915 4:405053 2500 2500 100.00 8ad95450 164 U-B---- 138916 4:407553 2500 2500 100.00 8ad95498 165 U-B---- 138917 4:410053 2500 2500 100.00 8ad954e0 166 U-B---- 138918 4:412553 2500 2500 100.00 8ad95528 167 U-B---- 138919 4:415053 2500 2500 100.00 8ad95570 168 U-B---- 138920 4:417553 2500 2500 100.00 8ad955b8 169 U-B---- 138921 4:420053 2500 2500 100.00 8ad95600 170 U-B---- 138922 4:422553 2500 2500 100.00 8ad95648 171 U-B---- 138923 4:425053 2500 2500 100.00 8ad95690 172 U-B---- 138924 4:427553 2500 2500 100.00 8ad956d8 173 U-B---- 138925 4:430053 2500 2500 100.00 8ad95720 174 U-B---- 138926 4:432553 2500 2500 100.00 8ad95768 175 U-B---- 138927 4:435053 2500 2500 100.00 8ad957b0 176 U-B---- 138928 4:437553 2500 2500 100.00 8ad957f8 177 U-B---- 138929 4:440053 2500 2500 100.00 8ad95840 178 U-B---- 138930 4:442553 2500 2500 100.00 8ad95888 179 U-B---- 138931 4:445053 2500 2500 100.00 8ad958d0 180 U-B---- 138932 4:447553 2500 2500 100.00 8ad95918 181 U-B---- 138933 4:450053 2500 2500 100.00 8ad95960 182 U-B---- 138934 4:452553 2500 2500 100.00 8ad959a8 183 U-B---- 138935 4:455053 2500 2500 100.00 8ad959f0 184 U-B---- 138936 4:457553 2500 2500 100.00 8ad95a38 185 U-B---- 138937 4:460053 2500 2500 100.00 8ad95a80 186 U-B---- 138938 4:462553 2500 2500 100.00 8ad95ac8 187 U-B---- 138939 4:465053 2500 2500 100.00 8ad95b10 188 U-B---- 138940 4:467553 2500 2500 100.00 8ad95b58 189 U-B---- 138941 4:470053 2500 2500 100.00 8ad95ba0 190 U-B---- 138942 4:472553 2500 2500 100.00 8ad95be8 191 U-B---- 138943 4:475053 2500 2494 99.76 8ad95c30 192 U-B---L 138944 4:477553 2500 2500 100.00 8ad95c78 193 U---C-- 138945 4:480053 2500 710 28.40 8ad95cc0 194 U-B---- 138545 4:482553 2500 2500 100.00 8ad95d08 195 U-B---- 138546 4:485053 2500 2500 100.00 8ad95d50 196 U-B---- 138547 4:487553 2500 2500 100.00 8ad95d98 197 U-B---- 138548 4:490053 2500 2500 100.00 8ad95de0 198 U-B---- 138549 4:492553 2500 2500 100.00 8ad95e28 199 U-B---- 138550 4:495053 2500 2500 100.00 8ad95e70 200 U-B---- 138551 4:497553 2500 2500 100.00 8ad95eb8 201 U-B---- 138552 4:500053 2500 2500 100.00 8ad95f00 202 U-B---- 138553 4:502553 2500 2500 100.00 8ad95f48 203 U-B---- 138554 4:505053 2500 2500 100.00 8ad95f90 204 U-B---- 138555 4:507553 2500 2500 100.00 8ad96018 205 U-B---- 138556 4:510053 2500 2500 100.00 8ad96060 206 U-B---- 138557 4:512553 2500 2500 100.00 8ad960a8 207 U-B---- 138558 4:515053 2500 2500 100.00 8ad960f0 208 U-B---- 138559 4:517553 2500 2500 100.00 8ad96138 209 U-B---- 138560 4:520053 2500 2500 100.00 8ad96180 210 U-B---- 138561 4:522553 2500 2500 100.00 8ad961c8 211 U-B---- 138562 4:525053 2500 2500 100.00 8ad96210 212 U-B---- 138563 4:527553 2500 2500 100.00 8ad96258 213 U-B---- 138564 4:530053 2500 2500 100.00 8ad962a0 214 U-B---- 138565 4:532553 2500 2500 100.00 8ad962e8 215 U-B---- 138566 4:535053 2500 2500 100.00 8ad96330 216 U-B---- 138567 4:537553 2500 2500 100.00 8ad96378 217 U-B---- 138568 4:540053 2500 2500 100.00 8ad963c0 218 U-B---- 138569 4:542553 2500 2500 100.00 8ad96408 219 U-B---- 138570 4:545053 2500 2500 100.00 8ad96450 220 U-B---- 138571 4:547553 2500 2500 100.00 8ad96498 221 U-B---- 138572 4:550053 2500 2500 100.00 8ad964e0 222 U-B---- 138573 4:552553 2500 2500 100.00 8ad96528 223 U-B---- 138574 4:555053 2500 2500 100.00 8ad96570 224 U-B---- 138575 4:557553 2500 2500 100.00 8ad965b8 225 U-B---- 138576 4:560053 2500 2500 100.00 8ad96600 226 U-B---- 138577 4:562553 2500 2500 100.00 8ad96648 227 U-B---- 138578 4:565053 2500 2500 100.00 8ad96690 228 U-B---- 138579 4:567553 2500 2500 100.00 8ad966d8 229 U-B---- 138580 4:570053 2500 2500 100.00 8ad96720 230 U-B---- 138581 4:572553 2500 2500 100.00 8ad96768 231 U-B---- 138582 4:575053 2500 2500 100.00 8ad967b0 232 U-B---- 138583 4:577553 2500 2500 100.00 8ad967f8 233 U-B---- 138584 4:580053 2500 2500 100.00 8ad96840 234 U-B---- 138585 4:582553 2500 2500 100.00 8ad96888 235 U-B---- 138586 4:585053 2500 2500 100.00 8ad968d0 236 U-B---- 138587 4:587553 2500 2500 100.00 8ad96918 237 U-B---- 138588 4:590053 2500 2500 100.00 8ad96960 238 U-B---- 138589 4:592553 2500 2500 100.00 8ad969a8 239 U-B---- 138590 4:595053 2500 2500 100.00 8ad969f0 240 U-B---- 138591 4:597553 2500 2500 100.00 8ad96a38 241 U-B---- 138592 4:600053 2500 2500 100.00 8ad96a80 242 U-B---- 138593 4:602553 2500 2500 100.00 8ad96ac8 243 U-B---- 138594 4:605053 2500 2500 100.00 8ad96b10 244 U-B---- 138595 4:607553 2500 2500 100.00 8ad96b58 245 U-B---- 138596 4:610053 2500 2500 100.00 8ad96ba0 246 U-B---- 138597 4:612553 2500 2500 100.00 8ad96be8 247 U-B---- 138598 4:615053 2500 2500 100.00 8ad96c30 248 U-B---- 138599 4:617553 2500 2500 100.00 8ad96c78 249 U-B---- 138600 4:620053 2500 2500 100.00 8ad96cc0 250 U-B---- 138601 4:622553 2500 2500 100.00 8ad96d08 251 U-B---- 138602 4:625053 2500 2500 100.00 8ad96d50 252 U-B---- 138603 4:627553 2500 2500 100.00 8ad96d98 253 U-B---- 138604 4:630053 2500 2500 100.00 8ad96de0 254 U-B---- 138605 4:632553 2500 2500 100.00 8ad96e28 255 U-B---- 138606 4:635053 2500 2500 100.00 8ad96e70 256 U-B---- 138607 4:637553 2500 2500 100.00 8ad96eb8 257 U-B---- 138608 4:640053 2500 2500 100.00 8ad96f00 258 U-B---- 138609 4:642553 2500 2500 100.00 8ad96f48 259 U-B---- 138610 4:645053 2500 2500 100.00 8ad96f90 260 U-B---- 138611 4:647553 2500 2500 100.00 8ad97018 261 U-B---- 138612 4:650053 2500 2500 100.00 8ad97060 262 U-B---- 138613 4:652553 2500 2500 100.00 8ad970a8 263 U-B---- 138614 4:655053 2500 2500 100.00 8ad970f0 264 U-B---- 138615 4:657553 2500 2500 100.00 8ad97138 265 U-B---- 138616 4:660053 2500 2500 100.00 8ad97180 266 U-B---- 138617 4:662553 2500 2500 100.00 8ad971c8 267 U-B---- 138618 4:665053 2500 2500 100.00 8ad97210 268 U-B---- 138619 4:667553 2500 2500 100.00 8ad97258 269 U-B---- 138620 4:670053 2500 2500 100.00 8ad972a0 270 U-B---- 138621 4:672553 2500 2500 100.00 8ad972e8 271 U-B---- 138622 4:675053 2500 2500 100.00 8ad97330 272 U-B---- 138623 4:677553 2500 2500 100.00 8ad97378 273 U-B---- 138624 4:680053 2500 2500 100.00 8ad973c0 274 U-B---- 138625 4:682553 2500 2500 100.00 8ad97408 275 U-B---- 138626 4:685053 2500 2500 100.00 8ad97450 276 U-B---- 138627 4:687553 2500 2500 100.00 8ad97498 277 U-B---- 138628 4:690053 2500 2500 100.00 8ad974e0 278 U-B---- 138629 4:692553 2500 2500 100.00 8ad97528 279 U-B---- 138630 4:695053 2500 2500 100.00 8ad97570 280 U-B---- 138631 4:697553 2500 2500 100.00 8ad975b8 281 U-B---- 138632 4:700053 2500 2500 100.00 8ad97600 282 U-B---- 138633 4:702553 2500 2500 100.00 8ad97648 283 U-B---- 138634 4:705053 2500 2500 100.00 8ad97690 284 U-B---- 138635 4:707553 2500 2500 100.00 8ad976d8 285 U-B---- 138636 4:710053 2500 2500 100.00 8ad97720 286 U-B---- 138637 4:712553 2500 2500 100.00 8ad97768 287 U-B---- 138638 4:715053 2500 2500 100.00 8ad977b0 288 U-B---- 138639 4:717553 2500 2500 100.00 8ad977f8 289 U-B---- 138640 4:720053 2500 2500 100.00 8ad97840 290 U-B---- 138641 4:722553 2500 2500 100.00 8ad97888 291 U-B---- 138642 4:725053 2500 2500 100.00 8ad978d0 292 U-B---- 138643 4:727553 2500 2500 100.00 8ad97918 293 U-B---- 138644 4:730053 2500 2500 100.00 8ad97960 294 U-B---- 138645 4:732553 2500 2500 100.00 8ad979a8 295 U-B---- 138646 4:735053 2500 2500 100.00 8ad979f0 296 U-B---- 138647 4:737553 2500 2500 100.00 8ad97a38 297 U-B---- 138648 4:740053 2500 2500 100.00 8ad97a80 298 U-B---- 138649 4:742553 2500 2500 100.00 8ad97ac8 299 U-B---- 138650 4:745053 2500 2500 100.00 8ad97b10 300 U-B---- 138651 4:747553 2500 2500 100.00 8ad97b58 301 U-B---- 138652 4:750053 2500 2500 100.00 8ad97ba0 302 U-B---- 138653 4:752553 2500 2500 100.00 8ad97be8 303 U-B---- 138654 4:755053 2500 2500 100.00 8ad97c30 304 U-B---- 138655 4:757553 2500 2500 100.00 8ad97c78 305 U-B---- 138656 4:760053 2500 2500 100.00 8ad97cc0 306 U-B---- 138657 4:762553 2500 2500 100.00 8ad97d08 307 U-B---- 138658 4:765053 2500 2500 100.00 8ad97d50 308 U-B---- 138659 4:767553 2500 2500 100.00 8ad97d98 309 U-B---- 138660 4:770053 2500 2500 100.00 8ad97de0 310 U-B---- 138661 4:772553 2500 2500 100.00 8ad97e28 311 U-B---- 138662 4:775053 2500 2500 100.00 8ad97e70 312 U-B---- 138663 4:777553 2500 2500 100.00 8ad97eb8 313 U-B---- 138664 4:780053 2500 2500 100.00 8ad97f00 314 U-B---- 138665 4:782553 2500 2500 100.00 8ad97f48 315 U-B---- 138666 4:785053 2500 2500 100.00 8ad97f90 316 U-B---- 138667 4:787553 2500 2500 100.00 8ad98018 317 U-B---- 138668 4:790053 2500 2500 100.00 8ad98060 318 U-B---- 138669 4:792553 2500 2500 100.00 8ad980a8 319 U-B---- 138670 4:795053 2500 2500 100.00 8ad980f0 320 U-B---- 138671 4:797553 2500 2500 100.00 8ad98138 321 U-B---- 138672 4:800053 2500 2500 100.00 8ad98180 322 U-B---- 138673 4:802553 2500 2500 100.00 8ad981c8 323 U-B---- 138674 4:805053 2500 2500 100.00 8ad98210 324 U-B---- 138675 4:807553 2500 2500 100.00 8ad98258 325 U-B---- 138676 4:810053 2500 2500 100.00 8ad982a0 326 U-B---- 138677 4:812553 2500 2500 100.00 8ad982e8 327 U-B---- 138678 4:815053 2500 2500 100.00 8ad98330 328 U-B---- 138679 4:817553 2500 2500 100.00 8ad98378 329 U-B---- 138680 4:820053 2500 2500 100.00 8ad983c0 330 U-B---- 138681 4:822553 2500 2500 100.00 8ad98408 331 U-B---- 138682 4:825053 2500 2500 100.00 8ad98450 332 U-B---- 138683 4:827553 2500 2500 100.00 8ad98498 333 U-B---- 138684 4:830053 2500 2500 100.00 8ad984e0 334 U-B---- 138685 4:832553 2500 2500 100.00 8ad98528 335 U-B---- 138686 4:835053 2500 2500 100.00 8ad98570 336 U-B---- 138687 4:837553 2500 2500 100.00 8ad985b8 337 U-B---- 138688 4:840053 2500 2500 100.00 8ad98600 338 U-B---- 138689 4:842553 2500 2500 100.00 8ad98648 339 U-B---- 138690 4:845053 2500 2500 100.00 8ad98690 340 U-B---- 138691 4:847553 2500 2500 100.00 8ad986d8 341 U-B---- 138692 4:850053 2500 2500 100.00 8ad98720 342 U-B---- 138693 4:852553 2500 2500 100.00 8ad98768 343 U-B---- 138694 4:855053 2500 2500 100.00 8ad987b0 344 U-B---- 138695 4:857553 2500 2500 100.00 8ad987f8 345 U-B---- 138696 4:860053 2500 2500 100.00 8ad98840 346 U-B---- 138697 4:862553 2500 2500 100.00 8ad98888 347 U-B---- 138698 4:865053 2500 2500 100.00 8ad988d0 348 U-B---- 138699 4:867553 2500 2500 100.00 8ad98918 349 U-B---- 138700 4:870053 2500 2500 100.00 8ad98960 350 U-B---- 138701 4:872553 2500 2500 100.00 8ad989a8 351 U-B---- 138702 4:875053 2500 2500 100.00 8ad989f0 352 U-B---- 138703 4:877553 2500 2500 100.00 8ad98a38 353 U-B---- 138704 4:880053 2500 2500 100.00 8ad98a80 354 U-B---- 138705 4:882553 2500 2500 100.00 8ad98ac8 355 U-B---- 138706 4:885053 2500 2500 100.00 8ad98b10 356 U-B---- 138707 4:887553 2500 2500 100.00 8ad98b58 357 U-B---- 138708 4:890053 2500 2500 100.00 8ad98ba0 358 U-B---- 138709 4:892553 2500 2500 100.00 8ad98be8 359 U-B---- 138710 4:895053 2500 2500 100.00 8ad98c30 360 U-B---- 138711 4:897553 2500 2500 100.00 8ad98c78 361 U-B---- 138712 4:900053 2500 2500 100.00 8ad98cc0 362 U-B---- 138713 4:902553 2500 2500 100.00 8ad98d08 363 U-B---- 138714 4:905053 2500 2500 100.00 8ad98d50 364 U-B---- 138715 4:907553 2500 2500 100.00 8ad98d98 365 U-B---- 138716 4:910053 2500 2500 100.00 8ad98de0 366 U-B---- 138717 4:912553 2500 2500 100.00 8ad98e28 367 U-B---- 138718 4:915053 2500 2500 100.00 8ad98e70 368 U-B---- 138719 4:917553 2500 2500 100.00 8ad98eb8 369 U-B---- 138720 4:920053 2500 2500 100.00 8ad98f00 370 U-B---- 138721 4:922553 2500 2500 100.00 8ad98f48 371 U-B---- 138722 4:925053 2500 2500 100.00 8ad98f90 372 U-B---- 138723 4:927553 2500 2500 100.00 8ad99018 373 U-B---- 138724 4:930053 2500 2500 100.00 8ad99060 374 U-B---- 138725 4:932553 2500 2500 100.00 8ad990a8 375 U-B---- 138726 4:935053 2500 2500 100.00 8ad990f0 376 U-B---- 138727 4:937553 2500 2500 100.00 8ad99138 377 U-B---- 138728 4:940053 2500 2500 100.00 8ad99180 378 U-B---- 138729 4:942553 2500 2500 100.00 8ad991c8 379 U-B---- 138730 4:945053 2500 2500 100.00 8ad99210 380 U-B---- 138731 4:947553 2500 2500 100.00 8ad99258 381 U-B---- 138732 4:950053 2500 2500 100.00 8ad992a0 382 U-B---- 138733 4:952553 2500 2500 100.00 8ad992e8 383 U-B---- 138734 4:955053 2500 2500 100.00 8ad99330 384 U-B---- 138735 4:957553 2500 2500 100.00 8ad99378 385 U-B---- 138736 4:960053 2500 2500 100.00 8ad993c0 386 U-B---- 138737 4:962553 2500 2500 100.00 8ad99408 387 U-B---- 138738 4:965053 2500 2500 100.00 8ad99450 388 U-B---- 138739 4:967553 2500 2500 100.00 8ad99498 389 U-B---- 138740 4:970053 2500 2500 100.00 8ad994e0 390 U-B---- 138741 4:972553 2500 2500 100.00 8ad99528 391 U-B---- 138742 4:975053 2500 2500 100.00 8ad99570 392 U-B---- 138743 4:977553 2500 2500 100.00 8ad995b8 393 U-B---- 138744 4:980053 2500 2500 100.00 8ad99600 394 U-B---- 138745 4:982553 2500 2500 100.00 8ad99648 395 U-B---- 138746 4:985053 2500 2500 100.00 8ad99690 396 U-B---- 138747 4:987553 2500 2500 100.00 8ad996d8 397 U-B---- 138748 4:990053 2500 2500 100.00 8ad99720 398 U-B---- 138749 4:992553 2500 2500 100.00 8ad99768 399 U-B---- 138750 4:995053 2500 2500 100.00 8ad997b0 400 U-B---- 138751 4:997553 2500 2500 100.00 8ad997f8 401 U-B---- 138752 4:1000053 2500 2500 100.00 401 active, 401 total onconfig: # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/informix/rootdb # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 500000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS dbplog # Location (dbspace) of physical log PHYSFILE 600000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 401 # Number of logical log files LOGSIZE 5000 # Logical log size (Kbytes) LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT) # Security # DBCREATE_PERMISSION: # By default any user can create a database. Uncomment DBCREATE_PERMISSON to # limit database creation to a specific user. Add a new DBCREATE_PERMISSION # line for each permitted user. #DBCREATE_PERMISSION informix # Diagnostics MSGPATH /u/informix/online.log # System message log file path CONSOLE /dev/console # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y #ALARMPROGRAM /u/informix/etc/alarmprogram.sh # Alarm program path ALARMPROGRAM /usr/local/bin/eventalarm TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/rmt/0 # Tape device path #TAPEDEV /dev/null # Tape device path TAPEBLK 1024 # Tape block size (Kbytes) TAPESIZE 500000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/null # Log tape device path LTAPEBLK 32 # Log tape block size (Kbytes) LTAPESIZE 2000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLine instance DBSERVERNAME db1 # Name of default database server DBSERVERALIASES db1_net # List of alternate dbservernames NETTYPE ipcshm,3,200,CPU # Configure poll thread(s) for nettype NETTYPE tlitcp,3,130,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi- processor NUMCPUVPS 7 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 2000000 # Maximum number of locks BUFFERS 900000 # Maximum number of shared buffers NUMAIOVPS 7 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) CLEANERS 30 # Number of buffer cleaner processes SHMBASE 0xa000000 # Shared memory base address #SHMVIRTSIZE 393222 # initial virtual shared memory segment size SHMVIRTSIZE 505856 # initial virtual shared memory segment size #SHMADD 98304 # Size of new shared memory segments (Kbytes) SHMADD 153600 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments ( Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 600 # Check point interval (in sec) LRUS 128 # Number of LRU queues LRU_MAX_DIRTY 1.000000 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 0.000000 # LRU percent dirty end cleaning limit TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) # Dynamic Logging # DYNAMIC_LOGS: # 2 : server automatically add a new logical log when necessary. (ON) # 1 : notify DBA to add new logical logs when necessary. (ON) # 0 : cannot add logical log on the fly. (OFF) # # When dynamic logging is on, we can have higher values for LTXHWM/ LTXEHWM, # because the server can add new logical logs during long transaction rollback. # However, to limit the number of new logical logs being added, LTXHWM/ LTXEHWM # can be set to smaller values. # # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values # to avoid long transaction rollback hanging the server due to lack of logical # log space, i.e. 50/60 or lower. # # In case of system configured with CDR the difference between LTXHWM and # LTXEHWM should be atleast 30% so that we could minimize log overrun issue. DYNAMIC_LOGS 2 LTXHWM 70 LTXEHWM 80 # System Page Size # BUFFSIZE - OnLine no longer supports this configuration parameter. # To determine the page size used by OnLine on your platform # see the last line of output from the command, 'onstat - b'. # Recovery Variables # OFF_RECVRY_THREADS: # Number of parallel worker threads during fast recovery or an offline restore. # ON_RECVRY_THREADS: # Number of parallel worker threads during an online restore. OFF_RECVRY_THREADS 10 # Default number of offline worker threads ON_RECVRY_THREADS 1 # Default number of online worker threads # Data Replication Variables DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND /u/informix/etc/dr.lostfound # DR lost+found file path # CDR Variables CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu- vp,additional) CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds) CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kb ytes) CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 ma x) CDR_SERIAL 0,0 # Serial Column Sequence CDR_DBSPACE # dbspace for syscdr database CDR_QHDR_DBSPACE # CDR queue dbspace (default same as catalog) CDR_QDATA_SBSPACE # List of CDR queue smart blob spaces # CDR_MAX_DYNAMIC_LOGS # -1 => unlimited # 0 => disable dynamic log addition # >0 => limit the no. of dynamic log additions with the specified value. # Max dynamic log requests that CDR can make within one server session. CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by default # Backup/Restore variables BAR_ACT_LOG /u/informix/bar_act.log # ON-Bar Log file - not in / tmp please BAR_DEBUG_LOG /u/informix/bar_dbug.log # ON-Bar Debug Log - not in / tmp please BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE on BAR_PROGRESS_FREQ 0 # Informix Storage Manager variables ISM_DATA_POOL ISMData ISM_LOG_POOL ISMLogs # Read Ahead Variables RA_PAGES # Number of pages to attempt to read ahead RA_THRESHOLD # Number of pages left before next group # DBSPACETEMP: # OnLine equivalent of DBTEMP for SE. This is the list of dbspaces # that the OnLine SQL Engine will use to create temp tables etc. # If specified it must be a colon separated list of dbspaces that exist # when the OnLine system is brought online. If not specified, or if # all dbspaces specified are invalid, various ad hoc queries will create # temporary files in /tmp instead. DBSPACETEMP dbtmp # Default temp dbspaces # DUMP*: # The following parameters control the type of diagnostics information which # is preserved when an unanticipated error condition (assertion failure) occurs # during OnLine operations. # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No. DUMPDIR /u/informix/tmp # Preserve diagnostics in this directory DUMPSHMEM 1 # Dump a copy of shared memory DUMPGCORE 0 # Dump a core image using 'gcore' DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine) DUMPCNT 1 # Number of shared memory or gcore dumps for # a single user's session FILLFACTOR 90 # Fill factor for building indexes # method for OnLine to use when determining current time USEOSTIME 0 # 0: use internal time(fast), 1: get time from O S(slow) # Parallel Database Queries (pdq) MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority DS_MAX_QUERIES # Maximum number of decision support queries DS_TOTAL_MEMORY # Decision support memory (Kbytes) DS_MAX_SCANS 1048576 # Maximum number of decision support scans DATASKIP off # List of dbspaces to skip # OPTCOMPIND # 0 => Nested loop joins will be preferred (where # possible) over sortmerge joins and hash joins. # 1 => If the transaction isolation mode is not # "repeatable read", optimizer behaves as in (2) # below. Otherwise it behaves as in (0) above. # 2 => Use costs regardless of the transaction isolation # mode. Nested loop joins are not necessarily # preferred. Optimizer bases its decision purely # on costs. OPTCOMPIND 0 # To hint the optimizer DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0) ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT OPCACHEMAX 0 # Maximum optical cache size (Kbytes) # HETERO_COMMIT (Gateway participation in distributed transactions) # 1 => Heterogeneous Commit is enabled # 0 (or any other value) => Heterogeneous Commit is disabled HETERO_COMMIT 0 # When loading a (C or C++) shared object (for a UDR or UDT), IDS checks that # the user-specified path starts with one of the directory prefixes listed in # the comma-separated list of prefixes in DB_LIBRARY_PATH # DB_LIBRARY_PATH /usr/informix/extend SBSPACENAME # Default smartblob space name - this is where b lobs # go if no sbspace is specified when the smartblob is # created. It is also used by some datablades as # the location to put their smartblobs. SYSSBSPACENAME # Default smartblob space for use by the Informi x # Server. This is used primarily for Informix Server # system statistics collection. BLOCKTIMEOUT 3600 # Default timeout for system block SYSALARMPROGRAM /u/informix/etc/evidence.sh # System A |
Enable EMail Alerts
Start New Thread