RE: DB2EUG: SQL2009C errro on Restore

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

OK, publicly flog me.  Looking back on my results, I noticed my 10%
performance improvement was with a combined reorg & backup.  The reorg takes
advantage of the intra_parallel being on since it is query oriented.  Backup
only takes advantage of the catalog query aspects of it.
UTIL_HEAP_SZ & numdb settings still hold true.
  
So payback, I looked up Dale McInnis(IBM lab) presentation on backups from
last US IDUG.  Here are his recommended performance guidelines (that have
not been mentioned yet):
 Backup/restore guidelines:
 -  Use a buffer size which is a multiple of the extent size + 1
 -  Use multiple targets/sources
    . When using vendor storage support, e.g. TSM, do not start ,pre
sessions than there are physical tape drives
 -  Number of buffers should at least 
    . # of targets + Parallelism setting + 2

Backup specific guidelines:
 - Use Parallelism option to read data in parallel
   . Each thread/process will be assigned to a tablespace
   . Should be no greater thant the number of targets being writeen to or
the number of tablespaces in the database.
...
The more hardware you throw at backup/recover, the faster it will run.

Sorry for the senior moment all :{.
-----Original Message-----
From: Fortier, Christi (USPC.PCT.Hopewell)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 6:54 AM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: SQL2009C errro on Restore


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



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