Results 1 to 4 of 4

Thread: DBA checklist

  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: DBA checklist

    I am creating a DB2 UDB DBA checklist and wanted to gather your input and thoughts on what checks DBA should perform on a daily, weekly, monthly and annual basis for dev, qa and production DB2 UDB environments. Here is what I have thus far lets all build it together:

    Daily Tasks

    1. verify the status for DB2 UDB backups.
    2. monitor and check status of DB2 tables, database and tablespaces
    3. check connectivity to db2 instances

    Weekly

    Check performance of db2 environment
    attend status meetings
    train new staff


    monthly/yearly
    upgrade fixpacks and patches

  2. #2
    Join Date
    May 2003
    Location
    Phoenix, US
    Posts
    39

    Re: DBA checklist

    Probably you can add
    1. Monitoring of db2diag.log files for any errors reported(memory problems, filesystem problems) to the daily tasks list

    Thanks
    sateesh
    Originally posted by mixxalot
    I am creating a DB2 UDB DBA checklist and wanted to gather your input and thoughts on what checks DBA should perform on a daily, weekly, monthly and annual basis for dev, qa and production DB2 UDB environments. Here is what I have thus far lets all build it together:

    Daily Tasks

    1. verify the status for DB2 UDB backups.
    2. monitor and check status of DB2 tables, database and tablespaces
    3. check connectivity to db2 instances

    Weekly

    Check performance of db2 environment
    attend status meetings
    train new staff


    monthly/yearly
    upgrade fixpacks and patches

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DBA checklist

    Criag Mullins's book "Database Administration: The Complete Guide to Practices and Procedures" should help you ...

    amazon.com , it is .com, has 61 sample pages ... see if there is any pointers ...

    Cheers

    Sathyaram

  4. #4
    Join Date
    May 2003
    Location
    Toronto
    Posts
    29

    Re: DBA checklist

    The following is a Oracle DBA Checklist, could you please edit it for DB2 and attach here?

    Originally posted by mixxalot
    I am creating a DB2 UDB DBA checklist and wanted to gather your input and thoughts on what checks DBA should perform on a daily, weekly, monthly and annual basis for dev, qa and production DB2 UDB environments. Here is what I have thus far lets all build it together:

    Daily Tasks

    1. verify the status for DB2 UDB backups.
    2. monitor and check status of DB2 tables, database and tablespaces
    3. check connectivity to db2 instances

    Weekly

    Check performance of db2 environment
    attend status meetings
    train new staff


    monthly/yearly
    upgrade fixpacks and patches
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •