Description
Delivery:Online, classroom or onsite
Duration:4 days (32 hours)
Platform:Db2 11 for Linux, UNIX and Windows
Who it is for:Database administrators experienced on another engine taking on a Db2 11.
Recommended background:Experience administering a relational database. No previous Db2 required.
Who this course fits
- Seasoned DBAs on another engine handed a Db2 11 that is already in production.
- Teams staying on an earlier release for now who still have to answer for it.
Course content
- Overview of Db2 on Linux, UNIX and Windows
- The command line processor (CLP) and the graphical tools
- The Db2 environment
- Creating databases and deciding where the data goes
- Creating database objects
- Moving data
- Backup and recovery
- Locks and concurrency
- Maintenance, monitoring and problem determination
- Security
- Database rebuild support
- Database and table space relocation
- The explain tools
- Using indexes for performance
- Advanced monitoring
Course agenda
- Day 1: overview, tools, the environment and creating the database
- Day 2: objects, moving data, backup and recovery
- Day 3: locking, maintenance, security and rebuild
- Day 4: relocation, explain, indexes and advanced monitoring
Training with SIXE, IBM Business Partner
- Labs on your own Db2 LUW release, on Linux, AIX or Windows depending on what you run.
- Taught directly by IBM Champion instructors from the SIXE team.
- Credly badges available: credly.com/organizations/sixe/badges
- Flexible format — online, classroom or onsite — in closed groups, priced per attendee, in the language of your choice (ES / EN / FR).
Instructors specialised in IBM Db2 on Linux, UNIX and Windows
Engineers from the SIXE team who administer Db2 LUW in production and came to it from other engines. Several recognised as IBM Champion.
Frequently asked questions
This one or CL485G?
They are the same route with the official outline pinned to a different release: this one covers Db2 11 and CL485G the other. Since we teach on the release you have installed, pick by yours — and if it matches neither, tell us and we fit the labs to it.
How does it differ from the four-day administration workshop?
In the starting point. The administration workshop assumes nothing; this one assumes you already administer another engine, trims the conceptual part and reaches explain, indexes and advanced monitoring within the same four days.
Group size and language?
Closed groups of four to ten people, in Spanish, English or French. We run it with fewer than four as well, though it usually pays to wait and fill the group.
Related courses
- CL485G — The same course on the other release
- CL413G — Performance tuning and monitoring (if performance needs going into properly)
- CL464G — Advanced Db2 administration (rebuild, relocation and incremental backups)
