Adding/(re)moving/changing log datasets

Raymond Bell

Adding/(re)moving/changing log datasets
Colleagues,

It must be a sign of the silly season and having imbibed too much alcohol,
but I can't find in the DB2 V5 manuals a section detailing how to muck
around with the active log datasets. I'm assuming anything I want to do
will involve stopping DB2, IDCAMS defines and repros, but I'd really like
to see what the manual has to say. Any pointers?


Raymond



teldb2kals

Re: Adding/(re)moving/changing log datasets
(in response to Raymond Bell)
Raymond,

Have u tried the Utilities Manual - Change Log Inventory utility
section ?

Cheers,
Kals


-----Original Message-----
From: Raymond Bell [SMTP:[login to unmask email]
Sent: Wednesday, December 19, 2001 8:09 AM
To: [login to unmask email]
Subject: Adding/(re)moving/changing log datasets

Colleagues,

It must be a sign of the silly season and having imbibed too much
alcohol,
but I can't find in the DB2 V5 manuals a section detailing how to muck
around with the active log datasets. I'm assuming anything I want to do
will involve stopping DB2, IDCAMS defines and repros, but I'd really
like
to see what the manual has to say. Any pointers?


Raymond


----------------
Powered by telstra.com



Raymond Bell

Re: Adding/(re)moving/changing log datasets
(in response to teldb2kals)
Yep, saw that. And also DSNJLOGF. Maybe I'm looking for more detail than
there is. All I really want to do is move them, 'cause they're on volumes
they shouldn't really be on. I'm about to try stopdb2, adrdssu, startdb2
on our bash-it-till-it-bleeds subsystem. Adding new logs, extending logs,
etc. is more than I want to do just now. But thanks for the pointer.


Raymond



teldb2kals
<[login to unmask email] To: [login to unmask email]
LSTRA.COM> cc:
Sent by: DB2 Subject: Re: Adding/(re)moving/changing log datasets
Data Base
Discussion
List
<[login to unmask email]
M>


19/12/01 12:22
Please respond
to DB2 Data
Base
Discussion
List





Raymond,

Have u tried the Utilities Manual - Change Log Inventory utility
section ?

Cheers,
Kals



Martin Berchtold

Re: Adding/(re)moving/changing log datasets
(in response to Raymond Bell)
Raymond,

if you don't want to change the names of the logs, the only things what you
have to do is stop DB2, define the new log datasets, repro the old into the
new one's, rename the old and new log datasets and start db2 again.

But if you want to use new names, then you have to delete the old logs in
BSDS and define the newlogs with the new name in BSDS, with startrbd and
endrba.
e.g.
NEWLOG DSNAME=TDB2P.DB2.PROD.LOGCOPY1.DS01,COPY1,
STARTRBA=032922912000,ENDRBA=03293085DFFF
NEWLOG DSNAME=TDB2P.DB2.PROD.LOGCOPY2.DS01,COPY2,
STARTRBA=032922912000,ENDRBA=03293085DFFF
.
.
and so on.

Hth.

Martin

P.s.
If you win the jackpot, I will send you my bank account !!!



Barb J. Zander

Re: Adding/(re)moving/changing log datasets
(in response to Martin Berchtold)
This will work. I have used it several times just to move the logs.

Barb

-----Original Message-----
From: Raymond Bell [mailto:[login to unmask email]
Sent: Tuesday, December 18, 2001 7:04 PM
To: [login to unmask email]
Subject: Re: Adding/(re)moving/changing log datasets


Yep, saw that. And also DSNJLOGF. Maybe I'm looking for more detail than
there is. All I really want to do is move them, 'cause they're on volumes
they shouldn't really be on. I'm about to try stopdb2, adrdssu, startdb2
on our bash-it-till-it-bleeds subsystem. Adding new logs, extending logs,
etc. is more than I want to do just now. But thanks for the pointer.


Raymond



teldb2kals
<[login to unmask email] To: [login to unmask email]
LSTRA.COM> cc:
Sent by: DB2 Subject: Re:
Adding/(re)moving/changing log datasets
Data Base
Discussion
List
<[login to unmask email]
M>


19/12/01 12:22
Please respond
to DB2 Data
Base
Discussion
List





Raymond,

Have u tried the Utilities Manual - Change Log Inventory utility
section ?

Cheers,
Kals








Raymond Bell

Re: Adding/(re)moving/changing log datasets
(in response to Barb J. Zander)
Hi Barb/Martin/Kals,

Thanks for the info. All I want to do is move them, so hopefully I don't
have to define new names, repro in, etc. but just ADRDSSU the fu, er,
suckers. I've got problems with ACS routines grabbing the logs and putting
them elsewhere, but it does seem to work.

Cheers,


Raymond
PS. Martin, bought my ticket yesterday...



Kirk Hampton

Re: Adding/(re)moving/changing log datasets
(in response to Raymond Bell)
Hi Raymond,
I have moved every type of DB2 dataset there is using ADRDSSU,
with no problems, (other than the ACS rules you mentioned) as long as
you either stop the tablespace you are moving, or stop the DB2 subsystem,
in the case of logs or BSDS's.

Kirk Hampton
DB2 OS/390 Sysprog
IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390
TXU Energy Services
Dallas, Texas






Raymond Bell <[login to unmask email]> on 12/19/2001 02:50:06 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Kirk Hampton/BIZSRV/TXU)
Subject: Re: Adding/(re)moving/changing log datasets



Hi Barb/Martin/Kals,

Thanks for the info. All I want to do is move them, so hopefully I don't
have to define new names, repro in, etc. but just ADRDSSU the fu, er,
suckers. I've got problems with ACS routines grabbing the logs and putting
them elsewhere, but it does seem to work.

Cheers,


Raymond
PS. Martin, bought my ticket yesterday...








Raymond Bell

Re: Adding/(re)moving/changing log datasets
(in response to Kirk Hampton)
Hi Kirk,

Thanks for the confirmation. I've managed to stop DB2, move one copy of
the active logs, start DB2 and do some table updates (verifying DB2 can log
my changes OK) and it all seems pretty hunky dory. Can't wait for our
change freeze to end so I can run amok in Production...


Raymond



[login to unmask email]
OM To: [login to unmask email]
Sent by: DB2 cc:
Data Base Subject: Re: Adding/(re)moving/changing log datasets
Discussion
List
<[login to unmask email]
M>


21/12/01 10:25
Please respond
to DB2 Data
Base
Discussion
List





Hi Raymond,
I have moved every type of DB2 dataset there is using ADRDSSU,
with no problems, (other than the ACS rules you mentioned) as long as
you either stop the tablespace you are moving, or stop the DB2 subsystem,
in the case of logs or BSDS's.

Kirk Hampton
DB2 OS/390 Sysprog
IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390
TXU Energy Services
Dallas, Texas