ON-Bar parallelization

Hello folks I am looking at using onbar to take advantage of the parallelization. Looking at the example at this address http://www.ibm.com/developerworks/data/library/techarticle/dm-0611sinha/index.ht ml the implication is onbar backs up the chunks in the dbpace in parallel. I thought onbar backed up the dbspaces in parallel the example 1.Example with Large dbspaces: In this example, suppose we have, userdbs1 40 GB userdbs2 40 GB userdbs3 20 GB With layout as above, when Onbar is backing up userdbs1, only one thread is associated with this backup. This will leave other Onbar threads idle. Comments please suggestions

Hi Karl, You should set de parameter in the onconfig file BAR_MAX_BACKUP to the number of dbspaces you want to backup in parallel. Do you have the rootdbs? It's recommended to keep the primary dbspace as default named rootdbs. When the onbar starts it backs up the rootdbs first alone, after it finishes, it starts the quantity configured in the BAR_MAX_BACKUP in parallel.In my case I keep the rootdbs as small as I can. Best Regards, Celso Cabral Coimbra Administrador de Banco de Dados ClearTech Ltda "Trust at the heart of Communications" Tel. (11) 3576-4509 -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de KARL OLIVER Enviada em: domingo, 12 de dezembro de 2010 20:46 Para: ids@iiug.org Assunto: ON-Bar parallelization [22192] Hello folks I am looking at using onbar to take advantage of the parallelization. Looking at the example at this address http://www.ibm.com/developerworks/data/library/techarticle/dm-0611sinha/index.ht ml the implication is onbar backs up the chunks in the dbpace in parallel. I thought onbar backed up the dbspaces in parallel the example 1.Example with Large dbspaces: In this example, suppose we have, userdbs1 40 GB userdbs2 40 GB userdbs3 20 GB With layout as above, when Onbar is backing up userdbs1, only one thread is associated with this backup. This will leave other Onbar threads idle. Comments please suggestions ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, not sure which version of Informix Server you are using. Please be aware that not all Editions allow ON-Bar parallel operations. I think there were some changes to this effect with the most recent licensing model. Apart from this the parallelization of ON-Bar operation is on the level of dbspaces (not chunks). I.e. backing up several dbspaces with a single ON-Bar command would backup these dbspaces in parallel. An exception to this is the root dbspace. If it is within the group of dbspaces to be backed up, then it will be backed up first and alone. After its backup has finished other dbspaces will then be backed up in parallel. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management -- Go Cruising with Informix in 2011 ... -- IIUG Informix Conference -- Overland Park Marriott, Kansas -- May 15 - 18, 2011 IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martin Jetter Board of Management: Dirk Wittkopp Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 ids-bounces@iiug.org wrote on 12/12/2010 11:46:16 PM: > > Hello folks > I am looking at using onbar to take advantage of the parallelization. > Looking at the example at this address > > > http://www.ibm.com/developerworks/data/library/techarticle/dm-0611sinha/index.ht ml > the implication is onbar backs up the chunks in the dbpace in parallel. > > I thought onbar backed up the dbspaces in parallel > the example > > 1.Example with Large dbspaces: > In this example, suppose we have, > userdbs1 40 GB > userdbs2 40 GB > userdbs3 20 GB > With layout as above, when Onbar is backing up userdbs1, only one thread is > associated with this backup. This will leave other Onbar threads idle. > > Comments please suggestions > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >