DB2 DBA Daily Activities:
Daily Activities:
- ==> Verify all the instances and databases are running.
- ==> Check the backup status of the databases.
- ==> Check the archiving of database logs.
- ==> Verify the pruning of database backups and archival logs.
- ==> Check the status of Reorg/Runstats jobs if you have enabled.
- ==> Check the db2 diagnostic logs and notification logs.
- ==> Check the size/status of each mount database server is using.
- ==> Verify that you have enough pages available in the tablespaces if auto increment is off.
- ==> Capture the database and SQLs snapshots during the specific workloads.
- ==> Advising the indexes and other recommendations for the SQL queries.
- ==> Check the database and database manager config parameters which might need a tuning.
- ==> Handle the adhoc requests from developers and other team members database perspective.
- ==> Try to automate the database jobs as much as possible to ease the work.
- ==> Try to learn new features, methods, tricks, functionalities.
Weekly Activities:
- ==> Look for new objects.
==> Run db2look and write the report to a file every week.
-- Check for differences between the new output and the previous week's output.
==> Select object names from SYSCAT.TABLES, SYSCAT.INDEXES, SYSCAT.PROCEDURES
-- Check for differences between the new output and the previous week's output.
- ==> Look for new or changed applications.
- ==> Look for tables and/or indexes needing REORG.
- ==> Look for tables and indexes needing RUNSTATS.
- ==> Look for the 10 most active tables.
- ==> Archive all alert logs and DB2DIAG.LOG files.
Monthly Activities:
- ==> Look for indicators of exceptional growth.
- ==> Project future performance based on projected growth.
Sources:
0 comments:
Post a Comment