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
