DB2 UDB for Multiplatforms - Running Backups or Reorgs ?

Richard McCutcheon

DB2 UDB for Multiplatforms - Running Backups or Reorgs ?
Hi Listers...

I am running various versions of DB2 UDB for AIX on multiple servers, and
run most of my DB2 maintenance jobs as homegrown Korn Shell scripts
scheduled in Cron.

My question is 'What other ways do people perform backups, reorgs, and
runstats?'. I understand that you can buy scheduling tools, and write
programs in other languages, and also use the Control Centre and associated
IBM tools.

Can people relate their experiences or preferences to me? I am trying to
find a more central and simple way to perform these maintenance activities.


Thanks in advance,
Richard McCutcheon.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dan Michaelis

Re: DB2 UDB for Multiplatforms - Running Backups or Reorgs ?
(in response to Richard McCutcheon)
I'm always a fan of shell scripts for getting things done. Everywhere I've
ever worked, folks didn't want to spend the money for tools if they could
make the DBA's write them, and then blame the DBA if the tools didn't work.

My personal belief is that it's worth getting a tool for monitoring (we used
BMC Patrol, but I honestly don't know if that one is any better than any
others; it was what was in place when I got there, and we had spent too much
money to change it), but that for doing things like backups, runstats, etc.,
you retain more control if you've written them yourself. The tools that
I've worked with didn't provide a lot of value-add over what I could write
myself, and management didn't see spending money to buy what they could make
me write for "free"...

That said, if you can get someone to pay for a tool, instead of making you
write it, I'd go that direction.

Thanks.

Dan Michaelis

Database Administrator/Developer
eOriginal
351 West Camden Street
Suite 800
Baltimore, MD 21201

410.625.5187 (phone)
410.659.9799 (fax)


-----Original Message-----
From: Richard McCutcheon [mailto:[login to unmask email]
Sent: Wednesday, December 01, 2004 2:13 PM
To: [login to unmask email]
Subject: DB2 UDB for Multiplatforms - Running Backups or Reorgs ?

Hi Listers...

I am running various versions of DB2 UDB for AIX on multiple servers, and
run most of my DB2 maintenance jobs as homegrown Korn Shell scripts
scheduled in Cron.

My question is 'What other ways do people perform backups, reorgs, and
runstats?'. I understand that you can buy scheduling tools, and write
programs in other languages, and also use the Control Centre and associated
IBM tools.

Can people relate their experiences or preferences to me? I am trying to
find a more central and simple way to perform these maintenance activities.


Thanks in advance,
Richard McCutcheon.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Richard McCutcheon

Re: DB2 UDB for Multiplatforms - Running Backups or Reorgs ?
(in response to Dan Michaelis)
Thanks for the response Daniel.

I have found that we have much more control when writing scripts as well.
The one problem I have found with that (and it actually has more to do with
the nature of applications these days than the maintenance scripts
themselves) is that so many of our applications are third party and run
through some sort of app server. This usually means the app processes
respawn if you try to kill them, and quite often my backup/reorg jobs are
compromised by these processes reconnecting before or during execution of
the maintenance scripts.

I was hoping there was some way to prevent that sort of activity from
occuring through a tool or feature of DB2 that I was not aware of. Even
when writing scripts that include application delivered shutdown commands I
still have issues from time to time.

Any further thoughts along those lines is appreciated.

Regards,
Richard McCutcheon.



On Wed, 1 Dec 2004 14:37:07 -0500, Michaelis, Daniel
<[login to unmask email]> wrote:

>I'm always a fan of shell scripts for getting things done. Everywhere I've
>ever worked, folks didn't want to spend the money for tools if they could
>make the DBA's write them, and then blame the DBA if the tools didn't work.
>
>My personal belief is that it's worth getting a tool for monitoring (we
used
>BMC Patrol, but I honestly don't know if that one is any better than any
>others; it was what was in place when I got there, and we had spent too
much
>money to change it), but that for doing things like backups, runstats,
etc.,
>you retain more control if you've written them yourself. The tools that
>I've worked with didn't provide a lot of value-add over what I could write
>myself, and management didn't see spending money to buy what they could
make
>me write for "free"...
>
>That said, if you can get someone to pay for a tool, instead of making you
>write it, I'd go that direction.
>
>Thanks.
>
>Dan Michaelis
>
>Database Administrator/Developer
>eOriginal
>351 West Camden Street
>Suite 800
>Baltimore, MD 21201
>
>410.625.5187 (phone)
>410.659.9799 (fax)
>
>
>-----Original Message-----
>From: Richard McCutcheon [mailto:[login to unmask email]
>Sent: Wednesday, December 01, 2004 2:13 PM
>To: [login to unmask email]
>Subject: DB2 UDB for Multiplatforms - Running Backups or Reorgs ?
>
>Hi Listers...
>
>I am running various versions of DB2 UDB for AIX on multiple servers, and
>run most of my DB2 maintenance jobs as homegrown Korn Shell scripts
>scheduled in Cron.
>
>My question is 'What other ways do people perform backups, reorgs, and
>runstats?'. I understand that you can buy scheduling tools, and write
>programs in other languages, and also use the Control Centre and associated
>IBM tools.
>
>Can people relate their experiences or preferences to me? I am trying to
>find a more central and simple way to perform these maintenance activities.
>
>
>Thanks in advance,
>Richard McCutcheon.
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm