RE: DB2EUG: SQL2009C errro on Restore

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

I know parallelism impacts EEE backups whether you put it in dbm or in
backup command and have tests to prove it.

-----Original Message-----
From: Vilas, Ajith (USPC.PCT.Hopewell) [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 2:41 PM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: SQL2009C errro on Restore


I don't think INTRA_PARALLEL has any impact on BACKUP or RESTORE
performance. You can specify the parallelism in the backup/restore command
itself.
Regards,
Ajith

-----Original Message-----
From: Fortier, Christi (USPC.PCT.Hopewell)
[mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 9:07 AM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: SQL2009C errro on Restore


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



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



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