Shirley,
I had the same error.
Follow the fowllowing script.
restore db DBNAME user DBID using PASSWORD
from c:\db2bkp taken at 20010619011521
to d: into NEWDBNAME with 2 buffers
buffer 1024 without prompting
redirect;
set tablespace containers for 0 using (path
"d:\devintra0");
set tablespace containers for 1 using (path
"d:\devintra1");
set tablespace containers for 2 using (path
"d:\devintra2");
set tablespace containers for 3 using (path
"d:\devintra3");
restore db DBNAME continue;
Thanks,
Mathai Joy
--- [EMAIL PROTECTED] wrote:
>
> -------------- BEGIN db2eug.v002.n112 --------------
>
> 001 - "Shirley Fan" <shirley.fa - callerac
> parameter in the restore redirect
> 002 - [EMAIL PROTECTED] - RE: DB2EUG:
> callerac parameter in the restore redirect
> 003 - "Trupti Patel" <tpatel@Me - RE: DB2EUG:
> How to determine size of database in UDB?
>
> ===========================================
> DB2EUG DIGEST
> http://people.mn.mediaone.net/scottrmcleod/
> For subscription info see bottom of message
> ===========================================
>
>
> --------------- MESSAGE db2eug.v002.n112.1
> ---------------
>
> From: "Shirley Fan" <[EMAIL PROTECTED]>
> Subject: callerac parameter in the restore redirect
> Date: Thu, 5 Jul 2001 10:58:53 +1000
> MIME-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
>
> Hi all,
> My enironment is UDB V7.1 with fp3 running on NT.
>
> I tried to restore a db using redirect option with
> the following steps :
> 1. db2 restore DB dbprod from c:\db2\backup taken
> at ...... into dbtest
> redirect without rolling forward;
> 2. db2 set tablespace containers for x using
> ('path .............')
> 3. db2 restore db dbprod continue;
>
> My job failed at the step 3 (due to incorrect db
> name specified).
> When I tried to rerun the job (from step 1) and I
> encountered the
> error saying :
>
> SQL2008N The callerac parameter is not within valid
> range or the requested
> action is out of sequence.
>
> What is the error message meant ? and how to
> overcome the problem ?
> I tried to rerun the job from the step 3 but still
> got the same error.
>
> Any help will be appreciated.
>
> Regards,
> Shirley.
>
>
>
>
>
> --------------- MESSAGE db2eug.v002.n112.2
> ---------------
>
> From: [EMAIL PROTECTED]
> Subject: RE: DB2EUG: callerac parameter in the
> restore redirect
> Date: Thu, 5 Jul 2001 07:42:51 -0400
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> Shirley,
>
> you need to issue a db restore dbprod abort. This
> will terminate your first
> redirected restore. I assume that x in your set
> tablespace containers
> refers to a tablespace id. Path needs to be out of
> the quotation marks.
> e.g. (path '.......'). Did you get a set tablespace
> containers successful
> ?
>
> Rakesh
>
> > -----Original Message-----
> > From: Shirley Fan
> [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 04, 2001 8:59 PM
> > To: [EMAIL PROTECTED]
> > Subject: DB2EUG: callerac parameter in the restore
> redirect
> >
> >
> > Hi all,
> > My enironment is UDB V7.1 with fp3 running on NT.
> >
> > I tried to restore a db using redirect option with
> the
> > following steps :
> > 1. db2 restore DB dbprod from c:\db2\backup
> taken at
> > ...... into dbtest
> > redirect without rolling forward;
> > 2. db2 set tablespace containers for x using
> ('path .............')
> > 3. db2 restore db dbprod continue;
> >
> > My job failed at the step 3 (due to incorrect db
> name specified).
> > When I tried to rerun the job (from step 1) and I
> encountered the
> > error saying :
> >
> > SQL2008N The callerac parameter is not within
> valid range or
> > the requested
> > action is out of sequence.
> >
> > What is the error message meant ? and how to
> overcome the problem ?
> > I tried to rerun the job from the step 3 but still
> got the same error.
> >
> > Any help will be appreciated.
> >
> > Regards,
> > Shirley.
> >
> >
> >
> >
> > =====
> > To unsubscribe, send 'unsubscribe' to
> [EMAIL PROTECTED]
> > For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
>
> --------------- MESSAGE db2eug.v002.n112.3
> ---------------
>
> From: "Trupti Patel" <[EMAIL PROTECTED]>
> Subject: RE: DB2EUG: How to determine size of
> database in UDB?
> Date: Thu, 5 Jul 2001 10:41:22 -0400
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
>
> Judith,
> What I have been told is to execute a du -k on
> the directory where
> your daily database backups reside. This will give
> you the
> data+index+overhead. If you want size information
> by tablespace, then go
> into each directory where your tablespace data
> resides(di) and execute a du
> -k. Again, this is not like the mainframe. I have
> yet to see an exact
> calculation of the database like we used to on the
> main frame :-). Hope
> this helps!
>
> Trupti.
>
>
>
>
> [EMAIL PROTECTED]@lists1.ba.best.com on
> 07/02/2001 12:58:46 PM
>
> Please respond to [EMAIL PROTECTED]
>
> Sent by: [EMAIL PROTECTED]
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject: RE: DB2EUG: How to determine size of
> database in UDB?
>
>
>
>
> Thanks for the reply Abhijit! I wonder, though.
> Won't that give me
> somewhat of
> a skewed view of actual usage? That will show the
> number of pages with
> data on
> them, but the whole page might not be full, right?
>
>
>
>
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
