Thanks for all the replies! The database I am trying to restore was dropped, so all I have to work with is a backup image. I can only adjust DBM CFG, but Utl_heap_sz is a DB CFG parameter. (Though I remember it was set at 10000 at the time of backup operation, and was not changed till the database was dropped.) Any ideas? Thanks. Jiang Tong [EMAIL PROTECTED] Champaign, IL "Gray, Paul" <[EMAIL PROTECTED]> on 09/23/2001 06:49:42 PM Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: (bcc: Jiang Tong/mbsgroup/CDG) Subject: RE: DB2EUG: SQL2009C errro on Restore Both backup's and restore's use the utilily heap for their buffers. Hence, utl_heap_sz must be larger than the number of buffers multiplied by the buffersize. If you are specifying neither the "buffsize" or "buffers" parameters on your restore, the utl_heap_sz must be atleast 8192 since RESTBUFSZ is set to 8192 in your db config. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 4:52 PM To: [EMAIL PROTECTED] Subject: DB2EUG: SQL2009C errro on Restore Hi all, Platform: Win NT DB2 V7.2 - I got a SQL2009C (not enough memory to run this utility) when I tried to restore a database from backup image. Below is the DBM CFG file of the instance I am working on. (See attached file: cfg.txt) I had the same error earlier when I used BACKUP command on the same data, then after I increased DBHEAP to 40000 and UTIL_HEAP_SZ to 10000, it went away. Any help would be appreciated. Thanks. Jiang Tong [EMAIL PROTECTED] Champaign, IL **PLEASE NOTE THAT OUR EMAIL ADDRESSES HAVE CHANGED**Title: RE: DB2EUG: SQL2009C errro on Restore
Both backup's and restore's use the utilily heap for their buffers. Hence, utl_heap_sz must be larger than the number of buffers multiplied by the buffersize. If you are specifying neither the "buffsize" or "buffers" parameters on your restore, the utl_heap_sz must be atleast 8192 since RESTBUFSZ is set to 8192 in your db config.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 4:52 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG: SQL2009C errro on Restore
Hi all,
Platform: Win NT DB2 V7.2 - I got a SQL2009C (not enough memory to run
this utility) when I tried
to restore a database from backup image. Below is the DBM CFG file of the
instance I am working on.
(See attached file: cfg.txt)
I had the same error earlier when I used BACKUP command on the same data,
then after I increased DBHEAP
to 40000 and UTIL_HEAP_SZ to 10000, it went away.
Any help would be appreciated.
Thanks.
Jiang Tong
[EMAIL PROTECTED]
Champaign, IL
**PLEASE NOTE THAT OUR EMAIL ADDRESSES HAVE CHANGED**
