infxclone
Peter Logan (AIX 6.1, IDS 12.10.FC3) asked for onconfig settings to get the best throughput when cloning a large database with infxclone. Madison Pruet recommended SMX_COMPRESS 1 and setting BAR_MAX_BACKUP above 1, on both the target and primary servers. Peter had BAR set to 4 to match his storage manager. No further discussion.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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. =
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.
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. =