Hi,
Make sure if it is container or file and like wise use following set
commands:
set tablespace containers for 2 using (file '/home/db2/USERSPACE1' 30960)
or
set tablespace containers for 0 using (PATH '/home/db2/container0')
Regards,
Prashant
-----Original Message-----
From: Sathyaram Sannasi
To: LazyDBA Discussion
Sent: 08/18/2004 10:49 AM
Subject: RE: DB2 Redirected Restore with Multiple Containers
was it DMS file container on the original database ???
Sathyaram Sannasi
-----Original Message-----
From: Don Morris
[mailto:db2udbdba-ezmlmshield-x69681937.[Email address protected]
Sent: 18 August 2004 16:22
To: LazyDBA Discussion
Subject: Re: DB2 Redirected Restore with Multiple Containers
Daniel,
I was trying to set the PATH before doing the Allocation, so I go to set
the
Allocation:
set tablespace containers for 0 using (file
'C:\DB2\NODE0000\SQL00001\SQLT0003.0\TS_SYSCAT.dat' 5000)
but continue to get BAD CONTAINER PATH, any idea why?
Thanks,
Don
----- Original Message -----
From: "DANIEL CALLAHAN" <[Email address protected]
To: "Don Morris" <[Email address protected]
Sent: Wednesday, August 18, 2004 9:40 AM
Subject: Re: DB2 Redirected Restore with Multiple Containers
>
>
>
>
> When you do the "set" on the redirected restore, it is assumed that
what
> ever you set it to exists.
>
> Dan Callahan IT Specialist
> 603-472-4121 t/l 525-4121
> [Email address protected]
> [Email address protected]
>
>
>
>
> "Don Morris"
> <[Email Address Removed] praisal.com>
To
> DANIEL
CALLAHAN/Bedford/[Email Address Removed] 08/18/2004 10:27
cc
> AM
>
Subject
> Re: DB2 Redirected Restore with
> Multiple Containers
>
>
>
>
>
>
>
>
>
>
> Daniel,
> thanks for the reply. I am brand new at doing redirected restores,
wish I
> would have found this months ago. :-)
>
> So when I am setting up Container 0, which is the SysCat, it could
take a
> long time? Do the directories need to
> be setup or will DB2 set it up for me if it doesn't exist?
>
> Thanks,
> Don
> ----- Original Message -----
> From: "DANIEL CALLAHAN " <[Email address protected]
> To: <[Email address protected]
> Sent: Wednesday, August 18, 2004 9:19 AM
> Subject: Re: DB2 Redirected Restore with Multiple Containers
>
>
> > **A LazyDBA.com subscriber has responded to your lazydba.com post**
> > **LazyDBA.com mail shield has forwarded you this email,
> > **and removed any attachments, and kept your email address secret
> > **from this person, and any viruses/trojans.
> > **If you reply to this email, the person will see your email address
as
> normal
> > **Anything below this line is the original email text
> >
> >
> >
> >
> >
> >
> > It does take a long time for non-raw tablespaces. I have seen it
take
> hours
> > as it has to format the whole area before it starts
> > the actual restore.
> >
> > Dan Callahan IT Specialist
> > 603-472-4121 t/l 525-4121
> > [Email address protected]
> > [Email address protected]
> >
> >
> >
> >
> > "Don Morris "
> > <db2udbdba-ezmlms
> > hield-x38434424.x
> To
> > [Email Address Removed] "LazyDBA Discussion"
> > a.com> <[Email address protected]
> >
> cc
> > 08/18/2004 10:10
> > AM
> Subject
> > DB2 Redirected Restore with
> > Multiple Containers
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I have a large(44gb) DB2 database v8.1 and need to clone this
database
on
> a
> > Test machine. I have used the restore with redirect and that seemed
to
> > work fine. When I issue the first Tablespace Path for Container 0,
it
> just
> > runs forever. Any ideas of how long establishing a path should take
and
> > what the problem might be?
> >
> > Thanks,
> >
> > Don Morris
> > Beyond Appraisal, Inc.
> >
> >
> >
---------------------------------------------------------------------
> > PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> > website: http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> >
> >
>
>
>
>
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views
and
opinions, which do not necessarily reflect those of HPI Limited. If you
are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing,
or
copying of this email is strictly prohibited. If you received this email
in
error, please immediately notify [Email address protected]
This message has been scanned by Panda Anti-Virus. Recipients are
advised to
apply their own virus checks to this message on delivery.
**********************************************************************
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page