3 arrows

Popular Mirantis On Demand Training Courses Now 50% Off

closeClose

Db2 11.1 Advanced Database Administration

  • Tuition USD $1,650 GSA  $1,413.10
  • Reviews star_rate star_rate star_rate star_rate star_half 2923 Ratings
  • Course Code CL464G
  • Duration 2 days
  • Available Formats Classroom, Virtual
CL464G - Db2 11.1 Advanced Database Administration

Course Eligible for IBM Digital Badge

This course is designed to teach you how 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.

 

Skills Gained

Please refer to course overview

Who Can Benefit

This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases

Prerequisites

  • 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
  • These skills can be developed by taking:
    • CL207 Db2 11.1 Administration Workshop for Linux

Course Details

Course Outline

- Advanced Monitoring
- Db2 Table Space Management
- Db2 Database Memory Management
- Database rebuild support
- Db2 database and tablespace relocation
- Db2 Incremental Backup

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Good course, and the instruction was also good. The pace could have been a bit quicker, but overall a good course.

This course gave me a clearer understanding of the AWS cloud architecture.

The material and instruction were well paced and understandable. The labs provided good hands on experience with AWS services and I look forward to taking more training with ExitCertified.

Virtual delivery and coordination of the course was great. It had to be rescheduled several times by ExitCertified was always on top of things.

Very impressed with the Instructor, Course Content and Labs provided by ExitCertified. Definitely have a very good platform for virtual learning. Will recommend to anyone interested in IT Courses.

4 options available

undo
  • May 10, 2021 May 11, 2021 (2 days) GTR
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EDT
    Enroll
    Enroll
  • Jun 28, 2021 Jun 29, 2021 (2 days) GTR
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EDT
    Enroll
    Enroll
  • Aug 10, 2021 Aug 11, 2021 (2 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EDT
    Enroll
    Enroll
  • Sep 16, 2021 Sep 17, 2021 (2 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EDT
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward