Description
Delivery:Online, classroom or onsite
Duration:4 days (32 hours)
Platform:Db2 LUW, labs on Windows
Who it is for:Administrators maintaining Db2 on Windows Server.
Recommended background:Basic Windows Server skills and relational database concepts.
Who this course fits
- Teams running Db2 on Windows Server.
- Windows administrators taking on the database as well.
- Organisations running Db2 alongside SQL Server who want one common approach.
Course content
- Overview of Db2 on Linux, UNIX and Windows
- The command line processor (CLP) and the graphical tools
- The database manager instance
- Creating databases and deciding where the data goes
- Creating database objects
- Moving data: load, import and export
- Backup and recovery
- Maintenance, monitoring and problem determination
- Locking and concurrency
- Security
Course agenda
- Day 1: Db2 overview, the CLP and the graphical tools, and the instance
- Day 2: creating the database, deciding where the data goes and creating the objects
- Day 3: moving data, backup and recovery
- Day 4: maintenance and monitoring, locking and concurrency, and security
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, on Linux, AIX and Windows. Several recognised as IBM Champion.
Frequently asked questions
Which of the administration workshops is mine?
All four share the same ten units and differ in the operating system used in the labs and the release IBM pins each outline to: CL207G on Linux, CL213G on AIX, CL235G on Windows and CL2X3G on Linux and Windows together. If your combination is not listed we build it: tell us the operating system and release when booking.
What if we run a different Db2 release?
It is taught on yours. Db2 12.1 is the current release, out in November 2024; Db2 11.1 went out of support on 30 April 2026 and the withdrawn 11.5 editions close extended support on 30 September 2026. The units do not change, the labs do.
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
- CL207G — The same workshop on Linux (if you are moving the engine to another platform)
- CL2X3G — Basic administration for Linux and Windows (if the estate is mixed)
- CL413G — Performance tuning and monitoring (the next step)
