A day in the life of DBA

                       

Performance Management

            Properly tune Instances

                        Bufferpools allocation

                        Catalogcache

                        packagecache

                        Sort memory

                        Lock list ... etc

            Identify poorly Performing applications

                        Slow Queries

                        Lock Contention (Deadlock ..etc)

Database Administration

            Manage DB2 Objects

                        Create/alter/migrate Objects

                        Synchronize changes

                        Space allocation

            Maintenance

                        Catalog statistic update

                        Reorg tables

Application management

            Identify problematic sql

            Tune that sql

Quest tools ::

Spotlight

            Real time performance diagnostics

            Detailed drill down

Toad :

            Automate scripting

            Resolve space related issues

            generate utilities

SQL Optimizer

            Automatic re-write queries (SQL Optimizer)

            Simulate database workloads

            What if index simulation (Index impact analyzer)