Allow DBA to re-initialize OS process cache created by the resolver routines
This is a follow up of RFE 33797.The original RFE was closed as "Delivered", but I think the analysis was incorrect. The complain is that whenever a OS process calls gethostbyaddr() or equivalent, the OS itself will cache some information about th...
Lock table (or database) in exclusive mode does not work as expected in HDR
If one attempts to update a table with many rows in an HDR environment with updateable secondary code like this does not work (if you are on the primary):begin work; lock table mytab in exclusive mode; update mytab set col1="xxx" where 1=1; commit...
Print session info for long transaction in msg log or DUMPDIR
I searched to see if anyone had opened up a RFE for the below and did not find one, if there is one then please disregard. One of our customers has now hardened down security to such a degree that I can no longer connect to the server in which Inf...
suppress fast repeating event from running alarmprogram for each event
Recently we had an event "storm" due to many events "Lock table overflow - user id 12396, session id 716985". Due to this the alarmprogram was executed little more than 97000 in a short time. I am aware of the mechanism that is in the alarmprogram...
Add SQL Function to create MD5 hashes (Oracle has GET_HASH_VALUE function)
Native function to create a MD5 hash from String parameter. Other databases has already this kind of functions: Oracle, MySQL. For compatibility, we can use Oracle name: GET_HASH_VALUE
"Plain text" connections to Informix are only encrypted if using SSL. The manuals and internet only explain "self assigned certification" well enough to implement. To make matters worse the "certs" expire and then you have to wipe everything out, ...
Upgrading without an outage in an HDR environment is a big deal when rolling out upgrades in the HDR environment. With the conversion from 12.10.FC4 to 12.10.FC5 we will have a failover and thats it! Thats a HUGE win for the product but I need thi...