Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Highlighted
Absent Member.. BackupDude Absent Member..
Absent Member..
760 views

DB2 backup

Jump to solution

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!

 

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Absent Member.. BackupDude Absent Member..
Absent Member..

Re: DB2 backup

Jump to solution

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.

0 Likes
1 Reply
Absent Member.. BackupDude Absent Member..
Absent Member..

Re: DB2 backup

Jump to solution

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.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.