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**
