Database Administration (Db2 LUW)

  • Tuition USD $2,250
  • Reviews star_rate star_rate star_rate star_rate star_half 1110 Ratings
  • Course Code ADM535-v017
  • Duration 3 days
  • Available Formats Classroom

Skills Gained

  • This course will prepare you to:
       -Manage IBM Db2 for LUW in an SAP environment using the administration tools provided by SAP system and Db2
       -Implement appropriate database backup and recovery strategies
       -Understand performance and tuning
       -Recognize performance bottlenecks

Who Can Benefit

  • Database Administrator
  • System Administrator
  • Technology Consultant


  • Essential:
       -SAPTEC SAP NetWeaver Application Server - Fundamentals
  • Recommended:
       -SAP system administrators should attend the course ADM100
       -Basic knowledge of administering at least one operating system

Course Details

Course Content

  • Db2 Basics
       -Products, versions, and essentials
       -User and security management
       -Engine dispatchable units (EDUs)
       -Memory management
  • Storage Management
       -Storage concepts and layout
       -Tablespace types
       -SAP tablespace pools
  • Table and Index Maintenance
       -Reorganization strategy
       -Statistics collection
       -Data compression
       -Advanced techniques of storing table and index data
  • Log File Management
       -Transaction log files
       -Db2 log file management
       -Logging tools and log file handling
  • Database Backups
       -Backup architecture including reasons and strategy for backups
       -Backup types and tools
       -Monitoring and validating backups
       -Advanced backup techniques
  • Recovery
       -Understanding the need to prevent data loss and disaster recovery
       -Recovery techniques
  • Performance Monitoring and Tuning
       -Monitoring performance
       -Key performance indicators
       -Db2 cost-based optimizer
       -Tuning SQL statements
       -Monitoring and tuning tools
  • Problem Analysis
       -Support and maintenance processes and collecting support data
       -Problem analysis tools
       -Information sources
  • Infrastructure Options
       -Db2 BLU Acceleration
       -Database partitioning feature (DPF)
       -Multidimensional clustering
       -HADR and Tivoli System Automation
       -Db2 pureScale cluster solution

Course based on software release

  • IBM Db2 for LUW 11.1
  • AS ABAP 7.50

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.

This course helped me prepare for my AWS certifications. Highly recommended! Great instructors! My entire experience has been great in terms of signing up and taking the classes.

Good job coping with the "new" training, of having video learning in a group setting.

Very good overview and Intro to AWS. Just the right amount of information.

The course was very thorough and the instructor ensured that all the students were on the same page.

Great training that provided pro-tips a plenty that were immediately put to use.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward