- 论坛徽章:
- 0
|
本帖最后由 H13900000000 于 2011-09-08 15:16 编辑
数据库挂起无法修复,跪求informix 修复工具:tbzone,谢谢!
相关日志:
[informix@RHEL6-32 bin]$ onstat -l
IBM Informix Dynamic Server Version 9.40.UC2 -- Fast Recovery (CKPT REQ) -- Up 00:01:10 -- 1186324 Kbytes
Blocked:CKPT
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 64 0 0 0.00
phybegin physize phypos phyused %used
3:53 900000 663118 92 0.01
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 13 64 0 0 0 0.0 0.0
Subsystem numrecs Log Space used
Buffer Waiting
Buffer ioproc flags
L-1 879a3858 0x1 0
address number flags uniqid begin size used %used
879e1ca8 6 U-B---- 4174 3:901303 250 250 100.00
879e1ce8 1 U-B---- 4175 3:900053 250 250 100.00
879e1d28 2 U-B---- 4176 3:900303 250 250 100.00
879e1d68 3 U-B---- 4177 3:900553 250 250 100.00
879e1da8 9 U-B---- 4178 3:902053 250 250 100.00
879e1de8 10 U-B---- 4179 3:902303 250 250 100.00
879e1e28 28 U-B---- 4180 3:906803 250 250 100.00
879e1e68 29 U-B---- 4181 3:907053 250 250 100.00
879e1ea8 30 U-B---- 4182 3:907303 250 250 100.00
879e1ee8 31 U-B---- 4183 3:907553 250 250 100.00
879e1f28 32 U-B---- 4184 3:907803 250 250 100.00
879e1f68 33 U-B---- 4185 3:908053 250 250 100.00
879e1fa8 34 U-B---- 4186 3:908303 250 250 100.00
8779aaf0 35 U-B---- 4187 3:908553 250 250 100.00
8779ab30 4 U-B---- 4188 3:900803 250 250 100.00
8779ab70 5 U-B---- 4189 3:901053 250 250 100.00
8779abb0 7 U-B---- 4190 3:901553 250 250 100.00
8779abf0 8 U-B---- 4191 3:901803 250 250 100.00
8779ac30 13 U-B---- 4192 3:903053 250 250 100.00
8779ac70 14 U-B---- 4193 3:903303 250 250 100.00
8779acb0 17 U-B---- 4194 3:904053 250 250 100.00
8779acf0 18 U-B---- 4195 3:904303 250 250 100.00
8779ad30 19 U-B---- 4196 3:904553 250 250 100.00
8779ad70 22 U-B---- 4197 3:905303 250 250 100.00
8779adb0 23 U-B---- 4198 3:905553 250 250 100.00
8779adf0 24 U-B---- 4199 3:905803 250 250 100.00
8779ae30 94 U-B---- 4200 3:923303 250 250 100.00
8779ae70 95 U-B---- 4201 3:923553 250 250 100.00
8779aeb0 96 U-B---- 4202 3:923803 250 250 100.00
8779aef0 97 U-B---- 4203 3:924053 250 250 100.00
8779af30 98 U-B---- 4204 3:924303 250 250 100.00
8779af70 99 U-B---- 4205 3:924553 250 250 100.00
8779afb0 100 U-B---- 4206 3:924803 250 250 100.00
879d2830 101 U-B---- 4207 3:925053 250 250 100.00
879d2870 102 U-B---- 4208 3:925303 250 250 100.00
879d28b0 103 U-B---- 4209 3:925553 250 250 100.00
879d28f0 104 U-B---- 4210 3:925803 250 250 100.00
879d2930 105 U-B---- 4211 3:926053 250 250 100.00
879d2970 25 U-B---- 4212 3:906053 250 250 100.00
879d29b0 26 U-B---- 4213 3:906303 250 250 100.00
879d29f0 116 U-B---- 4214 3:928803 250 250 100.00
879d2a30 117 U-B---- 4215 3:929053 250 250 100.00
879d2a70 118 U-B---- 4216 3:929303 250 250 100.00
879d2ab0 119 U-B---- 4217 3:929553 250 250 100.00
879d2af0 120 U-B---- 4218 3:929803 250 250 100.00
879d2b30 121 U-B---- 4219 3:930053 250 250 100.00
879d2b70 122 U-B---- 4220 3:930303 250 250 100.00
879d2bb0 123 U-B---- 4221 3:930553 250 250 100.00
879d2bf0 124 U-B---- 4222 3:930803 250 250 100.00
879d2c30 125 U-B---- 4223 3:931053 250 250 100.00
879d2c70 126 U-B---- 4224 3:931303 250 250 100.00
879d2cb0 127 U-B---- 4225 3:931553 250 250 100.00
879d2cf0 128 U-B---- 4226 3:931803 250 250 100.00
879d2d30 129 U-B---- 4227 3:932053 250 250 100.00
879d2d70 130 U-B---- 4228 3:932303 250 250 100.00
879d2db0 131 U-B---- 4229 3:932553 250 250 100.00
879d2df0 132 U-B---- 4230 3:932803 250 250 100.00
879d2e30 133 U-B---- 4231 3:933053 250 250 100.00
879d2e70 134 U-B---- 4232 3:933303 250 193 77.20
879d2eb0 135 U---C-L 4233 3:933553 250 250 100.00
879d2ef0 27 U-B---- 4099 3:906553 250 250 100.00
879d2f30 20 U-B---- 4100 3:904803 250 250 100.00
879d2f70 21 U-B---- 4101 3:905053 250 250 100.00
879d2fb0 15 U-B---- 4102 3:903553 250 250 100.00
87fa8018 16 U-B---- 4103 3:903803 250 250 100.00
87fa8058 11 U-B---- 4104 3:902553 250 250 100.00
87fa8098 12 U-B---- 4105 3:902803 250 250 100.00
87fa80d8 36 U-B---- 4106 3:908803 250 250 100.00
87fa8118 37 U-B---- 4107 3:909053 250 250 100.00
87fa8158 38 U-B---- 4108 3:909303 250 250 100.00
87fa8198 39 U-B---- 4109 3:909553 250 250 100.00
87fa81d8 40 U-B---- 4110 3:909803 250 250 100.00
87fa8218 41 U-B---- 4111 3:910053 250 250 100.00
87fa8258 54 U-B---- 4112 3:913303 250 250 100.00
87fa8298 55 U-B---- 4113 3:913553 250 250 100.00
87fa82d8 56 U-B---- 4114 3:913803 250 250 100.00
87fa8318 57 U-B---- 4115 3:914053 250 250 100.00
87fa8358 58 U-B---- 4116 3:914303 250 250 100.00
87fa8398 59 U-B---- 4117 3:914553 250 250 100.00
87fa83d8 79 U-B---- 4118 3:919553 250 250 100.00
87fa8418 80 U-B---- 4119 3:919803 250 250 100.00
87fa8458 81 U-B---- 4120 3:920053 250 250 100.00
87fa8498 82 U-B---- 4121 3:920303 250 250 100.00
87fa84d8 83 U-B---- 4122 3:920553 250 250 100.00
87fa8518 84 U-B---- 4123 3:920803 250 250 100.00
87fa8558 85 U-B---- 4124 3:921053 250 250 100.00
87fa8598 86 U-B---- 4125 3:921303 250 250 100.00
87fa85d8 87 U-B---- 4126 3:921553 250 250 100.00
87fa8618 88 U-B---- 4127 3:921803 250 250 100.00
87fa8658 89 U-B---- 4128 3:922053 250 250 100.00
87fa8698 106 U-B---- 4129 3:926303 250 250 100.00
87fa86d8 107 U-B---- 4130 3:926553 250 250 100.00
87fa8718 108 U-B---- 4131 3:926803 250 250 100.00
87fa8758 109 U-B---- 4132 3:927053 250 250 100.00
87fa8798 110 U-B---- 4133 3:927303 250 250 100.00
87fa87d8 111 U-B---- 4134 3:927553 250 250 100.00
87fa8818 112 U-B---- 4135 3:927803 250 250 100.00
87fa8858 113 U-B---- 4136 3:928053 250 250 100.00
87fa8898 114 U-B---- 4137 3:928303 250 250 100.00
87fa88d8 115 U-B---- 4138 3:928553 250 250 100.00
87fa8918 90 U-B---- 4139 3:922303 250 250 100.00
87fa8958 91 U-B---- 4140 3:922553 250 250 100.00
87fa8998 92 U-B---- 4141 3:922803 250 250 100.00
87fa89d8 93 U-B---- 4142 3:923053 250 250 100.00
87fa8a18 60 U-B---- 4143 3:914803 250 250 100.00
87fa8a58 61 U-B---- 4144 3:915053 250 250 100.00
87fa8a98 62 U-B---- 4145 3:915303 250 250 100.00
87fa8ad8 63 U-B---- 4146 3:915553 250 250 100.00
87fa8b18 64 U-B---- 4147 3:915803 250 250 100.00
87fa8b58 65 U-B---- 4148 3:916053 250 250 100.00
87fa8b98 66 U-B---- 4149 3:916303 250 250 100.00
87fa8bd8 67 U-B---- 4150 3:916553 250 250 100.00
87fa8c18 70 U-B---- 4151 3:917303 250 250 100.00
87fa8c58 71 U-B---- 4152 3:917553 250 250 100.00
87fa8c98 68 U-B---- 4153 3:916803 250 250 100.00
87fa8cd8 69 U-B---- 4154 3:917053 250 250 100.00
87fa8d18 42 U-B---- 4155 3:910303 250 250 100.00
87fa8d58 43 U-B---- 4156 3:910553 250 250 100.00
87fa8d98 44 U-B---- 4157 3:910803 250 250 100.00
87fa8dd8 72 U-B---- 4158 3:917803 250 250 100.00
87fa8e18 73 U-B---- 4159 3:918053 250 250 100.00
87fa8e58 74 U-B---- 4160 3:918303 250 250 100.00
87fa8e98 75 U-B---- 4161 3:918553 250 250 100.00
87fa8ed8 76 U-B---- 4162 3:918803 250 250 100.00
87fa8f18 77 U-B---- 4163 3:919053 250 250 100.00
87fa8f58 78 U-B---- 4164 3:919303 250 250 100.00
87fa8f98 47 U-B---- 4165 3:911553 250 250 100.00
87fa8fd8 48 U-B---- 4166 3:911803 250 250 100.00
87fa9018 49 U-B---- 4167 3:912053 250 250 100.00
87fa9058 50 U-B---- 4168 3:912303 250 250 100.00
87fa9098 51 U-B---- 4169 3:912553 250 250 100.00
87fa90d8 52 U-B---- 4170 3:912803 250 250 100.00
87fa9118 53 U-B---- 4171 3:913053 250 250 100.00
87fa9158 45 U-B---- 4172 3:911053 250 250 100.00
87fa9198 46 U-B---- 4173 3:911303 250 250 100.00
135 active, 135 total
onstat -d
[informix@RHEL6-32 bin]$ onstat -d
IBM Informix Dynamic Server Version 9.40.UC2 -- Fast Recovery (CKPT REQ) -- Up 00:02:36 -- 1186324 Kbytes
Blocked:CKPT
Dbspaces
address number flags fchunk nchunks flags owner name
8779a7d8 1 0x20001 1 1 N informix rootdbs
87fa9b08 2 0x60001 2 3 N B informix datadbs
87fa9c58 3 0x20001 3 1 N informix logdbs
87fa9da8 4 0x42001 4 1 N TB informix tempdbs
880a6018 5 0x20001 7 1 N informix gapsdbs
5 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
8779a928 1 1 0 100000 97020 PO-- /dbdata/ids940data/rootdbs
87fa91d8 2 2 0 3000000 39 PO-B /dbdata/ids940data/datadbs
87fa9360 3 3 0 1000000 66197 PO-- /dbdata/ids940data/logdbs
87fa94e8 4 4 0 2000000 0 PD-B /dbdata/ids940data/tempdbs
87fa9670 5 2 0 3000000 1110489 PO-B /dbdata/ids940data/datadbs1
87fa97f8 6 2 0 1000000 999997 PO-B /dbdata/ids940data/datadbs2
87fa9980 7 5 128 500000 180538 PO-- /dbdata/ids940data/datadbsgaps
7 active, 2047 maximum
Expanded chunk capacity mode: disabled
ontape -s -L 0也不行,onmode -Z 也不行。。
加逻辑日志或扩表空间也不行。 |
|