IBM - DB2 LUW Administration für SAP Umsteiger

KURSZIEL
IBM - DB2 LUW Administration für SAP Umsteiger: The course is for knowledged ORACLE SAP admins, as well as for knowledged DB2 SAP admininistrators._x000D_

_x000D_

This TADM56 like course from SAP gives you much more information of how DB2 works together with SAP. _x000D_

_x000D_

After completing this IBM course, you will be able to Understand DB2 fundamentals, Administer DB2 in SAP by using various SAP and DB2 tools to perform database monitoring, performance tuning, database layout, backup and recovery, etc. _x000D_

_x000D_

Understand unique DB2 strengths and features, and the deep integration with SAP, such as DPF, MDC and deep compression. Understand various setup for high available system. Be able to perform basic problem analysis._x000D_

ZIELGRUPPE
The course is for knowledged ORACLE SAP admins, as well as for knowledged DB2 SAP admininistrators._x000D_

_x000D_

This TADM56 like course from SAP gives you much more information of how DB2 works together with SAP. _x000D_

_x000D_

After completing this IBM course, you will be able to Understand DB2 fundamentals, Administer DB2 in SAP by using various SAP and DB2 tools to perform database monitoring, performance tuning, database layout, backup and recovery, etc. _x000D_

_x000D_

Understand unique DB2 strengths and features, and the deep integration with SAP, such as DPF, MDC and deep compression. Understand various setup for high available system. Be able to perform basic problem analysis._x000D_

KURSINHALT
Kursziele This course is designed to make you familiar with the basics of the DB2 database related to SAP systems. In this course there are so many topics and subtopics, that you should read teh materials after the course again. Themenübersicht You will understand and get famliar with:

• DB2 product portfolio and SAP system architecture
• What features of DB2 have been integrated into sapinst
• DB2 fixpak installation in SAP system
• Tools to access DB2 database
• The architecture of SAP running on DB2
• DB2 Command Line Processor (CLP) and SAP database admin tool (DBACOCKPIT)
• Basic concept of DB2 database objects and their relationship
• Basic concept of DB2 security
• The communication between DB2 client and DB2 serverand how to set it up
• Different ways to configure DB2 environment and DB2 database
• Basic DB2 storage structure Table Space and Container
• Extent size and page size
• Automatic Storage in DB2
• Basic DB2 Process Model and Memory Model
• How SQL requests are processed in DB2
• Why transaction log files are important for your system
• How DB2 manages log files, how to configure and use DB2 LUW logging tools
• Backup mechanism in DB2 and advanced backup strategies for large databases
• DB2 storage layoutand storage layout requirements of SAP ERP and SAP BI
• Multi-Dimensional Clustering (MDC) and SAP BI
• DB2 deep compression technology and how it can be used in SAP system
• Performance Monitoring and Tuning

Regular DBA Tasks like:

• DB2 Version Upgrade
• DB2 Fixpack Update
• Operating System Maintenance
• SAP Kernel and Support Package Upgrade

Problem Analysis
Hinweise Weiterführende Kurse zur Vertiefung sind :

• CL21D1DE: DB2 UNIX Datenbank Administration, Teil I
• CL46D1DE: DB2 UNIX Datenbank Administration, Teil II
• CL61D1DE: DB2 SAP - Advanced Administration
• CL62D1DE: DB2 SAP - Performance and Tuning
• CL65D2DE: Best Practices for SAP BW with DB2 V9

VORRAUSSETZUNG
Datenbank Technologie und SAP Kenntnisse sollten vorhanden sein.