DB2 Database Support and Administration



Installation and Configuration
  • Develop Configuration Plan
  • Prepare the Operating System for Installation
  • Backup the Previous Installation (upgrade only)
  • Set Up the Database Server Environment
  • Install the DB2 Server
  • Configure DB2
  • Configure DB2 DRDA
  • Set Up and Test Database Connectivity
Database Administration
  • Logical Database Design
  • Physical Database Design
  • Create the Physical Databases
  • Administration of Tables, Clusters and Indexes
  • Administration of Views, Aliases and Synonyms
  • Administration of Database and Triggers
  • Administration of Stored Procedures
  • Set Up Database Security and Auditing Processes
  • Administration of DB2 Users
  • Set Up Backup and Recovery Procedures
Performance and Tuning
  • Identification of Problems with Design and Development
  • Identification of Problems with System Resources
  • Identify Problems and Tune Memory, Disk I/O and CPU
  • Identify and Create Indexes as needed for Performance
  • Tune Storage and Buffer Pools
  • Tune the SQL Code
  • Tune the Archive Logs
  • Tune for Long Running Jobs
  • Tune for the Client Server Environment


Copyright © Beartooth Technologies, All Rights Reserved
All Graphics and Text on this Site are © Copyrighted
Any unauthorized use of the images or text is prohibited.

All Servicemarks and Trademarks are the property of their respective owners



Webmaster