Db2 11.1 Advanced Database Administration

  • Tuition USD $1,650
  • Reviews star_rate star_rate star_rate star_rate star_half 1140 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.

Very clear and concise course. It was worth attending to me and provided useful information I will use going forward.

Our instructor Mohammad Meimandi was a great resource. He helped clarify a lot of concepts. Overall I liked the Quiklabs as they offered a great hands-on experience to drive the concepts.

Tommy was a great instructor. We relied on this class to develop our understanding, and we were very happy with the result.

Program was well done from initial invitation to actual class and follow-up

This was my second course through ExitCertified, and it continues to be a great way to learn and advance my career!

5 options available

undo
  • GTR Nov 30, 2020 Dec 1, 2020 (2 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EST
    Enroll
    Enroll
  • Dec 21, 2020 Dec 22, 2020 (2 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EST
    Enroll
    Enroll
  • GTR Jan 21, 2021 Jan 22, 2021 (2 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EST
    Enroll
    Enroll
  • Feb 18, 2021 Feb 19, 2021 (2 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EST
    Enroll
    Enroll
  • Mar 29, 2021 Mar 30, 2021 (2 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EDT
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward