과목정보: DB2 for LUW Multiple partition DBA Workshop

This course teaches you how to perform database administration tasks using IBM DB2 Enterprise 9 with the Database Partitioning Feature (DPF). These tasks include customization for the DB2 Enterprise 9 with DPF system, creating and populating partitioned databases, designing a database for parallel use, and using partitioned DB2 utilities. There is no actual installation of DB2 Enterprise software in this workshop. A DB2 for Linux system is used to exercise various administrative functions.    

View this course in other countries

위로

Database Administrators, Application Developers, and Consultants who are involved in planning, implementing, or maintaining DB2 DPF partitioned databases.

위로

Before taking this course, you should be able to:

• Use basic Linux/UNIX functions such as utilities, file permissions, hierarchical file system, commands, and the vi editor
• State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
• Discuss basic relational concepts and objects such as tables, indexes, views, and joins
• These skills can be developed by taking:
• Linux/UNIX basics (for example, AIX Basics)
• DB2 SQL Workshop
• DB2 Family Fundamentals
• The student will be using a Linux environment in a VMware image for the lab exercises

위로

After completing this course, you should be able to:

• Describe the steps to install and customize DB2 in a partitioned environment
• Use GUI and Command Line tools to administer the database
• Create objects and load data into DB2 databases
• Define a DB2 partitioned recovery strategy and perform the tasks necessary to support the strategy
• Describe the application development process with respect to DB2 considerations
• Identify how a database should be designed to take advantage of the parallel architecture
• Use DB2 utilities to manage data and maintain your database
• Implement DB2 security   

위로

Day 1

• Welcome
• Unit 1 - Components and Concepts
• Starting your Lab Environment, and Paper Lab
• Unit 2 - Getting Started with DB2
• Unit 3 - Installation
• Installation Lab
• Unit 4 - Creating Databases

Day 2

• Creating Database Lab
• (Unit 5 - Partitioning and Database Partition Groups
• Partitioning Distribution Keys and Database Partition Groups Lab
• (Unit 6 - Data Placement on the Partition
• Creating Table Spaces Lab
• Unit 7 - Create Objects

Day 3

• Creating Objects Lab
• Unit 8 - Moving Data (Import and Load)
• Moving Data Lab - Import and Load
• Unit 8 Continued - Moving Data (Partitioned Load)
• Moving Data Lab - Partitioned Load
• Unit 9 - Application Alternatives
• Application Basics Lab

Day 4

• Unit 10 - Partitioned Database Backup and Recovery
• Backup and Recovery Lab
• Unit 11 - Scaling the Database
• Scaling Lab
• Unit 12 - Performance and Application Concepts
• Application Performance Tools Lab

Day 5

• Unit 13 - Security
• Security Lab
• Unit 14 - Monitoring and Problem Determination Tools
• Unit 15 - Locking and Concurrency
• Locking and Concurrency Lab

위로