Reorg DB2 catalog/MODIFY run

tuvinh chang

Reorg DB2 catalog/MODIFY run
Hi,
Can you also forward the attachment to me?
Thanks,
Tu-Vinh Chang
California, USA

Attachments

  • import1 (<1k)

tuvinh chang

Re: Reorg DB2 catalog/MODIFY run
(in response to KATIKAN@AOL.COM)
Hi,
Can you also forward the attachment to me?
Thanks,
Tu-Vinh Chang
California, USA

Attachments

  • import1 (<1k)

[login to unmask email]

Re: Reorg DB2 catalog/MODIFY run
(in response to tuvinh chang)
to me



Michael Ebert

Re: Reorg DB2 catalog
(in response to tuvinh chang)
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.








learning DB

Re: Reorg DB2 catalog
(in response to Michael Ebert)
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