SAP NetWeaver AS DB Operation (DB2 LUW)

  • Contact Us For Pricing
  • Reviews star_rate star_rate star_rate star_rate star_half 1172 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.

Well organized course, supporting materials, and instructor. Good intro to AWS for various levels of participants - managers to developers.

Fantastic and great training. Tons of hands-on labs to really make you understand the material being thought.

I felt as if I was able to learn and retain a lot within just 3 days of training

thorough course covering materials needed to understand aws, architecture, and their interactions. Labs helped

Facilities were very clean, coffee was nice to have, snack selection was refreshing

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