Blocked:CKPT

Hello IDS 11.10.FC2W3 on solaris 10 I was hoping not to see Blocked:CKPT with IDS 11.10.FC2 but.... Doing a import activity using HPL and for last 3 hrs seeing this Blocked:CKPT VPCLASS cpu,num=4,max=4,noage ( i guess toooo less for a hectic import) Here is the stack IBM Informix Dynamic Server Version 11.10.FC2W3 -- On-Line (CKPT REQ) -- Up 02:58:07 -- 3269632 KbytesBlocked:CKPT Stack for thread: 13 main_loop()base: 0x0000000194bb1000 len: 69632 pc: 0x0000000100a01620 tos: 0x0000000194bc0731 state: sleeping vp: 5 0x100a01620 oninit :: yield_processor_mvp + 0x608 sp=0x194bc0f30(0x194bb0028, 0x101000, 0x10124a, 0x50, 0x10124a000, 0x101242228) 0x1009f6014 oninit :: mt_yield + 0x35c sp=0x194bc1060 delta_sp=304(0x101240, 0xffffffffffffff9d, 0x194f84868, 0x101000, 0x1, 0x100fd9be0) 0x10073ae94 oninit :: wait4critex + 0x260 sp=0x194bc1110 delta_sp=176(0x1, 0x1f3, 0x4db87d, 0x10ba1b800, 0x10baa0ab0, 0x1f4) 0x1006d3094 oninit :: checkpoint + 0x214 sp=0x194bc11d0 delta_sp=192(0xcf63a2a930, 0x10ba1b800, 0x10baa3748, 0x10baa3c98, 0x193bcac08, 0x3000) 0x1000fd86c oninit :: main_loop + 0x2e74 sp=0x194bc1400 delta_sp=560(0x0, 0x340, 0x10ba1b800, 0x10baa5c90, 0x10baa2348, 0x5ad) 0x100a0247c oninit :: startup + 0xa8 sp=0x194bc1e50 delta_sp=2640(0x101000, 0x193bd2c98, 0x101218fb8, 0x1000fa9f8, 0x10124aee0, 0x101218) Sure some thing is there in the critical section,but now what to do??? Should i wait for the checkpoint event to complete ( i guess it will complete eventually). here are some lines of onstat -g ckp AUTO_CKPTS=On RTO_SERVER_RESTART=Off . . Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 4061 612 6 618 877 0 Pls help !! Regards vikas

Hello, Again the same issue , This time i have increased the number of CPU VP's to 8. but again facing this Blocked CKPT. Pls any advice would be helpfull.

Has nothing to do with CPU VPs. Are your logical logs being backed up frequently enough? What does onstat -l show? Post the output if you are not sure. Unless almost all of the logical logs have a 'B' in the flags column, you need to run ontape -a or onbar -l to archive your logical logs and free them for reuse. Art On Tue, Jul 15, 2008 at 8:06 AM, VIKAS HIVARKAR <vikas.hivarkar@tcs.com> wrote: > Hello, > > Again the same issue , This time i have increased the number of CPU VP's to > 8. > > but again facing this Blocked CKPT. > > Pls any advice would be helpfull. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

The LTAPEDEV is set to LTAPEDEV /dev/null IBM Informix Dynamic Server Version 11.10.FC2W3 -- On-Line (CKPT REQ) -- Up 04:04:55 -- 3269632 KbytesBlocked:CKPT Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 64 2212537 37249 59.40 phybegin physize phypos phyused %used 4:53 990000 289135 44303 4.48 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-3 0 64 2783918 181922 23548 15.3 7.7 Subsystem numrecs Log Space used OLDRSAM 2781554 346946032 HA 2364 85104 address number flags uniqid begin size used %used 195006528 13 U-B---- 1211 5:53 10000 10000 100.00 195006590 14 U-B---- 1212 5:10053 10000 10000 100.00 1950065f8 15 U-B---- 1213 5:20053 10000 10000 100.00 195006660 16 U-B---- 1214 5:30053 10000 10000 100.00 1950066c8 17 U-B---- 1215 5:40053 10000 10000 100.00 195006730 18 U-B---- 1216 5:50053 10000 10000 100.00 195006798 19 U-B---- 1217 5:60053 10000 10000 100.00 195006800 20 U-B---- 1218 5:70053 10000 10000 100.00 195006868 21 U-B---- 1219 5:80053 10000 10000 100.00 1950068d0 22 U-B---- 1220 5:90053 10000 10000 100.00 195006938 23 U-B---- 1221 5:100053 10000 10000 100.00 1950069a0 24 U-B---- 1222 5:110053 10000 10000 100.00 195006a08 25 U-B---- 1223 5:120053 10000 10000 100.00 195006a70 26 U-B---- 1224 5:130053 10000 10000 100.00 195006ad8 27 U-B---- 1225 5:140053 10000 10000 100.00 195006b40 28 U-B---- 1226 5:150053 10000 10000 100.00 195006ba8 29 U-B---- 1227 5:160053 10000 10000 100.00 195006c10 30 U-B---- 1228 5:170053 10000 10000 100.00 195006c78 31 U-B---- 1229 5:180053 10000 10000 100.00 195006ce0 32 U-B---- 1230 5:190053 10000 10000 100.00 195006d48 33 U-B---- 1231 5:200053 10000 10000 100.00 195006db0 34 U-B---- 1232 5:210053 10000 10000 100.00 195006e18 35 U-B---- 1233 5:220053 10000 10000 100.00 195006e80 36 U-B---- 1234 5:230053 10000 10000 100.00 195006ee8 37 U-B---- 1235 5:240053 10000 10000 100.00 195006f50 38 U-B---- 1236 5:250053 10000 10000 100.00 195006fb8 39 U-B---- 1237 5:260053 10000 10000 100.00 193d80f78 40 U-B---- 1238 5:270053 10000 10000 100.00 193fd2f50 41 U-B---- 1239 5:280053 10000 10000 100.00 193fd2fb8 42 U-B---- 1240 5:290053 10000 10000 100.00 193fbbf50 43 U-B---- 1241 5:300053 10000 10000 100.00 193fbbfb8 44 U-B---- 1242 5:310053 10000 10000 100.00 195095028 45 U-B---- 1243 5:320053 10000 10000 100.00 195095090 46 U-B---- 1244 5:330053 10000 10000 100.00 1950950f8 47 U-B---- 1245 5:340053 10000 10000 100.00 195095160 48 U-B---- 1246 5:350053 10000 10000 100.00 1950951c8 49 U-B---- 1247 5:360053 10000 10000 100.00 195095230 50 U-B---- 1248 5:370053 10000 10000 100.00 195095298 51 U-B---- 1249 5:380053 10000 10000 100.00 195095300 52 U-B---- 1250 5:390053 10000 10000 100.00 195095368 53 U-B---- 1251 5:400053 10000 10000 100.00 1950953d0 54 U-B---- 1252 5:410053 10000 10000 100.00 195095438 55 U-B---- 1253 5:420053 10000 10000 100.00 1950954a0 56 U-B---- 1254 5:430053 10000 10000 100.00 195095508 57 U-B---- 1255 5:440053 10000 10000 100.00 195095570 58 U-B---- 1256 5:450053 10000 10000 100.00 1950955d8 59 U-B---- 1257 5:460053 10000 10000 100.00 195095640 60 U-B---- 1258 5:470053 10000 10000 100.00 1950956a8 61 U-B---- 1259 5:480053 10000 10000 100.00 195095710 62 U-B---- 1260 5:490053 10000 10000 100.00 195095778 63 U-B---- 1261 5:500053 10000 10000 100.00 1950957e0 64 U-B---- 1262 5:510053 10000 10000 100.00 195095848 65 U-B---- 1263 5:520053 10000 10000 100.00 1950958b0 66 U-B---- 1264 5:530053 10000 10000 100.00 195095918 67 U-B---- 1265 5:540053 10000 10000 100.00 195095980 68 U-B---- 1266 5:550053 10000 10000 100.00 1950959e8 69 U-B---- 1267 5:560053 10000 10000 100.00 195095a50 70 U-B---- 1268 5:570053 10000 10000 100.00 195095ab8 71 U-B---- 1269 5:580053 10000 10000 100.00 195095b20 72 U-B---- 1270 5:590053 10000 10000 100.00 195095b88 73 U-B---- 1271 5:600053 10000 10000 100.00 195095bf0 74 U-B---- 1272 5:610053 10000 10000 100.00 195095c58 75 U-B---- 1273 5:620053 10000 10000 100.00 195095cc0 76 U-B---- 1274 5:630053 10000 10000 100.00 stdin 195095d28 77 U-B---- 1275 5:640053 10000 10000 100.00 195095d90 78 U-B---- 1276 5:650053 10000 10000 100.00 195095df8 79 U-B---- 1277 5:660053 10000 10000 100.00 195095e60 80 U-B---- 1278 5:670053 10000 10000 100.00 195095ec8 81 U-B---- 1279 5:680053 10000 10000 100.00 195095f30 82 U-B---- 1280 5:690053 10000 10000 100.00 195095f98 83 U-B---- 1281 5:700053 10000 10000 100.00 195096028 84 U-B---- 1282 5:710053 10000 10000 100.00 195096090 85 U-B---- 1283 5:720053 10000 10000 100.00 1950960f8 86 U-B---- 1284 5:730053 10000 10000 100.00 195096160 87 U-B---- 1285 5:740053 10000 10000 100.00 1950961c8 88 U-B---- 1286 5:750053 10000 10000 100.00 195096230 89 U-B---- 1287 5:760053 10000 10000 100.00 195096298 90 U-B---- 1288 5:770053 10000 10000 100.00 195096300 91 U-B---- 1289 5:780053 10000 10000 100.00 195096368 92 U-B---- 1290 5:790053 10000 10000 100.00 1950963d0 93 U-B---- 1291 5:800053 10000 10000 100.00 195096438 94 U-B---- 1292 5:810053 10000 10000 100.00 1950964a0 95 U-B---- 1293 5:820053 10000 10000 100.00 195096508 96 U-B---- 1294 5:830053 10000 10000 100.00 195096570 97 U-B---- 1295 5:840053 10000 10000 100.00 1950965d8 98 U-B---- 1296 5:850053 10000 10000 100.00 195096640 99 U-B---- 1297 5:860053 10000 10000 100.00 1950966a8 100 U-B---- 1298 5:870053 10000 10000 100.00 195096710 101 U-B---- 1299 5:880053 10000 10000 100.00 195096778 102 U-B---- 1300 5:890053 10000 10000 100.00 1950967e0 103 U-B---- 1301 5:900053 10000 10000 100.00 195096848 104 U-B---- 1302 5:910053 10000 10000 100.00 1950968b0 105 U-B---- 1303 5:920053 10000 10000 100.00 195096918 106 U-B---- 1304 5:930053 10000 10000 100.00 195096980 107 U-B---- 1305 5:940053 10000 10000 100.00 1950969e8 108 U-B---- 1306 5:950053 10000 10000 100.00 195096a50 109 U-B---- 1307 5:960053 10000 10000 100.00 195096ab8 110 U-B---- 1308 5:970053 10000 10000 100.00 195096b20 111 U-B---- 1309 5:980053 10000 10000 100.00 195096b88 112 U-B---- 1310 5:990053 10000 10000 100.00 195096bf0 113 U-B---- 1311 5:1000053 10000 10000 100.00 195096c58 114 U-B---- 1312 5:1010053 10000 10000 100.00 195096cc0 115 U-B---- 1313 5:1020053 10000 10000 100.00 195096d28 116 U-B---- 1314 5:1030053 10000 10000 100.00 195096d90 117 U-B---- 1315 5:1040053 10000 10000 100.00 stdin 195096df8 118 U-B---- 1316 5:1050053 10000 10000 100.00 195096e60 119 U-B---- 1317 5:1060053 10000 10000 100.00 195096ec8 120 U-B---- 1318 5:1070053 10000 10000 100.00 195096f30 121 U-B---- 1319 5:1080053 10000 10000 100.00 195096f98 122 U-B---- 1320 5:1090053 10000 10000 100.00 195097028 123 U-B---- 1321 5:1100053 10000 10000 100.00 195097090 124 U-B---- 1322 5:1110053 10000 10000 100.00 1950970f8 125 U-B---- 1323 5:1120053 10000 10000 100.00 195097160 126 U-B---- 1324 5:1130053 10000 10000 100.00 1950971c8 127 U-B---- 1325 5:1140053 10000 10000 100.00 195097230 128 U-B---- 1326 5:1150053 10000 10000 100.00 195097298 129 U-B---- 1327 5:1160053 10000 10000 100.00 195097300 130 U-B---- 1328 5:1170053 10000 10000 100.00 195097368 131 U-B---- 1329 5:1180053 10000 10000 100.00 1950973d0 132 U-B---- 1330 5:1190053 10000 10000 100.00 195097438 133 U-B---- 1331 5:1200053 10000 10000 1

PLEASE always include the post to which you are replying. I happen to remember what you are talking about and that this is a response to me, but anyone following this using the email gateway or perusing the archives may not know what's happening. Hmm. OK, so not blocked on logs. What does the message log say? Any notes in there? (onstat -m or read through the file). Art On Tue, Jul 15, 2008 at 8:43 AM, VIKAS HIVARKAR <vikas.hivarkar@tcs.com> wrote: > The LTAPEDEV is set to > LTAPEDEV /dev/null> > IBM Informix Dynamic Server Version 11.10.FC2W3 -- On-Line (CKPT REQ) -- Up > 04:04:55 -- 3269632 Kbytes> Blocked:CKPT > > Physical Logging > Buffer bufused bufsize numpages numwrits pages/io > P-1 0 64 2212537 37249 59.40 > > phybegin physize phypos phyused %used > > 4:53 990000 289135 44303 4.48 > > Logical Logging > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io > L-3 0 64 2783918 181922 23548 15.3 7.7 > > Subsystem numrecs Log Space used > > OLDRSAM 2781554 346946032 > > HA 2364 85104 > > address number flags uniqid begin size used %used > 195006528 13 U-B---- 1211 5:53 10000 10000 100.00 > 195006590 14 U-B---- 1212 5:10053 10000 10000 100.00 > 1950065f8 15 U-B---- 1213 5:20053 10000 10000 100.00 > 195006660 16 U-B---- 1214 5:30053 10000 10000 100.00 > 1950066c8 17 U-B---- 1215 5:40053 10000 10000 100.00 > 195006730 18 U-B---- 1216 5:50053 10000 10000 100.00 > 195006798 19 U-B---- 1217 5:60053 10000 10000 100.00 > 195006800 20 U-B---- 1218 5:70053 10000 10000 100.00 > 195006868 21 U-B---- 1219 5:80053 10000 10000 100.00 > 1950068d0 22 U-B---- 1220 5:90053 10000 10000 100.00 > 195006938 23 U-B---- 1221 5:100053 10000 10000 100.00 > 1950069a0 24 U-B---- 1222 5:110053 10000 10000 100.00 > 195006a08 25 U-B---- 1223 5:120053 10000 10000 100.00 > 195006a70 26 U-B---- 1224 5:130053 10000 10000 100.00 > 195006ad8 27 U-B---- 1225 5:140053 10000 10000 100.00 > 195006b40 28 U-B---- 1226 5:150053 10000 10000 100.00 > 195006ba8 29 U-B---- 1227 5:160053 10000 10000 100.00 > 195006c10 30 U-B---- 1228 5:170053 10000 10000 100.00 > 195006c78 31 U-B---- 1229 5:180053 10000 10000 100.00 > 195006ce0 32 U-B---- 1230 5:190053 10000 10000 100.00 > 195006d48 33 U-B---- 1231 5:200053 10000 10000 100.00 > 195006db0 34 U-B---- 1232 5:210053 10000 10000 100.00 > 195006e18 35 U-B---- 1233 5:220053 10000 10000 100.00 > 195006e80 36 U-B---- 1234 5:230053 10000 10000 100.00 > 195006ee8 37 U-B---- 1235 5:240053 10000 10000 100.00 > 195006f50 38 U-B---- 1236 5:250053 10000 10000 100.00 > 195006fb8 39 U-B---- 1237 5:260053 10000 10000 100.00 > 193d80f78 40 U-B---- 1238 5:270053 10000 10000 100.00 > 193fd2f50 41 U-B---- 1239 5:280053 10000 10000 100.00 > 193fd2fb8 42 U-B---- 1240 5:290053 10000 10000 100.00 > 193fbbf50 43 U-B---- 1241 5:300053 10000 10000 100.00 > 193fbbfb8 44 U-B---- 1242 5:310053 10000 10000 100.00 > 195095028 45 U-B---- 1243 5:320053 10000 10000 100.00 > 195095090 46 U-B---- 1244 5:330053 10000 10000 100.00 > 1950950f8 47 U-B---- 1245 5:340053 10000 10000 100.00 > 195095160 48 U-B---- 1246 5:350053 10000 10000 100.00 > 1950951c8 49 U-B---- 1247 5:360053 10000 10000 100.00 > 195095230 50 U-B---- 1248 5:370053 10000 10000 100.00 > 195095298 51 U-B---- 1249 5:380053 10000 10000 100.00 > 195095300 52 U-B---- 1250 5:390053 10000 10000 100.00 > 195095368 53 U-B---- 1251 5:400053 10000 10000 100.00 > 1950953d0 54 U-B---- 1252 5:410053 10000 10000 100.00 > 195095438 55 U-B---- 1253 5:420053 10000 10000 100.00 > 1950954a0 56 U-B---- 1254 5:430053 10000 10000 100.00 > 195095508 57 U-B---- 1255 5:440053 10000 10000 100.00 > 195095570 58 U-B---- 1256 5:450053 10000 10000 100.00 > 1950955d8 59 U-B---- 1257 5:460053 10000 10000 100.00 > 195095640 60 U-B---- 1258 5:470053 10000 10000 100.00 > 1950956a8 61 U-B---- 1259 5:480053 10000 10000 100.00 > 195095710 62 U-B---- 1260 5:490053 10000 10000 100.00 > 195095778 63 U-B---- 1261 5:500053 10000 10000 100.00 > 1950957e0 64 U-B---- 1262 5:510053 10000 10000 100.00 > 195095848 65 U-B---- 1263 5:520053 10000 10000 100.00 > 1950958b0 66 U-B---- 1264 5:530053 10000 10000 100.00 > 195095918 67 U-B---- 1265 5:540053 10000 10000 100.00 > 195095980 68 U-B---- 1266 5:550053 10000 10000 100.00 > 1950959e8 69 U-B---- 1267 5:560053 10000 10000 100.00 > 195095a50 70 U-B---- 1268 5:570053 10000 10000 100.00 > 195095ab8 71 U-B---- 1269 5:580053 10000 10000 100.00 > 195095b20 72 U-B---- 1270 5:590053 10000 10000 100.00 > 195095b88 73 U-B---- 1271 5:600053 10000 10000 100.00 > 195095bf0 74 U-B---- 1272 5:610053 10000 10000 100.00 > 195095c58 75 U-B---- 1273 5:620053 10000 10000 100.00 > 195095cc0 76 U-B---- 1274 5:630053 10000 10000 100.00 > stdin > 195095d28 77 U-B---- 1275 5:640053 10000 10000 100.00 > 195095d90 78 U-B---- 1276 5:650053 10000 10000 100.00 > 195095df8 79 U-B---- 1277 5:660053 10000 10000 100.00 > 195095e60 80 U-B---- 1278 5:670053 10000 10000 100.00 > 195095ec8 81 U-B---- 1279 5:680053 10000 10000 100.00 > 195095f30 82 U-B---- 1280 5:690053 10000 10000 100.00 > 195095f98 83 U-B---- 1281 5:700053 10000 10000 100.00 > 195096028 84 U-B---- 1282 5:710053 10000 10000 100.00 > 195096090 85 U-B---- 1283 5:720053 10000 10000 100.00 > 1950960f8 86 U-B---- 1284 5:730053 10000 10000 100.00 > 195096160 87 U-B---- 1285 5:740053 10000 10000 100.00 > 1950961c8 88 U-B---- 1286 5:750053 10000 10000 100.00 > 195096230 89 U-B---- 1287 5:760053 10000 10000 100.00 > 195096298 90 U-B---- 1288 5:770053 10000 10000 100.00 > 195096300 91 U-B---- 1289 5:780053 10000 10000 100.00 > 195096368 92 U-B---- 1290 5:790053 10000 10000 100.00 > 1950963d0 93 U-B---- 1291 5:800053 10000 10000 100.00 > 195096438 94 U-B---- 1292 5:810053 10000 10000 100.00 > 1950964a0 95 U-B---- 1293 5:820053 10000 10000 100.00 > 195096508 96 U-B---- 1294 5:830053 10000 10000 100.00 > 195096570 97 U-B---- 1295 5:840053 10000 10000 100.00 > 1950965d8 98 U-B---- 1296 5:850053 10000 10000 100.00 > 195096640 99 U-B---- 1297 5:860053 10000 10000 100.00 > 1950966a8 100 U-B---- 1298 5:870053 10000 10000 100.00 > 195096710 101 U-B---- 1299 5:880053 10000 10000 100.00 > 195096778 102 U-B---- 1300 5:890053 10000 10000 100.00 > 1950967e0 103 U-B---- 1301 5:900053 10000 10000 100.00 > 195096848 104 U-B---- 1302 5:910053 10000 10000 100.00 > 1950968b0 105 U-B---- 1303 5:920053 10000 10000 100.00 > 195096918 106 U-B---- 1304 5:930053 10000 10000 100.00 > 195096980 107 U-B---- 1305 5:940053 10000 10000 100.00 > 1950969e8 108 U-B---- 1306 5:950053 10000 10000 100.00 > 195096a50 109 U-B---- 1307 5:960053 10000 10000 100.00 > 195096ab8 110 U-B---- 1308 5:970053 10000 10000 100.00 > 195096b20 111 U-B---- 1309 5:980053 10000 10000 100.00 > 195096b88 112 U-B---- 1310 5:990053 10000 10000 100.00 > 195096bf0 113 U-B---- 1311 5:1000053 10000 10000 100.00 > 195096c58 114 U-B---- 1312 5:1010053 10000 10000 100.00 > 195096cc0 115 U-B---- 1313 5:1020053 10000 10000 100.00 > 195096d28 116 U-B---- 1314 5:1030053 10000 10000 100.00 > 195096d90 117 U-B---- 1315 5:1040053 10000 10000 100.00 > stdin > 195096df8 118 U-B---- 1316 5:1050053 10000 10000 100.00 > 195096e60 119 U-B---- 1317 5:1060053 10000 10000 100.00 > 195096ec8 120 U-B---- 1318 5:1070053 10000 10000 100.00@@N

As i am trying to import the data using HPL,got the following message in the online.log for every table. 13:42:51 Warning : The partition '0x601b2a' for the 'testdb:"informix".tran_xl' is converted from RAW to STANDARD type. This table may not be fully restored in the case of server crash. It is recommended to take a level-0 backup before you use or modify the table in a transaction. but this is the last message and since last 2 hrs no changes in the online.log I read through it but nothing different than the above msg's and the usuall. vikas >PLEASE always include the post to which you are replying. I happen to >remember what you are talking about and that this is a response to me, but >anyone following this using the email gateway or perusing the archives may >not know what's happening. >Hmm. OK, so not blocked on logs. What does the message log say? Any notes >in there? (onstat -m or read through the file). >Art

After altering back to STANDARD from RAW, you need to perform Level 0 backup, even if it is a "FAKE" one .... onbar -b -F -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of VIKAS HIVARKAR Sent: Tuesday, July 15, 2008 9:02 AM To: ids@iiug.org Subject: Re: Blocked:CKPT [12702] As i am trying to import the data using HPL,got the following message in the online.log for every table. 13:42:51 Warning : The partition '0x601b2a' for the 'testdb:"informix".tran_xl' is converted from RAW to STANDARD type. This table may not be fully restored in the case of server crash. It is recommended to take a level-0 backup before you use or modify the table in a transaction. but this is the last message and since last 2 hrs no changes in the online.log I read through it but nothing different than the above msg's and the usuall. vikas >PLEASE always include the post to which you are replying. I happen to >remember what you are talking about and that this is a response to me, but >anyone following this using the email gateway or perusing the archives may >not know what's happening. >Hmm. OK, so not blocked on logs. What does the message log say? Any notes >in there? (onstat -m or read through the file). >Art ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

That should not have caused a blocked checkpoint. Contact IBM Informix tech support. Art On Tue, Jul 15, 2008 at 10:02 AM, VIKAS HIVARKAR <vikas.hivarkar@tcs.com> wrote: > As i am trying to import the data using HPL,got the following message in > the > online.log for every table. > > 13:42:51 Warning : The partition '0x601b2a' for the > 'testdb:"informix".tran_xl' > > is converted from RAW to STANDARD type. > > This table may not be fully restored in the case of server crash. > > It is recommended to take a level-0 backup before you use or > > modify the table in a transaction. > > but this is the last message and since last 2 hrs no changes in the > online.log > I read through it but nothing different than the above msg's and the > usuall. > > vikas > > >PLEASE always include the post to which you are replying. I happen to > >remember what you are talking about and that this is a response to me, but > >anyone following this using the email gateway or perusing the archives may > >not know what's happening. > > >Hmm. OK, so not blocked on logs. What does the message log say? Any notes > >in there? (onstat -m or read through the file). > > >Art > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Hy everybody, I just can´t made a trusted conection between to linux suse 10 2.6.16.60-0.21-default . I wrote hosts.equiv hostname And I wrote .rhosts to in $HOME username hostname What Am I doing wrong ? thanks, André _________________________________________________________________ Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver offline. Conheça o MSN Mobile! http://mobile.live.com/signup/signup2.aspx?lc=pt-br