Hi Pierre:
I have solved the SQL2009C problem.
The reason was because I had given high values for the "WITH BUFFERS" and
"BUFFER" parameter in the RESTORE command.
Also, due to the problem with the Used Pages Vs. High-Water Mark for the
tablespaces, I had problems in creating devices with the size of "USED
PAGES". To fix this, ran the db2dart with /LHWM option to reset the
high-water mark. Then took a backup of the database, move it to the new
server and did a redirected restore.
It worked!
Thanks SO much for the help.
Regards,
Vijay
----- Original Message -----
From: "Pierre Saint-Jacques" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 12:32 PM
Subject: Re: DB2EUG: Redirected Restore - SQL2009C Problem !
> 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
>
_________________________________________________________
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
