This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
Error
DB2 returned error:
SQL2007N Specified buffersize of "8" 4K buffers is too small for "32768"
page
size object.
Cause
DB2 buffer sizes were set to the defaults
[199] Environment variable OB2_DB2BUFFNUM not found
[199] Keeping default value = 2
[199] Environment variable OB2_DB2BUFFSIZE not found
[199] Keeping default value = 8
Fix
Add these lines to the file
/opt/omni/.omnirc
on the DB2 Server
OB2_DB2BUFFSIZE=1024
OB2_DB2BUFFNUM=64
Note: Buffer size during restore must be same or positive integer multiple of backup buffer size. If you increase the buffer number or size, you can encounter SQL2009C error. If you do encounter it, change database configuration parameter UTIL_HEAP_SZ. It should be bigger than buffer size * buffernum. Because now default buffer size is smaller, it has to be set via OB2_DB2BUFFSIZE to 1024, while restoring backup images performed before the changes.