The DB2 Database Administration - Essentials training course teaches database administrators to perform basic database administrative tasks. These tasks include creating database objects like tables, indexes and views, and loading data into the database with Db2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference Db2 monitor functions. You will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. The course covers using EXPLAIN tools to review the access plans for SQL statements and adding indexes to improve SQL performance. We will cover the locking performed by Db2 and the effect the application isolation level has on locking and lock wait conditions. You will learn how to implement database security, including adding a security administrator, SECADM user, and implement database roles to simplify security management. We will also describe implementing Db2 native encryption for a database.
By attending DB2 Database Administration - Essentials workshop, delegates will learn to:
- Administer a DB2 database system using commands and GUI tools
- Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply data placement principles
- Implement a given logical database design using DB2 to support integrity and concurrency requirements
- List and describe the components of DB2
- Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
- Use autonomic features of DB2
- Implement DB2 security
By attending DB2 Database Administration - Advanced workshop, delegates will learn to:
- Perform advanced monitoring using the Db2 administrative views and routines in SQL queries.
- Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer.
- Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation.
- Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images.
- Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases.
- Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements.
- Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.
- Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory.
- Adjust database or Db2 instance configuration options to improve application performance or processing efficiency.
- Implement Db2 Self Tuning Memory management for specific database memory areas.
For DB2 Database Administration - Essentials course:
- Perform basic database administration tasks on a relational database system
- Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
- State the functions of the Structured Query Language (SQL), and be able to construct DDL, DML, and authorization statements
- Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
For DB2 Database Administration - Advanced course:
- Perform basic database administration tasks for a Db2 database server, including using Db2 commands like BACKUP and RESTORE
- Utilize Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
This DB2 Database Administration class is suitable for System administrators, Database Administrators and Technical Personnel involved in planning, implementing, and maintaining DB2 databases.