DBA reading material

Michael Box

DBA reading material
I am relatively new to DB2 (having had a couple of IBM classes and minimal
experience), but have some experience with databases in general. We have
contracted with a group to rewrite the largest application in our shop. I
have been given DBA responsibilities and need some advice. I would like
any recommendations for reading that would help prepare me for
communicating with more experienced DBAs, understanding their data models,
table design, etc. In a brief web search I came up with the following:
Database Design for Mere Mortals by Michael J. Hernandez
Inside Relational Databases by Whitehorn & Marklyn
Absolute Beginner's Guide to Databases by John V. Petersen
Case Method: Entity Relationship Modelling by Richard Barker
Database Modeling & Design by Toby J. Teorey
Data Modeling Essentials: Analysis, Design, and Innovation by Graeme C.
Simsion
Any advice is greatly appreciated.

---------------------------------------------------------------------------------
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

Eric Pearson

Re: DBA reading material
(in response to Michael Box)
DB2 Developer's Guide by Craig Mullins.
Don't leave home without it.

-----Original Message-----
From: Michael Box [mailto:[login to unmask email]
Sent: Thursday, December 02, 2004 3:55 PM
To: [login to unmask email]
Subject: DBA reading material


I am relatively new to DB2 (having had a couple of IBM classes and minimal
experience), but have some experience with databases in general. We have
contracted with a group to rewrite the largest application in our shop. I
have been given DBA responsibilities and need some advice. I would like
any recommendations for reading that would help prepare me for
communicating with more experienced DBAs, understanding their data models,
table design, etc. In a brief web search I came up with the following:
Database Design for Mere Mortals by Michael J. Hernandez
Inside Relational Databases by Whitehorn & Marklyn
Absolute Beginner's Guide to Databases by John V. Petersen
Case Method: Entity Relationship Modelling by Richard Barker
Database Modeling & Design by Toby J. Teorey
Data Modeling Essentials: Analysis, Design, and Innovation by Graeme C.
Simsion
Any advice is greatly appreciated.

----------------------------------------------------------------------------
-----
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


This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.

---------------------------------------------------------------------------------
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

[login to unmask email]

Re: DBA reading material
(in response to Eric Pearson)
Depends on the platform you are working on.

Craig Mullens also has
Database Administration (The Complete Guide to Practices and Procedures)
ISBN 0-201-74129-6.


Carol Sutfin
Corporate DBA
AmSouth Bank
(205)261-5214
[login to unmask email]




"Michael Box"
<[login to unmask email] To: [login to unmask email]
V> cc:
Sent by: "DB2 Subject: DBA reading material
Data Base
Discussion List"
<[login to unmask email]
.ORG>


12/02/2004 02:55
PM
Please respond
to "DB2 Database
Discussion list
at IDUG"





I am relatively new to DB2 (having had a couple of IBM classes and minimal
experience), but have some experience with databases in general. We have
contracted with a group to rewrite the largest application in our shop. I
have been given DBA responsibilities and need some advice. I would like
any recommendations for reading that would help prepare me for
communicating with more experienced DBAs, understanding their data models,
table design, etc. In a brief web search I came up with the following:
Database Design for Mere Mortals by Michael J. Hernandez
Inside Relational Databases by Whitehorn & Marklyn
Absolute Beginner's Guide to Databases by John V. Petersen
Case Method: Entity Relationship Modelling by Richard Barker
Database Modeling & Design by Toby J. Teorey
Data Modeling Essentials: Analysis, Design, and Innovation by Graeme C.
Simsion
Any advice is greatly appreciated.

---------------------------------------------------------------------------------

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

[login to unmask email]

Re: DBA reading material
(in response to Tonmoy Dasgupta)
Depends on the platform you are working on.

Craig Mullens also has
Database Administration (The Complete Guide to Practices and Procedures)
ISBN 0-201-74129-6.


Carol Sutfin
Corporate DBA
AmSouth Bank
(205)261-5214
[login to unmask email]




"Michael Box"
<[login to unmask email] To: [login to unmask email]
V> cc:
Sent by: "DB2 Subject: DBA reading material
Data Base
Discussion List"
<[login to unmask email]
.ORG>


12/02/2004 02:55
PM
Please respond
to "DB2 Database
Discussion list
at IDUG"





I am relatively new to DB2 (having had a couple of IBM classes and minimal
experience), but have some experience with databases in general. We have
contracted with a group to rewrite the largest application in our shop. I
have been given DBA responsibilities and need some advice. I would like
any recommendations for reading that would help prepare me for
communicating with more experienced DBAs, understanding their data models,
table design, etc. In a brief web search I came up with the following:
Database Design for Mere Mortals by Michael J. Hernandez
Inside Relational Databases by Whitehorn & Marklyn
Absolute Beginner's Guide to Databases by John V. Petersen
Case Method: Entity Relationship Modelling by Richard Barker
Database Modeling & Design by Toby J. Teorey
Data Modeling Essentials: Analysis, Design, and Innovation by Graeme C.
Simsion
Any advice is greatly appreciated.

---------------------------------------------------------------------------------

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

---------------------------------------------------------------------------------
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

Michael Box

Re: DBA reading material
(in response to csutfin@AMSOUTH.COM)
My apologies regarding my earlier post, but I neglected to point out that
this project will be done on an AIX box.

---------------------------------------------------------------------------------
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

Tonmoy Dasgupta

Re: DBA reading material
(in response to Michael Box)
DB2 Universal Database V8 for Linux, Unix and Windows Database
Administration Certification Guide (IBM Press) offers a comprehensive
introductory coverage for DBA areas. I would recommend this before you
get buried under IBM manuals.

Thanks.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Michael Box
Sent: Thursday, December 02, 2004 3:35 PM
To: [login to unmask email]
Subject: Re: DBA reading material


My apologies regarding my earlier post, but I neglected to point out
that this project will be done on an AIX box.

------------------------------------------------------------------------
---------
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

Philip Sevetson

Re: DBA reading material
(in response to csutfin@AMSOUTH.COM)
If you can get to any regional or national conference featuring a
presentation by Bonnie Baker titled "Things I wish they'd told me 8 years
ago," you should find that an extremely helpful overview of many important
aspects of DB2 packed into a relatively short presentation. I realize
this isn't to the point of your request, but honestly there's a great deal
of oral tradition passed on by experts about DB2, since it's a
continuously evolving environment/product.

--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]




I am relatively new to DB2 (having had a couple of IBM classes and minimal
experience), but have some experience with databases in general. We have
contracted with a group to rewrite the largest application in our shop. I
have been given DBA responsibilities and need some advice. I would like
any recommendations for reading that would help prepare me for
communicating with more experienced DBAs, understanding their data models,
table design, etc. In a brief web search I came up with the following:
Database Design for Mere Mortals by Michael J. Hernandez
Inside Relational Databases by Whitehorn & Marklyn
Absolute Beginner's Guide to Databases by John V. Petersen
Case Method: Entity Relationship Modelling by Richard Barker
Database Modeling & Design by Toby J. Teorey
Data Modeling Essentials: Analysis, Design, and Innovation by Graeme C.
Simsion
Any advice is greatly appreciated.

---------------------------------------------------------------------------------
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

Isaac Yassin

Re: DBA reading material
(in response to Philip Sevetson)
Reading Bonnie's material without hearing her on the same time is not recommended to the un-initiated :-)

Look also at "DB2 for OS/390 & z/OS Developement for performance" by Gabriel Wiorkowski.


Isaac Yassin




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Monday, December 06, 2004 7:31 PM
To: [login to unmask email]
Subject: Re: DBA reading material



If you can get to any regional or national conference featuring a presentation by Bonnie Baker titled "Things I wish they'd told me
8 years ago," you should find that an extremely helpful overview of many important aspects of DB2 packed into a relatively short
presentation. I realize this isn't to the point of your request, but honestly there's a great deal of oral tradition passed on by
experts about DB2, since it's a continuously evolving environment/product.

--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]




I am relatively new to DB2 (having had a couple of IBM classes and minimal
experience), but have some experience with databases in general. We have
contracted with a group to rewrite the largest application in our shop. I
have been given DBA responsibilities and need some advice. I would like
any recommendations for reading that would help prepare me for
communicating with more experienced DBAs, understanding their data models,
table design, etc. In a brief web search I came up with the following:
Database Design for Mere Mortals by Michael J. Hernandez
Inside Relational Databases by Whitehorn & Marklyn
Absolute Beginner's Guide to Databases by John V. Petersen
Case Method: Entity Relationship Modelling by Richard Barker
Database Modeling & Design by Toby J. Teorey
Data Modeling Essentials: Analysis, Design, and Innovation by Graeme C.
Simsion
Any advice is greatly appreciated.
--------------------------------------------------------------------------------- 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