IDS Growth vs Enterprise

Solaris 10 Sparc IDS 11.50.FC7 Are there any good statistics to run to determine when it is good to graduate to Enterprise Edition IDS from Growth Edition IDS? Larry ________________________________

There are two factors to consider. First =E2=80=94 11.5 has entered = end-of-life. Support will be withdrawn in April 2018 so you might want = to consider moving to a supported version. Second, moving from Workgroup to Enterprise should be based on = functionality and performance. WGE does not support parallelism, = fragmentation, parallel Bkup/Restore and other key components that will = enable the engine environment to run significantly faster.There are also = resource limitations built into the code that constrain the environment = as far as CPU power (num CPU VPs) and memory. There is limited HA/DR = support (2 secondaries) too. Finally distributed operations (query = to/from another instance) is not supported. Advanced functionality such = as compression and encryption are not available. That said, you can deploy and use timeseries, NoSQL. Whether any of this = is important to your environment is yours to decide. I=E2=80=99d = definitely vote for being on a supported version however! :) Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons were temporarily inconvenienced.=20 > On Jul 11, 2016, at 10:03 AM, LARRY SORENSEN <LSORENSEN25@msn.com> = wrote: >=20 > Solaris 10 Sparc=20 >=20 > IDS 11.50.FC7=20 >=20 > Are there any good statistics to run to determine when it is good to = graduate=20 > to Enterprise Edition IDS from Growth Edition IDS?=20 >=20 > Larry=20 >=20 > ________________________________=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

I understand and know all of the points that you make. My question is, what kind of statistics can I look at to say that the bottleneck is Growth Edition, and the issue will be resolved by going to Enterprise Edition and gaining the additional resources (cpu and memory and parallelism)? We are already planning an Upgrading to a later version of Growth Edition. Larry ________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Carlton Doe <dbaresrc@xmission.com> Sent: Monday, July 11, 2016 9:37 AM To: ids@iiug.org Subject: Re: IDS Growth vs Enterprise [37415] There are two factors to consider. First =E2=80=94 11.5 has entered = end-of-life. Support will be withdrawn in April 2018 so you might want = to consider moving to a supported version. Second, moving from Workgroup to Enterprise should be based on = functionality and performance. WGE does not support parallelism, = fragmentation, parallel Bkup/Restore and other key components that will = enable the engine environment to run significantly faster.There are also = resource limitations built into the code that constrain the environment = as far as CPU power (num CPU VPs) and memory. There is limited HA/DR = support (2 secondaries) too. Finally distributed operations (query = to/from another instance) is not supported. Advanced functionality such = as compression and encryption are not available. That said, you can deploy and use timeseries, NoSQL. Whether any of this = is important to your environment is yours to decide. I=E2=80=99d = definitely vote for being on a supported version however! :) Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons were temporarily inconvenienced.=20 > On Jul 11, 2016, at 10:03 AM, LARRY SORENSEN <LSORENSEN25@msn.com> = wrote: >=20 > Solaris 10 Sparc=20 >=20 > IDS 11.50.FC7=20 >=20 > Are there any good statistics to run to determine when it is good to = graduate=20 > to Enterprise Edition IDS from Growth Edition IDS?=20 >=20 > Larry=20 >=20 > ________________________________=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Larry: The things to look at would be: - onstat -g rea -r 1 Are the same sessions in the ready queue for more than a second and you are maxed out at 16 CPU VPS on 16 physical cores (not hyper-threads)? - onstat -g rea typically shows more than a couple of sessions waiting for CPU resources and you are maxed out at 16 CPU VPS on 16 physical cores (not hyper-threads)? - message log messages about not being able to increase shared memory beyond 16GB? - You have tables approaching the 16million page limit and moving the table to wider pages is not a good option (ie partitioning/fragmenting would be better). - You have tables on which your spend significant time purging older time bound data that could take advantage of rolling window partitions to simplify data management and reduce overhead. - You want/need more than two secondaries. - You need access to distributed data/distributed queries. - You could take advantage of GRID/Sharding technology to distribute a very large database across multiple servers. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 11, 2016 at 12:09 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote: > I understand and know all of the points that you make. > > My question is, what kind of statistics can I look at to say that the > bottleneck is Growth Edition, and the issue will be resolved by going to > Enterprise Edition and gaining the additional resources (cpu and memory and > parallelism)? We are already planning an Upgrading to a later version of > Growth Edition. > > Larry > > ________________________________ > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Carlton Doe > <dbaresrc@xmission.com> > Sent: Monday, July 11, 2016 9:37 AM > To: ids@iiug.org > Subject: Re: IDS Growth vs Enterprise [37415] > > There are two factors to consider. First =E2=80=94 11.5 has entered = > end-of-life. Support will be withdrawn in April 2018 so you might want = > to consider moving to a supported version. > > Second, moving from Workgroup to Enterprise should be based on = > functionality and performance. WGE does not support parallelism, = > fragmentation, parallel Bkup/Restore and other key components that will = > enable the engine environment to run significantly faster.There are also = > resource limitations built into the code that constrain the environment = > as far as CPU power (num CPU VPs) and memory. There is limited HA/DR = > support (2 secondaries) too. Finally distributed operations (query = > to/from another instance) is not supported. Advanced functionality such = > as compression and encryption are not available. > > That said, you can deploy and use timeseries, NoSQL. Whether any of this = > is important to your environment is yours to decide. I=E2=80=99d = > definitely vote for being on a supported version however! :) > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large = > number of electrons were temporarily inconvenienced.=20 > > > On Jul 11, 2016, at 10:03 AM, LARRY SORENSEN <LSORENSEN25@msn.com> = > wrote: > >=20 > > Solaris 10 Sparc=20 > >=20 > > IDS 11.50.FC7=20 > >=20 > > Are there any good statistics to run to determine when it is good to = > graduate=20 > > to Enterprise Edition IDS from Growth Edition IDS?=20 > >=20 > > Larry=20 > >=20 > > ________________________________=20 > >=20 > >=20 > > = > **************************************************************************= > *****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20= > > >=20 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1135b194e3e10205375eaf91

Thank you for the information. A related question - If I have two separate instances running on the same server, from the same $HOME directory installation, does that mean that they are sharing the 16 CPUs and the 16 GB of memory, or do they each get their own resources? Larry ________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel <art.kagel@gmail.com> Sent: Monday, July 11, 2016 10:31 AM To: ids@iiug.org Subject: Re: IDS Growth vs Enterprise [37420] Larry: The things to look at would be: - onstat -g rea -r 1 Are the same sessions in the ready queue for more than a second and you are maxed out at 16 CPU VPS on 16 physical cores (not hyper-threads)? - onstat -g rea typically shows more than a couple of sessions waiting for CPU resources and you are maxed out at 16 CPU VPS on 16 physical cores (not hyper-threads)? - message log messages about not being able to increase shared memory beyond 16GB? - You have tables approaching the 16million page limit and moving the table to wider pages is not a good option (ie partitioning/fragmenting would be better). - You have tables on which your spend significant time purging older time bound data that could take advantage of rolling window partitions to simplify data management and reduce overhead. - You want/need more than two secondaries. - You need access to distributed data/distributed queries. - You could take advantage of GRID/Sharding technology to distribute a very large database across multiple servers. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com<http://www.askdbmgt.com>; ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com This is the site for Art S. Kagel's consultancy. The soaring majesty and beauty in the image above hides the complex ecology and detail of its existence. Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 11, 2016 at 12:09 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote: > I understand and know all of the points that you make. > > My question is, what kind of statistics can I look at to say that the > bottleneck is Growth Edition, and the issue will be resolved by going to > Enterprise Edition and gaining the additional resources (cpu and memory and > parallelism)? We are already planning an Upgrading to a later version of > Growth Edition. > > Larry > > ________________________________ > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Carlton Doe > <dbaresrc@xmission.com> > Sent: Monday, July 11, 2016 9:37 AM > To: ids@iiug.org > Subject: Re: IDS Growth vs Enterprise [37415] > > There are two factors to consider. First =E2=80=94 11.5 has entered = > end-of-life. Support will be withdrawn in April 2018 so you might want = > to consider moving to a supported version. > > Second, moving from Workgroup to Enterprise should be based on = > functionality and performance. WGE does not support parallelism, = > fragmentation, parallel Bkup/Restore and other key components that will = > enable the engine environment to run significantly faster.There are also = > resource limitations built into the code that constrain the environment = > as far as CPU power (num CPU VPs) and memory. There is limited HA/DR = > support (2 secondaries) too. Finally distributed operations (query = > to/from another instance) is not supported. Advanced functionality such = > as compression and encryption are not available. > > That said, you can deploy and use timeseries, NoSQL. Whether any of this = > is important to your environment is yours to decide. I=E2=80=99d = > definitely vote for being on a supported version however! :) > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large = > number of electrons were temporarily inconvenienced.=20 > > > On Jul 11, 2016, at 10:03 AM, LARRY SORENSEN <LSORENSEN25@msn.com> = > wrote: > >=20 > > Solaris 10 Sparc=20 > >=20 > > IDS 11.50.FC7=20 > >=20 > > Are there any good statistics to run to determine when it is good to = > graduate=20 > > to Enterprise Edition IDS from Growth Edition IDS?=20 > >=20 > > Larry=20 > >=20 > > ________________________________=20 > >=20 > >=20 > > = > **************************************************************************= > *****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20= > > >=20 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1135b194e3e10205375eaf91 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Yes. Art On Jul 11, 2016 13:40, "LARRY SORENSEN" <LSORENSEN25@msn.com> wrote: > Thank you for the information. > > A related question - If I have two separate instances running on the same > server, from the same $HOME directory installation, does that mean that > they > are sharing the 16 CPUs and the 16 GB of memory, or do they each get their > own > resources? > > Larry > > ________________________________ > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel > <art.kagel@gmail.com> > Sent: Monday, July 11, 2016 10:31 AM > To: ids@iiug.org > Subject: Re: IDS Growth vs Enterprise [37420] > > Larry: > > The things to look at would be: > > - onstat -g rea -r 1 Are the same sessions in the ready queue for more > > than a second and you are maxed out at 16 CPU VPS on 16 physical cores (not > > hyper-threads)? > > - onstat -g rea typically shows more than a couple of sessions waiting > > for CPU resources and you are maxed out at 16 CPU VPS on 16 physical cores > > (not hyper-threads)? > > - message log messages about not being able to increase shared memory > > beyond 16GB? > > - You have tables approaching the 16million page limit and moving the > > table to wider pages is not a good option (ie partitioning/fragmenting > > would be better). > > - You have tables on which your spend significant time purging older > > time bound data that could take advantage of rolling window partitions to > > simplify data management and reduce overhead. > > - You want/need more than two secondaries. > > - You need access to distributed data/distributed queries. > > - You could take advantage of GRID/Sharding technology to distribute a > > very large database across multiple servers. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com<http://www.askdbmgt.com>; > > ASK Database Management - Home<http://www.askdbmgt.com/>; > www.askdbmgt.com > This is the site for Art S. Kagel's consultancy. The soaring majesty and > beauty in the image above hides the complex ecology and detail of its > existence. > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Mon, Jul 11, 2016 at 12:09 PM, LARRY SORENSEN <LSORENSEN25@msn.com> > wrote: > > > I understand and know all of the points that you make. > > > > My question is, what kind of statistics can I look at to say that the > > bottleneck is Growth Edition, and the issue will be resolved by going to > > Enterprise Edition and gaining the additional resources (cpu and memory > and > > parallelism)? We are already planning an Upgrading to a later version of > > Growth Edition. > > > > Larry > > > > ________________________________ > > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Carlton > Doe > > <dbaresrc@xmission.com> > > Sent: Monday, July 11, 2016 9:37 AM > > To: ids@iiug.org > > Subject: Re: IDS Growth vs Enterprise [37415] > > > > There are two factors to consider. First =E2=80=94 11.5 has entered = > > end-of-life. Support will be withdrawn in April 2018 so you might want = > > to consider moving to a supported version. > > > > Second, moving from Workgroup to Enterprise should be based on = > > functionality and performance. WGE does not support parallelism, = > > fragmentation, parallel Bkup/Restore and other key components that will = > > enable the engine environment to run significantly faster.There are also > = > > resource limitations built into the code that constrain the environment = > > as far as CPU power (num CPU VPs) and memory. There is limited HA/DR = > > support (2 secondaries) too. Finally distributed operations (query = > > to/from another instance) is not supported. Advanced functionality such = > > as compression and encryption are not available. > > > > That said, you can deploy and use timeseries, NoSQL. Whether any of this > = > > is important to your environment is yours to decide. I=E2=80=99d = > > definitely vote for being on a supported version however! :) > > > > Carlton > > > > ------------------------------------------------- > > Carlton Doe > > Flower Mound, TX > > > > No trees were killed in the transmission of this email, however a large = > > number of electrons were temporarily inconvenienced.=20 > > > > > On Jul 11, 2016, at 10:03 AM, LARRY SORENSEN <LSORENSEN25@msn.com> = > > wrote: > > >=20 > > > Solaris 10 Sparc=20 > > >=20 > > > IDS 11.50.FC7=20 > > >=20 > > > Are there any good statistics to run to determine when it is good to = > > graduate=20 > > > to Enterprise Edition IDS from Growth Edition IDS?=20 > > >=20 > > > Larry=20 > > >=20 > > > ________________________________=20 > > >=20 > > >=20 > > > = > > > **************************************************************************= > > *****=20 > > > Forum Note: Use "Reply" to post a response in the discussion forum.=20= > > > > >=20 > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1135b194e3e10205375eaf91 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11444958fe25c505376091ce