Backup fails with SQL2007N error message

Technote (troubleshooting)


Problem(Abstract)

DB2 Backup command fails with SQL2007N buffers is too small for page size object error message.

Symptom

An error similar to the following will be returned:

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

Cause

Utility heap size too small for backup

Resolving the problem

Increase the UTIL_HEAP_SZ parameter to size shown in error and rerun the backup command. From the error message shown above the value would need to be set to 32768:


1. Increase the database configuration parameter UTIL_HEAP_SZ to 32768

  • db2 connect to database <DBNAME>
  • db2 update DB CFG for <DBNAME> using UTIL_HEAP_SZ 32768
  • db2 terminate
2. Rerun the backup command.

Related information

UTIL_HEAP_SZ Parameter
UPDATE DATABASE CONFIGURATION
SQL2007N

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.1, 9.5, 9.7

Operating system(s):

AIX, HP-UX, Linux, Linux iSeries, Linux pSeries, Linux zSeries, Solaris, Windows

Reference #:

1442778

Modified date:

2012-11-10

Translate my page

Machine Translation

Content navigation