List of Contributions

Mr David Williams

Contact Details

My Content

1 to 20 of 50+ total
Posted By David Williams Thu March 14, 2024 02:39 PM
Found In Egroup: IBM License Metric Tool (ILMT)
\ view thread
HI, On RHEL 8 how do you get the ILMT Server to listen on IPV4 interfaces as well as IPV6 interfaces for the RSP_TLM_HTTPS_PORT? Regards, David. #IBMChampion ------------------------------ David Williams ------------------------------
Posted By David Williams Mon February 12, 2024 02:26 PM
Found In Egroup: Informix
\ view thread
Hi, cd does not fix all issues. If the the current working directory (cwd) for the server no longer exists (e.g. when started under automation) then the server will not be able to fork a process to run the alarmprogram! I cannot remember if something appears in the online.log for this condition. ...
Posted By David Williams Sat February 10, 2024 01:15 PM
Found In Egroup: Informix
\ view thread
Hi, onbar -v runs serial rather than parallel, there is a feature request for this, "Planned for Future Release", upvote it! https://ideas.ibm.com/ideas/INFX-I-202 Regards, David. ------------------------------ David Williams ------------------------------
Posted By David Williams Sat February 03, 2024 09:29 AM
Found In Egroup: Informix
\ view thread
Hi, Open a case, this could be a defect or expected behaviour if multiple rows point to the same smart blob. Also run oncheck -cS on the smart blob space. Regards, David. ------------------------------ David Williams ------------------------------
Posted By David Williams Thu January 25, 2024 03:07 PM
Found In Egroup: Informix
\ view thread
HI, Depends which version of OneDB you are talking about. As per The new Readahead tables appears in IBM Informix 14.10.xC7 - https://www.ibm.com/docs/en/informix-servers/14.10?topic=overview-whats-new-in-informix#concept_v1410xc7__1410xc7_onstat-rah As per https://www.ibm.com/support/page ...
Posted By David Williams Sun January 21, 2024 10:00 AM
Found In Egroup: Informix
\ view thread
Hi, For Client SDK upgrades you may also need to consider etc/consll.cfg if using SSL connections keystores if using SSL connections etc/cmsm if using Connection Managers Regards, David. ------------------------------ David Williams ------------------------------
Posted By David Williams Sun January 21, 2024 09:59 AM
Found In Egroup: Informix
\ view thread
Hi, Engine upgrades can be more complex If there are catalog changes then there needs to be no open transactions (restart in quiscent and shut down again!) If there and HDR/RSS nodes then more complex again Regards, David. ------------------------------ David Williams ----------------- ...
Posted By David Williams Sun January 21, 2024 09:58 AM
Found In Egroup: Informix
\ view thread
Hi, This is not documented. See this for idle sessions, perhaps exclude them? https://www.ibm.com/support/pages/system-monitor-interface-query-find-idle-time-sessions Regards, David. ------------------------------ David Williams ------------------------------
Posted By David Williams Sun January 21, 2024 09:35 AM
Found In Egroup: Informix
\ view thread
Hi, Client SDK 4.50.FC6 (and the latest 4.50.FC10W1) are built on RHEL 7. Even the latest CentOS 7.9 only has libcrypt.so.1. I doubt Client SDK is supported on RHEL 9 yet., Is it a problem to have the Informix libs loading libcrypt.so.1, and the binary load libcrypt.so.2 ? I would not rely on ...
Posted By David Williams Wed January 17, 2024 08:35 AM
Found In Egroup: Informix
\ view thread
Hi, With a free ticket can we attend online? Or get access to the slides? Regards, David. ------------------------------ David Williams ------------------------------
Posted By David Williams Fri January 05, 2024 02:43 AM
Found In Egroup: Informix
\ view thread
Hi, is the repack doing lots of commits? If so it will need to co-ordinate for each commit. Regards, David. ------------------------------ David Williams ------------------------------
Posted By David Williams Mon January 01, 2024 10:48 PM
Found In Egroup: Informix
\ view thread
Hi, So in order of the flow we have: Primary Current Log Page:543836,63218 Next log page to send(log id,page): 543813,121374 Last log page acked(log id,page): 543813,120349 Pending Log Pages to be ACKed: 1032 Approximate Log Page Backlog:3015340 RSS Last log page received(log id,page): ...
Posted By David Williams Mon January 01, 2024 10:30 PM
Found In Egroup: Informix
\ view thread
Hi, " I have no clue what is LBC, and the docs are of no help." See https://ideas.ibm.com/ideas/INFX-I-377 "From my interpretation of the source the information displayed on the primary by the onstat -g rss log command relates to the log buffer pages sent to an RSS server. These pages are ...
Posted By David Williams Mon January 01, 2024 10:11 PM
Found In Egroup: Informix
\ view thread
Hi, "What are these enormous figures in the 2nd column? Are they signed integer printed as unsigned? If so, what does negative queue size mean?" Yes the value is overflowing. Does a RSS_FLOW_CONTROL setting have any pitfall? As per https://www.ibm.com/docs/en/informix-serv ...
Posted By David Williams Thu December 28, 2023 02:39 AM
Found In Egroup: Informix
\ view thread
Hi. I did a test with 14.10.FC10W1 and this is still not fixed https://justdaveinfo.wordpress.com/2023/12/28/informix-auditing-and-alter-table/ Does this have an APAR yet? Or a fix date? Regards, David. ------------------------------ David Williams ---------------- ...
Posted By David Williams Wed December 27, 2023 12:38 PM
Found In Egroup: Informix
\ view thread
Hi, As per https://www.ibm.com/docs/en/informix-servers/14.10?topic=ogmo-onstat-g-laq-command-print-log-apply-queues Secondary Apply Queue: Total Buffers:12 Size:512K Free Buffers:11 # Buffer Size comes from LOGBUFF Log Recovery Queue: Total Buffers:4 Size:8192K Free Buffers:2 ...
Posted By David Williams Wed December 27, 2023 12:26 PM
Found In Egroup: Informix
\ view thread
Hi, Sometimes due to the syncronization points I mentioned having LESS apply threads can be faster. Try OFF_RECVRY_THREADS 31, 23,17,11 and see which comes out best. Also try SEC_APPLY_POLLTIME 100 and 50 and 0. When the lag happens send onstat -g cluster ...
Posted By David Williams Tue December 26, 2023 02:41 AM
Found In Egroup: Informix
\ view thread
Hi, Some other items OFF_RECVRY_THREADS is used to define the number of apply threads on the secondary LTAPEBLK I believe is used for the size of replication buffers SEC_APPLY_POLLTIME needs tuning on secondarys onstat -g laq (and the undocumented onstat -g ...
Posted By David Williams Wed November 22, 2023 02:22 PM
Found In Egroup: Informix
\ view thread
Hi, When this happens what is the header from onstat? Is it "(CKPT REQ)" or "(CKPT INP)"? When the instance appears to freeze capture an "onstat -g stk all" that will allow us to tell what it is waiting on. As Ben said, which version is this? NOTE: Version ...
Posted By David Williams Mon November 13, 2023 09:01 AM
Found In Egroup: Informix
\ view thread
Hi, Also https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-587 When AUTO_REPREPARE is non zero only have 1 sessions recompile a stored procedure Regards, David. ------------------------------ David Williams ------------------------------