I'd need to know how much memory (real and virrtual) you have. What are the values of: dbheap buffpage (and any npage values for privae buffer pools if any) util_heap_sz They are all in the db cfg. A copy of your command with buffer values. Regards, Pierre. Vijay Kartik wrote: > HI Pierre: > > I am doing "Create Database from Backup image using Redirected Restore". > I tried different values for the buffers and #of buffers in the restore > command. It still fails! > > Any ideas? > > Tks in advance. > > -- Vijay > > ----- Original Message ----- > From: "Pierre Saint-Jacques" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, July 25, 2001 12:05 AM > Subject: Re: DB2EUG: Redirected Restore - SQL2009C Problem ! > > > Vijay, were you doing a tablespace restore with the db online or were > > you doing a full dn restore? > > If the db was online, you could have got the message because DB2 was > > trying to assign both buffer pol memory as well as util_heap memory > > which is used for the restore buffers. > > > > What size buffers and how mmany did you specify in your restore command. > > > > What is (are) the size of your buffer pool(s)? > > How much memory do you have? > > > > Regards, Pierre. > > > > Vijay Kartik wrote: > > > > > Hi: While trying to do a redirected restore, I get SQL2009C error! Any > > > kind of assistance would be of great help.This is on Db2 V7.2 AIX > > > 4.3.3. The error# and the details are given below: db2 => ? SQL2009C > > > SQL2009C There is not enough memory available to run the utility. > > > > > > Explanation: > > > More memory is needed to run the specified utility. The command cannot > > > be processed. > > > > > > User Response: > > > Possible actions include: > > > > > > o Increase the UTIL_HEAP_SZ database configuration parameter. For > > > backup and restore, this value must be at least as high as the number > > > of buffers * buffer size. For more information on backup and restore > > > buffers, refer to the Command Reference. > > > o Verify that your system has sufficient real and virtual memory. > > > o Remove background processes. > > > o Increase the DBHEAP database configuration parameter. > > > > > > Tks! > > > > > > -- Vijay > > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
begin:vcard n:Saint-Jacques;Pierre tel;cell:514-233-8679 tel;fax:514-737-1268 tel;work:514-737-4515 x-mozilla-html:FALSE org:SES Consultants Inc. adr:;;233 Simcoe Cr.;Mount-Royal;QC;H3P 1X1;Canada version:2.1 email;internet:[EMAIL PROTECTED] title:President fn:Pierre Saint-Jacques end:vcard
