Fwd: Re: Reorg DB2 catalog/MODIFY run

ravi kumar hassan

Fwd: Re: Reorg DB2 catalog/MODIFY run
TO ME............

Thanks in advance.


>From: [login to unmask email]
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: Reorg DB2 catalog/MODIFY run
>Date: Sun, 2 Jan 2000 11:01:58 EST
>
>to me
>
>
>
>
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



Jr. Donald W. Woodruff

Re: Reorg DB2 catalog
(in response to ravi kumar hassan)
Could you send me a copy also?

Thanks in advance...


--
Donald Woodruff, Jr.
Systems Programmer/Database Administrator
City of Newport News, DP-2nd Fl
2400 Washington Ave, Virginia 23607
Ph: (757) 926-6915
Fax: (757) 926-8433
Email: [login to unmask email]
<mailto:[login to unmask email]>


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
learning DB
Sent: Monday, January 03, 2000 3:58 AM
To: [login to unmask email]
Subject: Re: Reorg DB2 catalog


Please send me a copy too...TIA

--- [login to unmask email] wrote:
> Hi,
>
> let's hope the media-driven Y2K hysteria is over. At
> least it has gotten me 2
> days extra vacation and a nice cash bonus. I have by
> now sent my Cat/Dir Reorg
> jobs to about 40 people, with a couple more
> outstanding. I got some delivery
> failure reports, which I will have to look at later;
> if you have requested the
> JCLs, but have not received them yet or in the next
> one or two days, write me
> again.
>
> The statements 2&3 below are WRONG (at least on DB2
> V5, OS390 R2.6). REPAIR SET
> NOCOPYPEND does work, and I use it in my JCL to copy
> SYSCOPY only once. You need
> the REPAIR privilege, of course; but since the ADMIN
> Guide specifies that you
> even need Install SYSADM authority to START the
> DSNDB01 once it is stopped, that
> should not be a problem. The Utilities Guide does
> not specify any restrictions
> either.
>
> Dr. Michael Ebert
> DB2 Database Administrator
> aMaDEUS Data Processing
> Erding / Munich, Germany
>
>
>
>
> From: Lynette Roberts <[login to unmask email]> on
> 01/01/2000 14:41 GMT
>
>
>
> Please respond to DB2 Data Base Discussion List
> <[login to unmask email]>
>
>
> To: [login to unmask email]
>
>
> cc: (bcc: Michael Ebert/MUC/AMADEUS)
>
>
>
>
> Subject: Re: Reorg DB2 catalog
>
>
>
>
> The "DB2 for OS/390 V5 Utility Guide and Reference"
> specifically talks about
> how reorgs on the system catalog are performed. We
> only had a few gotcha's
> when implementing this:
> 1. almost nothing else can be running in DB2 while
> the reorg was going.
> 2. a "repair set nocopypend" will not work on the
> system catalog -- you
> have to take an imagecopy to reset a copy pending
> flag
> 3. when doing the imagecopy after the reorg,
> SYSCOPY has to be copied
> first, followed by everthing else, followed by a
> backup of SYSCOPY once
> again (since SYSCOPY is updated during the copy
> process)
>
> Other than these minor things, it was pretty
> painless to get this going.
>
>
> To change your subscription options or to cancel
> your subscription visit the
> DB2-L webpage at http://www.ryci.com/db2-l. The
> owners of the list can be
>
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can
>

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://messenger.yahoo.com