DP - DB2 Backup is failing

  • KM00426538
  • 11-May-2013
  • 11-May-2013

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

DB2 integration running on Linux produces error

Error

[Major] From: OB2BAR_DB2BAR@mysys.hp.com "db2inst1" Time: 6/8/2012 13:56:59
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.