IBM DB2 8.1 SYSTEM ADMINISTRATION
The level of this course is intermediate
Configure and maintain DB2 instances. Manipulate databases and database objects. Optimize placement of data Control user access to instances and databases. Implement security on instances and databases. Use DB2 activity monitoring utilities. Use DB2 data movement and reorganization utilities. Develop and implement Database recovery strategy. Interpret basic information in the db2diag.log file.
Some experience with writing Structured Query Language scripts. Knowledge of relational database design concepts. Knowledge of Windows environment. Knowledge of Windows GUI navigation skills.
This course provides students with the knowledge and skills they need to perform the routine tasks of a DB2 Universal Database Systems Administrator. Through instructor presentations, they will learn about the tools and commands needed to configure and maintain instances and database objects. Through lab exercises, students will have the opportunity to practice the skills they've learned in a simulated database server environment. Overview of Major DB2 components. Introduction to GUI tools Data Placement. Creating an Instance Database Tables and Views. Creating Indexes Using Constraints Data Movement Utilities Data Maintenance Utilities Locking.Concurrency Backup and Recovery Performance monitoring Query Optimization. Problem Determination Security Summary