On Dec 6, 6:29 pm, "Mark A" <nob...@nowhere.com> wrote:
> "Steve Pearson (news only)" <stevep...@my-deja.com> wrote in messagenews:a0d1ce8c-0985-4969-b80f-bd34461771fb@b15g2000hsa.googlegroups.com...
>
> > In order to get a clean split, you'd want to deactivate the standby
> > first. With that minor tweak, it should work, as long as you are
> > careful to split/copy absolutely all storage related to the database
> > (tablespaces, db dir, logs, procedure libraries, etc and so forth).
>
> > Regards,
> > - Steve P.
> > --
> > Steve Pearson, DB2 for Linux, UNIX, and Windows, IBM Software Group
> > "Portland" Development Team, IBM Beaverton Lab, Beaverton, OR, USA
>
> Thanks Steve.
>
> Do I have to do an initdb on the new copy? If so, what if I don't include
> the logs in the split mirror and then just rsynch (copy) the logs over to
> the new copy before I do the initdb. Also, if I only have V8.2+ SQL stored
> procedures, do I have to worry about the procedure libs?
>
> I will give this a try as soon as I get my storage people to create the
> mirror.

Mark
check out the following white paper which describes how to make a copy
of the HADR standby
www.netapp.com/library/tr/3494.pdf
Since the set write suspend was not issued on the standby you do not
need to run db2inidb.

Dale McInnis