infxclone

Posted in 2014

Topics: Performance & Tuning, Server Administration, Platform-Specific Issues

Peter_Logan@spartanstores.com — Wed, 18 Jun 2014 15:37:10 — source: IIUG Forums & Mailing Lists

Aix 6.1 IDS 12.10.fc3 Looking to run some performance tests cloning a large database. Are there any recommended onconfig parameters needing to be tweeked in order to bet the most optimal throughput? Thanks for any help ... Peter Logan Database Administrator SpartanNash INC. Office: 616/878-8309 Mobile: 616/304-9672

↪ replying to Peter_Logan@spartanstores.com

Madison Pruet — Wed, 18 Jun 2014 15:49:19 — source: IIUG Forums & Mailing Lists

1) SMX_COMPRESS 1 2) Set BAR_MAX_BACKUP greater than 1. = From: "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstore= s.com> = To: ids@iiug.org, = = Date: 06/18/2014 09:37 AM = = Subject: infxclone [33231] = = Sent by: ids-bounces@iiug.org = = Aix 6.1 IDS 12.10.fc3 Looking to run some performance tests cloning a large database. Are the= re any recommended onconfig parameters needing to be tweeked in order to b= et the most optimal throughput? Thanks for any help ... Peter Logan Database Administrator SpartanNash INC. Office: 616/878-8309 Mobile: 616/304-9672 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Madison Pruet

Peter_Logan@spartanstores.com — Wed, 18 Jun 2014 15:53:39 — source: IIUG Forums & Mailing Lists

Thanks ... Couple of follow up questions ... Should these be set on both the target and primary servers ... and then is there a general guideline for the BAR parameter ... On this particular server we generally have that set to 4 as that is what our storage manager is allowing ... Peter Logan Database Administrator SpartanNash INC. Office: 616/878-8309 Mobile: 616/304-9672 From: "Madison Pruet" <mpruet@us.ibm.com> To: ids@iiug.org Date: 06/18/2014 11:49 AM Subject: Re: infxclone [33232] Sent by: ids-bounces@iiug.org 1) SMX_COMPRESS 1 2) Set BAR_MAX_BACKUP greater than 1. = From: "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstore= s.com> = To: ids@iiug.org, = = Date: 06/18/2014 09:37 AM = = Subject: infxclone [33231] = = Sent by: ids-bounces@iiug.org = = Aix 6.1 IDS 12.10.fc3 Looking to run some performance tests cloning a large database. Are the= re any recommended onconfig parameters needing to be tweeked in order to b= et the most optimal throughput? Thanks for any help ... Peter Logan Database Administrator SpartanNash INC. Office: 616/878-8309 Mobile: 616/304-9672 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. = ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Peter_Logan@spartanstores.com

Madison Pruet — Wed, 18 Jun 2014 20:48:10 — source: IIUG Forums & Mailing Lists

Yes - on both. = From: "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstore= s.com> = To: ids@iiug.org, = = Date: 06/18/2014 09:54 AM = = Subject: Re: infxclone [33233] = = Sent by: ids-bounces@iiug.org = = Thanks ... Couple of follow up questions ... Should these be set on both the target and primary servers ... and then= is there a general guideline for the BAR parameter ... On this particular server we generally have that set to 4 as that is what our storage mana= ger is allowing ... Peter Logan Database Administrator SpartanNash INC. Office: 616/878-8309 Mobile: 616/304-9672 From: "Madison Pruet" <mpruet@us.ibm.com> To: ids@iiug.org Date: 06/18/2014 11:49 AM Subject: Re: infxclone [33232] Sent by: ids-bounces@iiug.org 1) SMX_COMPRESS 1 2) Set BAR_MAX_BACKUP greater than 1. =3D From: "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstore=3D s.com> =3D To: ids@iiug.org, =3D =3D Date: 06/18/2014 09:37 AM =3D =3D Subject: infxclone [33231] =3D =3D Sent by: ids-bounces@iiug.org =3D =3D Aix 6.1 IDS 12.10.fc3 Looking to run some performance tests cloning a large database. Are the= =3D re any recommended onconfig parameters needing to be tweeked in order to b= =3D et the most optimal throughput? Thanks for any help ... Peter Logan Database Administrator SpartanNash INC. Office: 616/878-8309 Mobile: 616/304-9672 ***********************************************************************= =3D ******** Forum Note: Use "Reply" to post a response in the discussion forum. =3D ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Glossary

onconfig