Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

SAP NetWeaver AS DB Operation (DB2 LUW)

  • Contact Us For Pricing
  • Reviews star_rate star_rate star_rate star_rate star_half 1955 Ratings
  • Course Code TADM56-v017
  • Duration 5 days
  • Available Formats Classroom

Skills Gained

  • Manage DB2 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

  • Technology Consultant

Prerequisites

  • Essential:
       -TADM10 SAP NetWeaver AS Implementation & Operation I
       -TADM12 SAP NetWeaver AS Implementation & Operation II
       -Sound knowledge of database administration
  • Recommended:
       -SAP system administrators should attend the course ADM100 System Administration I for SAP S/4HANA and SAP Business Suite
       -Basic knowledge of administrating at least one operating system

Course Details

Course Content

  • Basics
       -Understanding DB2 products and versions
       -Describing DB2 essentials
       -Describing user and security management
       -Explaining DB2 EDUs, starting and stopping
       -Describing DB2 configuration
       -Understanding DB2 memory management
  • Storage Management
       -Describing DB2 storage concepts
       -Explaining tablespace types and techniques
       -Explaining SAP Tablespace Pools
       -Describing the legacy DMS tablespaces
       -Choosing storage layout
  • Table and Index Maintenance
       -Describing the quality of data storage
       -Deciding the best reorganization strategy
       -Setting up statistics collection in production systems
       -Describing and using data compression features
       -Understanding advanced techniques of storing table and index data
  • Log File Management
       -Explaining the transaction log file content
       -Understanding DB2 log file management
       -Explaining the DB2 logging tools
       -Explaining log file handling
  • Database Backups
       -Explaining reasons for backups
       -Describing the backup architecture
       -Explaining backup types
       -Explaining backup tools
       -Monitoring backup
       -Validating backup
       -Implementing advanced backup technologies
       -Implementing backup strategy
  • Recovery
       -Understanding the need to prevent data loss and disaster recovery
       -Explaining recovery techniques
       -Understanding special recovery techniques
  • Performance Monitoring and Tuning
       -Monitoring performance
       -Assessing key performance indicators
       -Describing DB2 cost-based optimizer
       -Tuning SQL statement
       -Using monitoring and tuning tools
  • Problem Analysis
       -Understanding the support and maintenance processes for DB2 database servers and collect support data
       -Using problem analysis tools
       -Describing sources of information
  • Infrastructure Options
       -Understanding DB2 BLU Acceleration
       -Describing database partitioning feature
       -Understanding multi-dimensional clustering
       -Describing HADR and Tivoli System Automation
       -Describing DB2 pureScale cluster solution

Course based on software release

  • IBM DB2 for LUW 11.1 / SAP NW AS 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.

The virtual classroom and labs were a great way to get training during the COVID-19 pandemic.

This is my second class with this Tech Data ExitCertified Personnel. I learned so much in BigFix Foundations and BigFix Inventory. Very well organized training instructors and well organized course contents and labs. I am glad I have attended.

The course material and the instructor were very good. This course met all my requirements.

Exactly what we needed for our organization, at the right time, at the right price. We'll be back!

AZ-300 course experience was good . Eylem Uysal was very good, the best instructor and i had really good experience attending course and classes with Eylem.

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