IDS Forum

Re: informix on linux or solaris?

Posted By: david@smooth1.co.uk
Date: Tuesday, 30 January 2018, at 4:23 a.m.

In Response To: Re: informix on linux or solaris? (david@smooth1.co.uk)

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

Messages In This Thread

• informix on linux or solaris?
  ABRAR RASHID -- Monday, 29 January 2018, at 11:38 a.m.
  • Re: informix on linux or solaris?
    Fernando Nunes -- Monday, 29 January 2018, at 11:42 a.m.
    • Re: informix on linux or solaris?
      ABRAR RASHID -- Monday, 29 January 2018, at 12:17 p.m.
      • Re: informix on linux or solaris?
        david@smooth1.co.uk -- Tuesday, 30 January 2018, at 2:24 a.m.
      • Re: informix on linux or solaris?
        david@smooth1.co.uk -- Tuesday, 30 January 2018, at 3:30 a.m.
        • Re: informix on linux or solaris?
          david@smooth1.co.uk -- Tuesday, 30 January 2018, at 4:23 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.