DB2 backup (400 Views)
Reply
Frequent Advisor
BackupDude
Posts: 38
Registered: ‎12-28-2011
Message 1 of 2 (400 Views)
Accepted Solution

DB2 backup

Hello,

 

Can you guys please tell me how I can increase the buffersize for a DB2 backup using DP7?

 

I am trying to get rid of this error:

 

[Major] From: OB2BAR_DB2BAR@****

DB2 returned error:

SQL2007N  Specified buffersize of "8" 4K buffers is too small for "32768" page 

size object.

 

Thanks for any reply!

 

Frequent Advisor
BackupDude
Posts: 38
Registered: ‎12-28-2011
Message 2 of 2 (368 Views)

Re: DB2 backup

Hi,

No reply  so I contacted HP support.

It turns out there are 2 variables for the .omnirc file that are not listed in the template file.

 

OB2_DB2BUFFSIZE can be used to change the value of buffer size

OB2_DB2BUFFNUM to change the number of buffers.

 

I used the first one and it fixed my issue.

 

Hope it helps others.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.