Search results for query: *

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...

The databse is on raw devices. Here is the output of onstat command: Userthreads address flags sessid user tty wait tout locks nreads nwrites 5013b018 ---P--D 1 informix - 0 0 0 4659 37840 5013b618 ---P--F 0 informix - 0...

here is continue from onstat -R 111 m 0.6% 3 0 3 0 0 112 f 513 99.8% 512 0 416 95 1 113 m 0.2% 1 0 1 0 0 114 f 510 99.4% 507 0 416...

The total output of onstat -F command is: Fg Writes LRU Writes Chunk Writes 0 37681152 29571184 address flusher state data 5013b618 0 I 0 = 0X0 5013bc18 1 I 0 = 0X0 5013c218 2 I 0...

Yes, you right about config file. Thank for reply. And here is info what you need: - 2 CPU - 4G of phisical RAM - yes, it is dedicated - Fg Writes LRU Writes Chunk Writes 0 37681152 29571184 - it RAID disks, where are 15 tablespaces - the chescpoints some times 6 sec...

Good day, We have problem with full checkpoints on Informix DB. Sometimes checkpoints are more then 6 sec. Please help me to reslove problem. Please see below oconfig file and output from onstat -F command. oconfig #************************************************************************** #...