Recent content by AndrisS

Thanks for your answers.

Please see how Account.txt file looks. 07004262890147655236 74105616281002275393260000000001007000000002000428000000002000428LHZB ATMH0418 - Limbaz Limbazi LV 6011 1009N3049252 2 6282 0701 000000 00002 5904180...

Good day, I need help from you. I have to split and create output files by every 30.000 recordings. Example , Input file has 150.000 (transaction.txt) recordings of bank accounts transactions. The C code has to split this file and create output files by 30.000 records each from input file...

So in that case maybe the problem with long checkpoints also? If it posibble to increace kio? :) So in the end of this about NUMAIOVPS parameter: I will set it NUMAIOVPS 1 ?, right?

This parameter will disable configuration of NUMAIOVPS? I just searching for real good anser for NUMAIOVPS paramter why it is needed and why not? speciali for IBM mashine? Could yoou please explain me if you can?

#onstat -g iov Informix Dynamic Server Version 9.30.UC3 -- On-Line -- Up 58 days 13:40:56 -- 1403280 Kbytes...

#onstat -g iof Informix Dynamic Server Version 9.30.UC3 -- On-Line -- Up AIO global files...

so, here is output from Select: table fragments size alog 171 229872 112_127 107 6848 444_8896 106 9960 442_8882 102 11333 107_81 99 49317 holdcodes 97 9120 443_8889 96 8673 crdaccupl 95 11437...

Can I ask for you e-mail, because outputs are very long, it is problem to past those here.

A lot of the I/O is going to : 14 /dev/rtlogidxa 2010132 521059 1489073 27.8 Where is TLOG table's indexes.The table is 4Gb big. mayby we can recreate indexes ?

The output from select is: dbsname tabname seqscans nrows npused karte order_det 422 778617 33568 karte form 36 1071888 8451 karte xml_data 15 114281 75446 karte user 13 2023 83 karte ligum_det 2 178987 25325 lsb hostfeecode 4329 4216 19 lsb numdescr 1391 4427 54 lsb crddet 655 542005 42688 lsb...

For this bank seste we have to use full checkpoints,not fuzzy.

53d93018 Y--P--- 408956 xbank - 535e7978 0 1 0 0 53d94218 Y--P--- 409225 nauda - 568f2f48 0 1 68 0 53d94818 Y--P--- 409146 cortex - 577418d8 0 1 8 0 53d95418 Y--P--- 409165 nauda - 57aaaa68 0 1 3...

50fe3618 Y--P--- 409008 nauda - 57cca978 0 1 159 85 50fe3c18 Y--P--- 405425 sami XC20 51a55fc8 0 1 18460 0 50fe4218 Y--P--- 409128 nauda - 574c2248 0 1 7948 17 50fe4e18 Y--P--- 134354 cortex - 513dd478 0 1 0...

50154218 ---P--F 0 informix - 0 0 0 0 8398 50154818 ---P--F 0 informix - 0 0 0 0 2274 50154e18 ---P--F 0 informix - 0 0 0 0 6653 50155418 ---P--F 0 informix - 0 0 0...