Needed!! Any advice on how to organize daily tasks as a New DBA??

Christine Sawyer

Needed!! Any advice on how to organize daily tasks as a New DBA??
Greetings to all,

I am a new DB2 DBA and will like to organize my daily activities/task
as efficiently and productively as I can. Bear with me everyone if the
following questions are simple. My questions to you seasoned practitoners
are:

1. What should a DBA do as she settles in for the work day to
ascertain the health of her DB2 systems? What are the
things you startoff with after the first cup of coffe??

2. Tools available to me in the management of DB2 databases and
application suppport are: OMEGAMON/DB2, (good ol')DB2PM,
PLATINUM suite of Tools (eg DB2 Analyzer, Detector, Log &
Plan analyzer, RC/Query etc). I pose the question thus:
Which of these tools and associated reports will you
look at first, second, and so on? If you can, please give
me the reason why you would choose any of the tools in the
order you chose them.

All and any responses will be immensely appreciated!!

Thanks all

Christine





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



Bill Welch

Re: Needed!! Any advice on how to organize daily tasks as a New DBA??
(in response to Christine Sawyer)
>At 06:03 PM 10/10/99 -0400, you wrote:
>Greetings to all,
>
>I am a new DB2 DBA and will like to organize my daily activities/task
>as efficiently and productively as I can. Bear with me everyone if the
>following questions are simple. My questions to you seasoned practitoners
>are:
>
> 1. What should a DBA do as she settles in for the work day to
> ascertain the health of her DB2 systems? What are the
> things you startoff with after the first cup of coffe??
>
> 2. Tools available to me in the management of DB2 databases and
> application suppport are: OMEGAMON/DB2, (good ol')DB2PM,
> PLATINUM suite of Tools (eg DB2 Analyzer, Detector, Log &
> Plan analyzer, RC/Query etc). I pose the question thus:
> Which of these tools and associated reports will you
> look at first, second, and so on? If you can, please give
> me the reason why you would choose any of the tools in the
> order you chose them.
>
> All and any responses will be immensely appreciated!!
>
>Thanks all
>
>Christine
>
>
>
>
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>
>
>
>
>

Run Omegamon/DB2 (or DB2PM) reports daily. One report for prime time (e.g.
8am to 6pm) should be reviewed daily. Also run reports by hour and review
them as you have time. Also run RMF (or equivalent) reports to check on
DASD performance.

Run the "health check" SQL recommended by Bonnie Baker, IBM, and others
after each RUNSTATS to see when indexes and tablespaces need to have a
REORG. You may or may not be running a RUNSTATS every day.

Bill Welch

--


William D. Welch
University of California, Berkeley
Central Computing Services, 502 Banway
510/643-2608
[login to unmask email]



CLAUDIO MARCOS

Re: Needed!! Any advice on how to organize daily tasks as a New DBA??
(in response to Bill Welch)
Please unsuscribe me of your list

-----Mensaje original-----
De: Christine Sawyer <[login to unmask email]>
Grupos de noticias: bit.listserv.db2-l
Para: [login to unmask email] <[login to unmask email]>
Fecha: domingo 10 de octubre de 1999 19:13
Asunto: Needed!! Any advice on how to organize daily tasks as a New DBA??


>Greetings to all,
>
>I am a new DB2 DBA and will like to organize my daily activities/task
>as efficiently and productively as I can. Bear with me everyone if the
>following questions are simple. My questions to you seasoned practitoners
>are:
>
> 1. What should a DBA do as she settles in for the work day to
> ascertain the health of her DB2 systems? What are the
> things you startoff with after the first cup of coffe??
>
> 2. Tools available to me in the management of DB2 databases and
> application suppport are: OMEGAMON/DB2, (good ol')DB2PM,
> PLATINUM suite of Tools (eg DB2 Analyzer, Detector, Log &
> Plan analyzer, RC/Query etc). I pose the question thus:
> Which of these tools and associated reports will you
> look at first, second, and so on? If you can, please give
> me the reason why you would choose any of the tools in the
> order you chose them.
>
> All and any responses will be immensely appreciated!!
>
>Thanks all
>
>Christine
>
>
>
>
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>
>
>





CLAUDIO MARCOS

Re: Needed!! Any advice on how to organize daily tasks as a New DBA??
(in response to CLAUDIO MARCOS)
Please unsuscribe me of your list

-----Mensaje original-----
De: Bill Welch <[login to unmask email]>
Grupos de noticias: bit.listserv.db2-l
Para: [login to unmask email] <[login to unmask email]>
Fecha: domingo 10 de octubre de 1999 19:33
Asunto: Re: Needed!! Any advice on how to organize daily tasks as a New
DBA??


>>At 06:03 PM 10/10/99 -0400, you wrote:
>>Greetings to all,
>>
>>I am a new DB2 DBA and will like to organize my daily activities/task
>>as efficiently and productively as I can. Bear with me everyone if the
>>following questions are simple. My questions to you seasoned practitoners
>>are:
>>
>> 1. What should a DBA do as she settles in for the work day to
>> ascertain the health of her DB2 systems? What are the
>> things you startoff with after the first cup of coffe??
>>
>> 2. Tools available to me in the management of DB2 databases and
>> application suppport are: OMEGAMON/DB2, (good ol')DB2PM,
>> PLATINUM suite of Tools (eg DB2 Analyzer, Detector, Log &
>> Plan analyzer, RC/Query etc). I pose the question thus:
>> Which of these tools and associated reports will you
>> look at first, second, and so on? If you can, please give
>> me the reason why you would choose any of the tools in the
>> order you chose them.
>>
>> All and any responses will be immensely appreciated!!
>>
>>Thanks all
>>
>>Christine
>>
>>
>>
>>
>>
>>______________________________________________________
>>Get Your Private, Free Email at http://www.hotmail.com
>>
>>
>>
the
>>
>>
>
>Run Omegamon/DB2 (or DB2PM) reports daily. One report for prime time (e.g.
>8am to 6pm) should be reviewed daily. Also run reports by hour and review
>them as you have time. Also run RMF (or equivalent) reports to check on
>DASD performance.
>
>Run the "health check" SQL recommended by Bonnie Baker, IBM, and others
>after each RUNSTATS to see when indexes and tablespaces need to have a
>REORG. You may or may not be running a RUNSTATS every day.
>
>Bill Welch
>
>--
>
>
>William D. Welch
>University of California, Berkeley
>Central Computing Services, 502 Banway
>510/643-2608
>[login to unmask email]
>
>
>





Davis Morr

Re: Needed!! Any advice on how to organize daily tasks as a New DBA??
(in response to CLAUDIO MARCOS)
Please unsuscribe me of your list


Kind Regards

Gaby Liebert

_____________________________________________

Atraxis AG
Customer Help Desk

Phone: 41 1 812 4474
Telefax: 41 1 812 9898
Telex: ZRHXUSR
E-Mail: [login to unmask email]



Davis Morr

Re: Needed!! Any advice on how to organize daily tasks as a New DBA??
(in response to Davis Morr)
Please unsuscribe me of your list



Marcus Davage

Re: Needed!! Any advice on how to organize daily tasks as a New D BA??
(in response to Davis Morr)
Hi,

At a risk of sounding like a broken record... "it depends!"
In a previous incarnation, I used to run SQL to display tablespaces without
image copies taken in the last week (insert i/c frequency here).
I also use to run (weekly) a REPAIR DBD TEST DATABASE on each database I
administered to check that the OBIDs were consistent. (This certainly saved
my skin on one occasion.)
If you're a development DBA, you could craft SQL to pick out violations of
naming standards.
I would also recommend Bill's suggestion of running post-RUNSTATS Health
check SQL.
If you have authority, run CICS transaction response traces.
If your change activity is high, try looking for bad SQL in the PLAN_TABLE.
(Join with SYSTABLES to get NUMPAGES for access method of "R" tablespace
scans, or join index accesses with SYSINDEXES to get matchcols / columns
ratio. That sort of thing.)

Regards,
Marcus

-----Original Message-----
From: Christine Sawyer [mailto:[login to unmask email]
Sent: 10 October 1999 23:04
To: [login to unmask email]
Subject: Needed!! Any advice on how to organize daily tasks as a New
DBA??


Greetings to all,

I am a new DB2 DBA and will like to organize my daily activities/task
as efficiently and productively as I can. Bear with me everyone if the
following questions are simple. My questions to you seasoned practitoners
are:

1. What should a DBA do as she settles in for the work day to
ascertain the health of her DB2 systems? What are the
things you startoff with after the first cup of coffe??

2. Tools available to me in the management of DB2 databases and
application suppport are: OMEGAMON/DB2, (good ol')DB2PM,
PLATINUM suite of Tools (eg DB2 Analyzer, Detector, Log &
Plan analyzer, RC/Query etc). I pose the question thus:
Which of these tools and associated reports will you
look at first, second, and so on? If you can, please give
me the reason why you would choose any of the tools in the
order you chose them.

All and any responses will be immensely appreciated!!

Thanks all

Christine





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






---------------------------------------------------------------------------
This Email is intended for the exclusive use of the addressee only.
If you are not the intended recipient, you should not use the
contents nor disclose them to any other person and you should
immediately notify the sender and delete the Email.

Lloyds TSB Bank plc is registered in England and Wales no. 2065.
Registered office: 71 Lombard Street, London, EC3P 3BS.

Lloyds TSB Scotland plc is registered in Scotland no. 95237.
Registered office: Henry Duncan House, 120 George Street,
Edinburgh, EH2 4LH.
---------------------------------------------------------------------------



Craig Mullins

Re: Needed!! Any advice on how to organize daily tasks as a New D BA??
(in response to Marcus Davage)
Christine:

My suggestion to you would be to automate as many of the routine tasks as
you possibly can given the tools at your disposal. If you can set up your
environment to determine what is good and what is bad and to alert you when
the "bad" happens: e.g. reorg needed, potential out of space situation,
nearing bufferpool threshold, etc. etc. That way you will be informed when
the problem happens and can respond accordingly. You can automate using
vendor tools, Rexx, or whatever scripting/programming tools you have at your
disposal. Even a minimal amount of automation can save you time and effort.

Failing the implementation of automation, I'd suggest you check the basics
first:
- Did all of the jobs that access DB2 data run to completion successfully
last night?
- What is the status of the online systems: up, down, running slowly, etc.
- What is the status of the production DB2 subsystems? test?
- Use DB2-PM to product daily reports of the DB2 plans and packages that ran
and review them each morning.
- Did you get any voice mails, e-mails, or pages yet? How about any "while
you were out" slips on your desk (of course, these are the obvious problems)
- There are a bunch of queries in my book, DB2 Developer's Guide, Chapter
19, that can be run to help you monitor and manage your DB2 apps, too (for
more information http://www.craigsmullins.com/cm-book.htm )

Good luck in your new role as DBA. Be prepared to be blamed for everything.
You're job is to prove your (and DB2's) innocence or to find the problem
quickly.

Cheers,
Craig S. Mullins
Director, DB2 Technology Planning
BMC Software
[login to unmask email]
http://www.bmc.com
http://www.craigsmullins.com

================>Original Message <=======================

>Date: Sun, 10 Oct 1999 18:03:34 EDT
>From: Christine Sawyer <[login to unmask email]>
>Subject: Needed!! Any advice on how to organize daily tasks as a New DBA??
>
>Greetings to all,
>
>I am a new DB2 DBA and will like to organize my daily activities/task
>as efficiently and productively as I can. Bear with me everyone if the
>following questions are simple. My questions to you seasoned practitoners
>are:
>
> 1. What should a DBA do as she settles in for the work day to
> ascertain the health of her DB2 systems? What are the
> things you startoff with after the first cup of coffe??
>
> 2. Tools available to me in the management of DB2 databases and
> application suppport are: OMEGAMON/DB2, (good ol')DB2PM,
> PLATINUM suite of Tools (eg DB2 Analyzer, Detector, Log &
> Plan analyzer, RC/Query etc). I pose the question thus:
> Which of these tools and associated reports will you
> look at first, second, and so on? If you can, please give
> me the reason why you would choose any of the tools in the
> order you chose them.
>
> All and any responses will be immensely appreciated!!
>
>Thanks all
>
>Christine