Actually good point. The system catalogs were SMS and you cant change them
on a redirected
Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]
"Sathyaram
Sannasi "
<db2udbdba-ezmlms To
hield-x76315791.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
08/18/2004 11:49 Subject
AM 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