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