RE: HDR monitoring
Is there an easy method that anyone has used in the past on 11.50.FCx to monitor that HDR is active and that communication between primary and secondary is up? Can an alert be set up, or something similar, to send out an e-mail if communications fail? Larry > To: ids@iiug.org > From: domusonline@gmail.com > Subject: Re: v11.70 warehouse infrastructure [22494] > Date: Wed, 19 Jan 2011 12:29:42 -0500 > > On Wed, Jan 19, 2011 at 5:00 PM, Norma Jean Sebastian <njiiug@gmail.com>wrote: > > > Informix v11.70 has "warehouse infrastructure features". > > > > general questions: > > > > does this mean IN the v11.70 download which i traditionally use for OLTP > > there now exists warehouse features regarding warehouse query optimization, > > etc? > > > > Yes. But you should think on specific features. Don't tell anyone that I > wrote this :) but keep the marketing message separate from the technical > perspective. > Yes, there are a lot of new functionalities that are traditionally useful > for DW environments that are now included in the engine. But your "etc." can > mean a lot of things... > Some things that pop up to my mind at this moment: > - star schema optimization (push down hash joins) > - multiple index for one query > - skip scan optimization > - fragmentation improvements (more fragmentation schemes, more table > availability....) > > > does this mean that i do NOT need to install a different flavor of Informix > > (such as warehouse edition) in order to get better warehouse type > > performance from my traditional OLTP database? > > > > Yes. > > > does this mean i don't need a warehouse at all because my Informix v11.70 > > is > > so blazing good it can do both my OLTP and DW in one package (at least if i > > am not expecting to build a huge warehouse)? > > > > No. It means you can use Informix for your DW. 11.7 will be much better > fitted for this kind of work. But please keep in mind that the data > organization in a DW is completely different > from OLTP. > Yes, v11.7 is blazing good! :) > > > > > what happened to the "Informix Warehouse" ... is that still around or made > > rather obsolete due to v11.70 enhancements? > > > > If you're referring to Informix Warehouse Featurew it's still around and > included in the Ultimate Edition. Note that this is completely different > from the technical features above. > Informix Warehouse Feature is a simple ETL tool. So it does not replace the > features above and it's not replaced by them. It can use the features to > make a better work... > Eventually this is an example where the marketing message can cause some > confusion. The term "warehouse" is used in very different contexts. > > thank you for your insight and thoughts, > > Norma Jean > > > > No problem. By the way, it would be nice to allow comments in your blog (I > couldn't find a way to write them... Am I missing something?) > > Regards. > ----------------------- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --0015174c3d0485bcaa049a365cc4 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
There is an ALARM # (don't remember the # right now) that your ALARMPROGRAM can trap for when HDR breaks. Bob ----- Original Message ----- From: "LARRY SORENSEN" <lsorensen25@msn.com> To: ids@iiug.org Sent: Tuesday, February 15, 2011 5:40:07 PM Subject: RE: HDR monitoring [22790] Is there an easy method that anyone has used in the past on 11.50.FCx to monitor that HDR is active and that communication between primary and secondary is up? Can an alert be set up, or something similar, to send out an e-mail if communications fail? Larry > To: ids@iiug.org > From: domusonline@gmail.com > Subject: Re: v11.70 warehouse infrastructure [22494] > Date: Wed, 19 Jan 2011 12:29:42 -0500 > > On Wed, Jan 19, 2011 at 5:00 PM, Norma Jean Sebastian <njiiug@gmail.com>wrote: > > > Informix v11.70 has "warehouse infrastructure features". > > > > general questions: > > > > does this mean IN the v11.70 download which i traditionally use for OLTP > > there now exists warehouse features regarding warehouse query optimization, > > etc? > > > > Yes. But you should think on specific features. Don't tell anyone that I > wrote this :) but keep the marketing message separate from the technical > perspective. > Yes, there are a lot of new functionalities that are traditionally useful > for DW environments that are now included in the engine. But your "etc." can > mean a lot of things... > Some things that pop up to my mind at this moment: > - star schema optimization (push down hash joins) > - multiple index for one query > - skip scan optimization > - fragmentation improvements (more fragmentation schemes, more table > availability....) > > > does this mean that i do NOT need to install a different flavor of Informix > > (such as warehouse edition) in order to get better warehouse type > > performance from my traditional OLTP database? > > > > Yes. > > > does this mean i don't need a warehouse at all because my Informix v11.70 > > is > > so blazing good it can do both my OLTP and DW in one package (at least if i > > am not expecting to build a huge warehouse)? > > > > No. It means you can use Informix for your DW. 11.7 will be much better > fitted for this kind of work. But please keep in mind that the data > organization in a DW is completely different > from OLTP. > Yes, v11.7 is blazing good! :) > > > > > what happened to the "Informix Warehouse" ... is that still around or made > > rather obsolete due to v11.70 enhancements? > > > > If you're referring to Informix Warehouse Featurew it's still around and > included in the Ultimate Edition. Note that this is completely different > from the technical features above. > Informix Warehouse Feature is a simple ETL tool. So it does not replace the > features above and it's not replaced by them. It can use the features to > make a better work... > Eventually this is an example where the marketing message can cause some > confusion. The term "warehouse" is used in very different contexts. > > thank you for your insight and thoughts, > > Norma Jean > > > > No problem. By the way, it would be nice to allow comments in your blog (I > couldn't find a way to write them... Am I missing something?) > > Regards. > ----------------------- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --0015174c3d0485bcaa049a365cc4 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Its event alarm # 15 "High-Availability Data-Replication failure "
for more details --
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adref.doc/id
s_adr_0676.htm
Nilesh
ids-bounces@iiug.org wrote on 02/15/2011 05:36:10 PM:
> From:
>
> "rroussey@comcast.net" <rroussey@comcast.net>
>
> To:
>
> ids@iiug.org
>
> Date:
>
> 02/15/2011 05:38 PM
>
> Subject:
>
> Re: HDR monitoring [22791]
>
> Sent by:
>
> ids-bounces@iiug.org
>
> There is an ALARM # (don't remember the # right now) that your
ALARMPROGRAM> can trap for when HDR breaks.
>
> Bob
>
> ----- Original Message -----
> From: "LARRY SORENSEN" <lsorensen25@msn.com>
> To: ids@iiug.org
> Sent: Tuesday, February 15, 2011 5:40:07 PM
> Subject: RE: HDR monitoring [22790]
>
> Is there an easy method that anyone has used in the past on 11.50.FCx to
> monitor that HDR is active and that communication between primary and
> secondary is up? Can an alert be set up, or something similar, to send
out an
> e-mail if communications fail?
>
> Larry
>
> > To: ids@iiug.org
> > From: domusonline@gmail.com
> > Subject: Re: v11.70 warehouse infrastructure [22494]
> > Date: Wed, 19 Jan 2011 12:29:42 -0500
> >
> > On Wed, Jan 19, 2011 at 5:00 PM, Norma Jean Sebastian
> <njiiug@gmail.com>wrote:
> >
> > > Informix v11.70 has "warehouse infrastructure features".
> > >
> > > general questions:
> > >
> > > does this mean IN the v11.70 download which i traditionally use for
OLTP
> > > there now exists warehouse features regarding warehouse query
> optimization,
> > > etc?
> > >
> >
> > Yes. But you should think on specific features. Don't tell anyone that
I
> > wrote this :) but keep the marketing message separate from the
technical
> > perspective.
> > Yes, there are a lot of new functionalities that are traditionally
useful
> > for DW environments that are now included in the engine. But your
> "etc." can
> > mean a lot of things...
> > Some things that pop up to my mind at this moment:
> > - star schema optimization (push down hash joins)
> > - multiple index for one query
> > - skip scan optimization
> > - fragmentation improvements (more fragmentation schemes, more table
> > availability....)
> >
> > > does this mean that i do NOT need to install a different flavor of
> Informix
> > > (such as warehouse edition) in order to get better warehouse type
> > > performance from my traditional OLTP database?
> > >
> >
> > Yes.
> >
> > > does this mean i don't need a warehouse at all because my Informix
v11.70
> > > is
> > > so blazing good it can do both my OLTP and DW in one package (atleast
if
> i
> > > am not expecting to build a huge warehouse)?
> > >
> >
> > No. It means you can use Informix for your DW. 11.7 will be much better
> > fitted for this kind of work. But please keep in mind that the data
> > organization in a DW is completely different
> > from OLTP.
> > Yes, v11.7 is blazing good! :)
> >
> > >
> > > what happened to the "Informix Warehouse" ... is that still
> around or made
> > > rather obsolete due to v11.70 enhancements?
> > >
> >
> > If you're referring to Informix Warehouse Featurew it's still around
and
> > included in the Ultimate Edition. Note that this is completely
different
> > from the technical features above.
> > Informix Warehouse Feature is a simple ETL tool. So it does not replace
the
> > features above and it's not replaced by them. It can use the features
to
> > make a better work...
> > Eventually this is an example where the marketing message can cause
some
> > confusion. The term "warehouse" is used in very different contexts.
> >
> > thank you for your insight and thoughts,
> > > Norma Jean
> > >
> >
> > No problem. By the way, it would be nice to allow comments in your blog
(I
> > couldn't find a way to write them... Am I missing something?)
> >
> > Regards.
> > -----------------------
> > Fernando Nunes
> > Portugal
> >
> > http://informix-technology.blogspot.com
> > My email works... but I don't check it frequently...
> >
> > --0015174c3d0485bcaa049a365cc4
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thank you for the information.
> To: ids@iiug.org
> From: nilesho@us.ibm.com
> Subject: Re: HDR monitoring [22797]
> Date: Tue, 15 Feb 2011 23:17:49 -0500
>
> Its event alarm # 15 "High-Availability Data-Replication failure "
> for more details --
>
>
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adref.doc/id
s_adr_0676.htm
>
> Nilesh
>
> ids-bounces@iiug.org wrote on 02/15/2011 05:36:10 PM:
>
> > From:
> >
> > "rroussey@comcast.net" <rroussey@comcast.net>
> >
> > To:
> >
> > ids@iiug.org
> >
> > Date:
> >
> > 02/15/2011 05:38 PM
> >
> > Subject:
> >
> > Re: HDR monitoring [22791]
> >
> > Sent by:
> >
> > ids-bounces@iiug.org
> >
> > There is an ALARM # (don't remember the # right now) that your
> ALARMPROGRAM> > can trap for when HDR breaks.
> >
> > Bob
> >
> > ----- Original Message -----
> > From: "LARRY SORENSEN" <lsorensen25@msn.com>
> > To: ids@iiug.org
> > Sent: Tuesday, February 15, 2011 5:40:07 PM
> > Subject: RE: HDR monitoring [22790]
> >
> > Is there an easy method that anyone has used in the past on 11.50.FCx to
> > monitor that HDR is active and that communication between primary and
> > secondary is up? Can an alert be set up, or something similar, to send
> out an
> > e-mail if communications fail?
> >
> > Larry
> >
> > > To: ids@iiug.org
> > > From: domusonline@gmail.com
> > > Subject: Re: v11.70 warehouse infrastructure [22494]
> > > Date: Wed, 19 Jan 2011 12:29:42 -0500
> > >
> > > On Wed, Jan 19, 2011 at 5:00 PM, Norma Jean Sebastian
> > <njiiug@gmail.com>wrote:
> > >
> > > > Informix v11.70 has "warehouse infrastructure features".
> > > >
> > > > general questions:
> > > >
> > > > does this mean IN the v11.70 download which i traditionally use for
> OLTP
> > > > there now exists warehouse features regarding warehouse query
> > optimization,
> > > > etc?
> > > >
> > >
> > > Yes. But you should think on specific features. Don't tell anyone that
> I
> > > wrote this :) but keep the marketing message separate from the
> technical
> > > perspective.
> > > Yes, there are a lot of new functionalities that are traditionally
> useful
> > > for DW environments that are now included in the engine. But your
> > "etc." can
> > > mean a lot of things...
> > > Some things that pop up to my mind at this moment:
> > > - star schema optimization (push down hash joins)
> > > - multiple index for one query
> > > - skip scan optimization
> > > - fragmentation improvements (more fragmentation schemes, more table
> > > availability....)
> > >
> > > > does this mean that i do NOT need to install a different flavor of
> > Informix
> > > > (such as warehouse edition) in order to get better warehouse type
> > > > performance from my traditional OLTP database?
> > > >
> > >
> > > Yes.
> > >
> > > > does this mean i don't need a warehouse at all because my Informix
> v11.70
> > > > is
> > > > so blazing good it can do both my OLTP and DW in one package (atleast
> if
> > i
> > > > am not expecting to build a huge warehouse)?
> > > >
> > >
> > > No. It means you can use Informix for your DW. 11.7 will be much better
>
> > > fitted for this kind of work. But please keep in mind that the data
> > > organization in a DW is completely different
> > > from OLTP.
> > > Yes, v11.7 is blazing good! :)
> > >
> > > >
> > > > what happened to the "Informix Warehouse" ... is that still
> > around or made
> > > > rather obsolete due to v11.70 enhancements?
> > > >
> > >
> > > If you're referring to Informix Warehouse Featurew it's still around
> and
> > > included in the Ultimate Edition. Note that this is completely
> different
> > > from the technical features above.
> > > Informix Warehouse Feature is a simple ETL tool. So it does not replace
> the
> > > features above and it's not replaced by them. It can use the features
> to
> > > make a better work...
> > > Eventually this is an example where the marketing message can cause
> some
> > > confusion. The term "warehouse" is used in very different contexts.
> > >
> > > thank you for your insight and thoughts,
> > > > Norma Jean
> > > >
> > >
> > > No problem. By the way, it would be nice to allow comments in your blog
> (I
> > > couldn't find a way to write them... Am I missing something?)
> > >
> > > Regards.
> > > -----------------------
> > > Fernando Nunes
> > > Portugal
> > >
> > > http://informix-technology.blogspot.com
> > > My email works... but I don't check it frequently...
> > >
> > > --0015174c3d0485bcaa049a365cc4
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
>
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>