DB2 is a relational database system developed by IBM company, which is mainly used in large-scale application system. It has good scalability, can support from mainframes to single user environment, can be applied to OS/2, Windows and other platforms. DB2 provides high level data utility, integrity, security, recovery as well as the execution ability from small scale to large scale application. DB2 provides the basic functions and the SQL command which are both platform independent. DB2 is well known by having a very complete query optimizer, which improves the performance of the query and supports multi-task parallel query. DB2 is one of the popular database products on the market at present, and is very suitable for students practice as a learning object in certification courses.

"DB2 certification" is a certification course based on DB2 UDB which combines the database theory and software industry. As the subsequent course of database basic principle and the prerequisite course of database application development, the objective of this course is to introduce DB2 architecture, and the main task and means of database advanced management. Through a large number of actual cases, this course will help students quickly understand and master the database creation, maintenance, monitoring, recovery, optimization, application development work, and lay a solid foundation for the students who will be engaged in the related database work in the future.

The main contents of DB2 certification courses include: introduction of DB2 database component, architecture, utility, and DB2 database daily management tasks, such as installation and configuration, instance management, database creation and physical storage planning, data movement (migration), database log management, database backup and recovery, and concurrency control, the database lock performance monitoring and tuning, problem diagnosis, DB2 database security. It also includes some important functions and characteristics of new version.

This course will be opened in the fourth semester, totally 48 hours, including 16 hours experiment, and its prerequisite courses advanced programming language, operating system, database principle.