RE: DB2EUG: SQL2009C errro on Restore

[Fortier, Christi (USPC.PCT.Hopewell)]

With backups, restores & loads, the more memory you give to util_heap_sz the
faster you'll go. You can avail more memory to util_heap_sz by reducing
dbheap to only the number of databases defines and reducing buffpage
(including those in sysbufferpool that have npages other than -1).  If the
backup is the only process you want running turn on INTRA_PARALLEL (the good
of one is more important than the good of many).  This is especially
important if your DB2 database is EEE.  When you are done, be sure to turn
intra_parallel off again, reduce util_heap_sz and increase your buffpage
sizes.

Good Luck!

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 3: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**


=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod