informix on linux or solaris?
User asks about Informix deployment on RHEL 7 vs Solaris 11 for OLTP, concerned about Solaris closure rumors. Respondents clarify that Informix is platform-agnostic, so choice depends on OS preference. Solaris 12 was cancelled but Solaris 11.4 is coming with support through 2034. Solaris/SPARC advantages include hardware-integrated memory checking (Silicon Secured Memory), though benefits for Informix specifically unclear.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I want to know the advantage and disadvantage for using informix on Linux(RHEL 7) and Solaris (Solaris11). Which is the best combination and why. or any other OS What is the authenticity for closing Solaris Thanks .
Informix tends to be platform agnostic. As such, your question comes down to which OS you prefer (for whatever reasons you consider important). I didn't understand your last sentence. Are you asking if the rumors or news about the end of Solaris are true? You should ask Oracle or in a Solaris forum. Regards. On Mon, Jan 29, 2018 at 4:38 PM, ABRAR RASHID <mabrar@i2cinc.com> wrote: > Hi, > > I want to know the advantage and disadvantage for using informix on > Linux(RHEL > 7) and Solaris (Solaris11). > > Which is the best combination and why. or any other OS > > What is the authenticity for closing Solaris > > Thanks . > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
Yes for the rumors . I want to setup database instance for OLTP and during OS searching found few forums and discussions saying about closure of solaris ( unofficial). Now i am trying to test my DB setup on REHL 7 so that's why i want to check advantages and disadvantages of these two.
> On 29 January 2018 at 17:17 ABRAR RASHID <mabrar@i2cinc.com> wrote: > > > Yes for the rumors . Version 12 of Solaris was cancelled - Oracle has moved to a devops continuous delivery model! https://blogs.oracle.com/solaris/continuous-delivery,-really https://www.theregister.co.uk/2018/01/09/solaris_11next_becomes_solaris_114_but_ new_features_arent_set/ Solaris has moving from big releases to small continuous updates. Solaris 11.4 has been announcement as coming: https://www.theregister.co.uk/2018/01/09/solaris_11next_becomes_solaris_114_but_ new_features_arent_set/ "we extended Premier Support for Oracle Solaris to at least 2031 and Extended Support to at least 2034. This is the longest Premier Support that Oracle has ever offered. I want to address something I've been hearing from some of you about this. This doesn't mean Oracle Solaris is only doing support bug fixing. We are actively developing on and innovating in Oracle Solaris (that is what Premier Support is) until at least 2034." https://www.theregister.co.uk/2017/01/18/solaris_12_disappears_from_oracles_road map/ See also https://forums.theregister.co.uk/forum/1/2017/01/18/solaris_12_disappears_from_o racles_roadmap/#c_3078659 Regards, David. > > I want to setup database instance for OLTP and during OS searching found few > forums and discussions saying about closure of solaris ( unofficial). > > Now i am trying to test my DB setup on REHL 7 so that's why i want to check > advantages and disadvantages of these two. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
One advantage for Solaris/SPARC is that the make of the OS also making the hardware and storage! The question is whether this provides enough benefit to be worth it. To summarize the below it would be good if IBM used at least 1 SPARC box with Silcon Secured Memory for additional testing to catch internal Informix memory errors! 1. Solaris has additional memory checking in hardware - Silcon Secured Memory https://community.oracle.com/docs/DOC-994845 "Another important advantage is that the software changes needed to support SSM can be provided in a library. An application does not need to have any instrumentation added in order for it to be checked." Whether Informix would be supported running under this library to avoid memory corruption is a question for IBM however it could certainly be used for testing. "SSM can pick up a range of errors that normal instrumentation cannot identify. Earlier, we discussed that typical software instrumentation has a problem when there are stale pointers to reassigned memory locations or if a pointer happens to point to a valid memory location. It is very hard for software to be able to handle these situations, because it has no idea whether the memory location is a valid location for the pointer to address. SSM, on the other hand, encodes the "color" of a memory location into both the pointer and the memory location." "What's more, even stale-pointer access (a freed-memory access to an area that has been subsequently allocated for another purpose), which no software tool to date detects, is also caught nearly 100 percent of the time" 2. Oracle can also do database memory scans in hardware but as far as I am aware this is only for the Oracle Database, I am not sure Informix(/Db2!) would rework their bufferpool layout to support in-memory hardware scans on SPARC hardware! If Intel was to have something similar they would need custom memory scanning algorithms per database vendor! https://swisdev.oracle.com/_files/What-Is-SSM.html "Database In-Memory Query Accelerator" https://community.oracle.com/docs/DOC-932216 http://www.oracle.com/technetwork/database/in-memory/overview/twp-inmem-on-m10-e n-2714932.html however as far as I am aware this is only currently used by the Oracle Database, not other vendors! "Software on Chip features for Oracle Database In-Memory scan" i.e. specifically developed for the Oracle Databases! Also http://www.oracle.com/technetwork/server-storage/solaris11/documentation/oracle- database-on-solaris-wp-2298802.pdf "The Oracle Solaris and Oracle Database engineering teams work closely together to determine how operating system features can complement and enhance database deployments." "joint integration and optimization efforts" Presumably when Oracle talk to Intel conversations can only reach a certain technical depth before lawyers stop the conversion on IP grounds. Since Solaris/Oracle Database conversations do not cross an IP boundary I assume they can have additioncal conversations and hence better integration. Oracle can even add features all the way down to hardware to benefit their database ("Software on Chip features for Oracle Database In-Memory scan") and without need to ask another vendor for the change! Of course this tighter itnegration only helps with the Oracle Database, not other database vendors! Regards, David. > On 29 January 2018 at 17:17 ABRAR RASHID <mabrar@i2cinc.com> wrote: > > > Yes for the rumors . > > I want to setup database instance for OLTP and during OS searching found few > forums and discussions saying about closure of solaris ( unofficial). > > Now i am trying to test my DB setup on REHL 7 so that's why i want to check > advantages and disadvantages of these two. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
This one http://www.oracle.com/technetwork/database/bi-datawarehousing/sas/con8216-final- 2760803.pdf even showed catching memory issues in the Oracle database SGA (bufferpool)! Would be nice if HCL used this for additional testing! Regards, David. > On 30 January 2018 at 08:30 "david@smooth1.co.uk" <david@smooth1.co.uk> wrote: > > > One advantage for Solaris/SPARC is that the make of the OS also making the > hardware and storage! > > The question is whether this provides enough benefit to be worth it. > > To summarize the below it would be good if IBM used at least 1 SPARC box with > Silcon Secured Memory for additional testing to catch internal Informix memory > errors! > > 1. Solaris has additional memory checking in hardware - Silcon Secured Memory > > https://community.oracle.com/docs/DOC-994845 > > "Another important advantage is that the software changes needed to support > SSM can be provided in a library. An application does not need to have any > instrumentation added in order for it to be checked." > > Whether Informix would be supported running under this library to avoid memory > corruption is a question for IBM however it could certainly be used for > testing. > > "SSM can pick up a range of errors that normal instrumentation cannot > identify. Earlier, we discussed that typical software instrumentation has a > problem when there are stale pointers to reassigned memory locations or if a > pointer happens to point to a valid memory location. It is very hard for > software to be able to handle these situations, because it has no idea whether > the memory location is a valid location for the pointer to address. SSM, on > the other hand, encodes the "color" of a memory location into both the pointer > and the memory location." > > "What's more, even stale-pointer access (a freed-memory access to an area that > has been subsequently allocated for another purpose), which no software tool > to date detects, is also caught nearly 100 percent of the time" > > 2. Oracle can also do database memory scans in hardware but as far as I am > aware this is only for the Oracle Database, I am not sure Informix(/Db2!) > would rework their bufferpool layout to support in-memory hardware scans on > SPARC hardware! > > If Intel was to have something similar they would need custom memory scanning > algorithms per database vendor! > > https://swisdev.oracle.com/_files/What-Is-SSM.html "Database In-Memory Query > Accelerator" > > https://community.oracle.com/docs/DOC-932216 > > > http://www.oracle.com/technetwork/database/in-memory/overview/twp-inmem-on-m10-e n-2714932.html > however as far as I am aware this is only currently used by the Oracle > Database, not other vendors! "Software on Chip features for Oracle Database > In-Memory scan" i.e. specifically developed for the Oracle Databases! > > Also > http://www.oracle.com/technetwork/server-storage/solaris11/documentation/oracle- database-on-solaris-wp-2298802.pdf > > "The Oracle Solaris and Oracle Database engineering teams work closely > together to determine how operating system features can complement and enhance > database deployments." > > "joint integration and optimization efforts" > > Presumably when Oracle talk to Intel conversations can only reach a certain > technical depth before lawyers stop the conversion on IP grounds. Since > Solaris/Oracle Database conversations do not cross an IP boundary I assume > they can have additioncal conversations and hence better integration. > > Oracle can even add features all the way down to hardware to benefit their > database ("Software on Chip features for Oracle Database In-Memory scan") and > without need to ask another vendor for the change! > > Of course this tighter itnegration only helps with the Oracle Database, not > other database vendors! > > Regards, > David. > > > On 29 January 2018 at 17:17 ABRAR RASHID <mabrar@i2cinc.com> wrote: > > > > > > Yes for the rumors . > > > > I want to setup database instance for OLTP and during OS searching found few > > forums and discussions saying about closure of solaris ( unofficial). > > > > Now i am trying to test my DB setup on REHL 7 so that's why i want to check > > advantages and disadvantages of these two. > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >