Db2 11.1 Administration Workshop for Linux
This course teaches database administrators to perform basic database administrative tasks using Db2 11.1. 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.
Duration: 40-45hrs
Course Content:
- - Overview of Db2 11.1
- - Db2 Command Line Processor (CLP) and GUI tools
- - The Db2 database manager instance
- - Creating Databases and Data Placement
- - Creating Database Objects
- - Moving Data
- - Backup and Recovery
- - Database Maintenance, Monitoring and Problem Determination
- - Locking and concurrency
- - Security