tag:blogger.com,1999:blog-35024011.comments2024-01-24T05:57:51.562+00:00Informix technologyFernando Nuneshttp://www.blogger.com/profile/15733748635390133382noreply@blogger.comBlogger121125tag:blogger.com,1999:blog-35024011.post-50179696864060567732023-06-20T19:11:44.511+01:002023-06-20T19:11:44.511+01:00Love to see and read your posts, Fernando!Love to see and read your posts, Fernando!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-1458251077358166422017-08-23T10:11:33.769+01:002017-08-23T10:11:33.769+01:00Hi Fernando,
that above works fine in 11.70 - but...Hi Fernando,<br /><br />that above works fine in 11.70 - but in 12.10 you will get the error:<br />AUTO_LRU_TUNING is already set to 0.<br /><br />With 12.10 it works with:<br />$ onmode -wm AUTO_LRU_TUNING="1,bpool=0,min=0.5,max=2.1"<br />$ onmode -wm AUTO_LRU_TUNING="1,bpool=7,min=0.6,max=2.2"<br />$ onmode -wm AUTO_LRU_TUNING=0<br /><br />The first 2 commands change the lruAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-1999362526888017362017-08-17T13:57:37.340+01:002017-08-17T13:57:37.340+01:00Hi Fernando,
I have tested that onmode -wm AUTO_L...Hi Fernando,<br /><br />I have tested that onmode -wm AUTO_LRU_TUNING=bpool=... command and first<br />got following error:<br /><br />onmode: Please check the message log for any additional errors.<br /><br />The problem is, that bpool= needs the index of the buffer pool as argument.<br /><br />So first you need to know which bufferpool should has which id/index:<br /><br />$ echo "select Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-84169892499489086552016-02-03T20:02:35.235+00:002016-02-03T20:02:35.235+00:00Great article! We were experimenting a similar sit...Great article! We were experimenting a similar situation in a customer and that help us to explain what is happening.<br />Thanks a lot!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-4547831477870866512015-02-27T10:03:28.661+00:002015-02-27T10:03:28.661+00:00If by "introduced" you accept something ...If by "introduced" you accept something not documented, and that wasn't put through proper QA testing... yes.<br /><br />It was even presented by IBMers to customers (I did also), but it was a hidden feature. And it had bugs (but still it was useful)Fernando Nuneshttps://www.blogger.com/profile/15733748635390133382noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-24962678359757976592015-02-27T08:38:16.850+00:002015-02-27T08:38:16.850+00:00SESSION_LIMIT_LOCKS introduced with 11.70.xC3.SESSION_LIMIT_LOCKS introduced with 11.70.xC3.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-35397985668976428682014-11-07T17:23:57.176+00:002014-11-07T17:23:57.176+00:00Excelente análise Mr Nunes! Vai ser difícil agora,...Excelente análise Mr Nunes! Vai ser difícil agora, para qualquer um afirmar que Informix morreu em 2001, e que é um produto do passado.Uma bela lição de perseverância.<br />EV.Anonymoushttps://www.blogger.com/profile/04756378342526604802noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-35381591970324826902014-09-06T17:56:29.673+01:002014-09-06T17:56:29.673+01:00David, to answer your question:
With index skip s...David, to answer your question:<br /><br />With index skip scan:<br /><br /><br />10 dbs1.c1 38119424 18613 0 0 1512.8<br /> op type count avg. time<br /> seeks 0 N/A<br /> reads 0 N/A<br /> writes 0 N/A<br /> kaio_reads 18613 0.0007<br />Fernando Nuneshttps://www.blogger.com/profile/15733748635390133382noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-38976873320607635412014-09-06T00:12:44.519+01:002014-09-06T00:12:44.519+01:00What did onstat -g iof give in both cases (with on...What did onstat -g iof give in both cases (with onstat -z to reset)? This shows avg. time for read/writes with kaio listed seperately.David Williamshttp://justdave.infonoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-58371187938621856712014-08-14T17:27:25.800+01:002014-08-14T17:27:25.800+01:00As reminded by Ben Thomson, to activate the "...As reminded by Ben Thomson, to activate the "fix" for the DATETIME index optimizer, a non documented paramater (SQL_DEF_CTRL) bit "0x2" needs to be set... This SQL_DEF_CTRL control would deserve proper documentation...Fernando Nuneshttps://www.blogger.com/profile/15733748635390133382noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-4062404883966942812014-05-02T11:09:35.593+01:002014-05-02T11:09:35.593+01:00Thank you very much for the tips and advice on thi...Thank you very much for the tips and advice on this page. Got me out of a tight spot with 11.5 on HP-UX.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-28637357045485902802014-02-13T16:35:28.549+00:002014-02-13T16:35:28.549+00:00Excellent article, and what a great workaround! G...Excellent article, and what a great workaround! Good work!Unknownhttps://www.blogger.com/profile/05508521122939272734noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-69983877162576549532013-10-24T05:29:09.446+01:002013-10-24T05:29:09.446+01:00Good reviewGood reviewShahana Shafiuddinhttps://www.blogger.com/profile/06801040505340305472noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-81400913893496718692013-09-13T18:21:42.870+01:002013-09-13T18:21:42.870+01:00This comment has been removed by a blog administrator.Jasna Krmpotic, IBMnoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-19173848640130169422013-09-12T18:57:13.586+01:002013-09-12T18:57:13.586+01:00Buena aportación, muchas gracias.Buena aportación, muchas gracias.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-35024011.post-87516451847527916182013-05-10T15:53:54.005+01:002013-05-10T15:53:54.005+01:00Achei interessante as novas funcionalidades do inf...Achei interessante as novas funcionalidades do informix o que deixou um pouco perdido foi a mudança dos nomes (Growth edition para Workgroup Edition e do Ultimate edition para Enterprise Edition), depois de anos usando estes nomes, se eles (IBM) acha isso bom.Claudemar Martins de Sáhttps://www.blogger.com/profile/05069108300402187406noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-55585266830310454672013-04-05T14:36:38.177+01:002013-04-05T14:36:38.177+01:00The license is the most formal source of informati...The license is the most formal source of information. So yes.<br />If you have some concerns with that you can/should contact IBM sales services. They may help by recieving and echoing your concerns while at the same time work with you on a solution (Express editon can be an option, depending of course on how much it will cost you)Fernando Nuneshttps://www.blogger.com/profile/15733748635390133382noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-43909395349185498542013-04-05T11:56:28.850+01:002013-04-05T11:56:28.850+01:00Hi!
Many thanks for the article, i read it on pla...Hi!<br /><br />Many thanks for the article, i read it on planetids.com. I have following question regarding IBM Informix Innovator-C 12.10:<br />As I saw in the new license information (link in your post) Innovator has now a storage limit of 8 Gigabytes.<br /> <br />1.3 Database Size Limit <br /><br />The Program allows a maximum of eight (8) Gigabytes of database server storage.<br /><br />Is itAnonymoushttps://www.blogger.com/profile/04805290302019135505noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-3019478870241078422013-04-05T11:54:54.301+01:002013-04-05T11:54:54.301+01:00Hi!
Many thanks for the article, i read it on pla...Hi!<br /><br />Many thanks for the article, i read it on planetids.com. I have following question regarding IBM Informix Innovator-C 12.10:<br />As I saw in the new license information (link in your post) Innovator has now a storage limit of 8 Gigabytes.<br /> <br />1.3 Database Size Limit <br /><br />The Program allows a maximum of eight (8) Gigabytes of database server storage.<br /><br />Is itAnonymoushttps://www.blogger.com/profile/04805290302019135505noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-1493189608787134292013-04-05T11:53:20.237+01:002013-04-05T11:53:20.237+01:00Hi!
Many thanks for the article, i read it on pla...Hi!<br /><br />Many thanks for the article, i read it on planetids.com. I have following question regarding IBM Informix Innovator-C 12.10:<br />As I saw in the new license information (link in your post) Innovator has now a storage limit of 8 Gigabytes.<br /> <br />1.3 Database Size Limit <br /><br />The Program allows a maximum of eight (8) Gigabytes of database server storage.<br /><br />Is itAnonymoushttps://www.blogger.com/profile/04805290302019135505noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-67657268903247671092013-02-27T23:22:29.086+00:002013-02-27T23:22:29.086+00:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/08870598031344769622noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-27029944027433313332013-02-27T20:18:26.966+00:002013-02-27T20:18:26.966+00:00Thanks, Fernando.
I think this solution is quite ...Thanks, Fernando.<br /><br />I think this solution is quite nice. It shouldn't affect the tools because the JDBC driver is responsible for converting the native Informix representation of 't' to a Java boolean. So we only have to worry about the "in" parameters.<br /><br />I actually went ahead and fixed EclipseLink, but I was not aware of the user-defined cast functions.Laird Nelsonhttps://www.blogger.com/profile/07905132403257139697noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-22773564662066699122013-01-27T18:31:18.885+00:002013-01-27T18:31:18.885+00:00Wow, nice writeup. Will give it a go next time I g...Wow, nice writeup. Will give it a go next time I get the chance. Still think an ipa_cleaner thread might be good.PeterPhttps://www.blogger.com/profile/12894524625947167438noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-5567844371767667732012-12-26T16:17:59.060+00:002012-12-26T16:17:59.060+00:00we have created SSL certificate which expairs in y...we have created SSL certificate which expairs in year 2031. This give us enough time to decide if we will continue to use SSL in future or switch to some other technology. Sdas01https://www.blogger.com/profile/03859081801482820753noreply@blogger.comtag:blogger.com,1999:blog-35024011.post-13358986210284113392012-12-26T16:15:07.760+00:002012-12-26T16:15:07.760+00:00we have created SSL certificate which expairs in y...we have created SSL certificate which expairs in year 2031 ( 20 years) Sdas01https://www.blogger.com/profile/03859081801482820753noreply@blogger.com