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
Related information
UTIL_HEAP_SZ Parameter
UPDATE DATABASE CONFIGURATION
SQL2007N
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.