Course description: Advanced DB2 SAP for Administrators - Web-Based

This is a self-paced online course. The average amount of time to complete this course is 16 hours. Once you receive your access information, you will have access to this course for 1 year.

Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course.

This course is designed to provide you with advanced information regarding DB2 in a SAP environment, including how some of the new features are used. It includes an overview of the implementation and linkage of DB2 and SAP, as well as more detailed information about storage management, backup and recovery, including HADR. Row compression and automatic capabilities are also discussed. DPF (Data Partition Feature) and MDC (Multi Dimensional Clustering) are covered. After taking the course, you should have a deeper understanding of the various DB2 features and how they are used in SAP.

The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.

Course Materials

The course materials address DB2 9 for Linux, UNIX, and Windows, Version 9.5.

Hands-On Labs

Ten labs are included to address DB2 9 for Linux, UNIX, and Windows, Version 9.5.

View this course in other countries

Training Paths that reference this course are:

• DB2 / SAP Training

Back to top

IBM Education Advantage Program eligibility:

• Yes - IBM Education Pack - online account

Back to top

This advanced course is for database administrators in a DB2 / SAP environment who need deeper information about DB2 under SAP.

Back to top

You should have:

• Knowledge of SAP applications and administration
• Knowledge of DB2 administration basics

Back to top

• Describe SAP / DB2 integration
• Describe DB2 DPF and SAP implementation and MDC implementation
• Describe and define storage layout (table spaces in DB2)
• Describe and define row/data compression in DB2
• List and describe backup/restore scenarios
• Define DB2 HADR
• List the automatic capabilities of DB2

Back to top

SAP / DB2 integration

• Describe SAP / DB2 implementation
• Describe the DB2 9 features for SAP
• Describe the DB2 9.5 features for SAP
• Describe how SAP and DB2 work together

DB2 DPF partitioned database and MDC concepts

• Identify the kinds of business applications that use parallel databases
• Describe the basic architecture of each of the hardware platforms on which parallel databases may run
• Describe DB2 database partitioning
• Define the strengths of the DB2 DPF partitioned architecture
• Compare the features and performance advantages of multidimensional clustering (MDC) to single-dimensional clustering
• Define the concepts of MDC tables, including cell, slice, and dimension
• Describe the characteristics of the block indexes used for MDC tables including the index maintenance performed for SQL INSERT, DELETE, and UPDATEs
• Explain how the block and row indexes can be combined to efficiently process SQL statements
• Utilize the LOAD Utility to roll-in new data in a MDC table
• Analyze the effects on table space size of selecting alternative dimensions and extent sizes

Advanced table space management

• Describe the benefits and limitations of using SMS, DMS and Automatic Storage management for table spaces
• Examine GET SNAPSHOT FOR TABLESPACES reports to obtain the current disk space usage, the High Water Mark and describe the mapping of extents to the DMS table space containers
• Utilize the DB2DART utility to list and analyze the current High Water Mark for a DMS table space
• Monitor the processing done by the Rebalancer using LIST UTILITIES and GET SNAPSHOT FOR TABLESPACES output
• Plan and implement changes to disk space allocations using ALTER TABLESPACE options: ADD, EXTEND, RESIZE, DROP, and BEGIN NEW STRIPE SET
• Plan the implementation of Large Row Identifiers and Large table spaces to support increased table size
• Use the Health Monitor and Storage Management functions to track and monitor table space utilization

DB2 9 data row compression

• Describe the types of compression available in DB2 for Linux, UNIX, and Windows databases
• Explain how the REORG utility is used to build the compression dictionary and compress the data in a table
• Plan the implementation of data row compression for tables
• Utilize the ROWCOMPESTIMATE option of INSPECT to estimate the compression ratio for existing tables
• Describe the steps required to utilize row compression with range partitioned tables
• Query the DB2 catalog statistics to review the results of row compression for tables
• Describe compression for SAP

DB2 UDB database recovery review

• State the three types of recovery support
• Explain the basic principles DB2 uses for database recovery and restart
• Describe the capabilities and functional requirements of DB2 logging
• Select options for some of the DB2 database parameters that support recovery
• Configure the DB2 database parameters that support the DB2 logs
• Describe the user exit interface used to archive logs in previous DB2 versions
• Configure the database options to automate log management
• Describe the options provided by DB2 UDB to reduce log volume, including the NOT LOGGED INITIALLY option

DB2 High Availability Disaster Recovery (HADR)

• Describe the benefits and limitations of implementing High Availability Disaster Recovery (HADR)
• Implement HADR, including the setup of a Primary and Standby database
• Use the commands START HADR, STOP HADR, and TAKEOVER to manage an operational HADR system
• Plan for the use of the DB2 Utilities like LOAD, REORG, Backup and Restore in a HADR environment
• Select appropriate HADR database configuration options in order to meet the requirements of a specific application environment
• Monitor the status of the Primary and Standby database using GET SNAPSHOT FOR DATABASE or db2pd - hadr

Autonomic DB2 capabilities

• Describe the automatic database maintenance facilities and utilities
• Describe the STMM (Self Tuning Memory Manager)
• Describe the WLM (Work Load Manager)

Agenda

Day 1

• Welcome
• Unit 1 - SAP / DB2 integration
• Unit 2 - DB2 DPF partitioned database and MDC concepts
• Unit 3 - Advanced table space management

Day 2

• Unit 4 - DB2 9 data row compression (part 2)
• Unit 5 - DB2 database recovery review
• Unit 6 - DB2 high availability disaster recovery (HADR)

Back to top

HW/SW CONFIGURATION

The minimum hardware and software required to launch the course are:

• Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
• Windows 2000 or XP or Vista
• Computer with soundcard
• Headset or computer speakers
• Internet Explorer 5.01 or later, or Firefox 1.0 or later

Network Speed Test

http://clpext.moppssc.com/index.php?option=com_wrapper&view=wrapper&Itemid=8

User: clp

Pass: ibmeduc

For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be.

High-speed broadband internet access is the recommended configuration for this course.

Keyboard Configuration

If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.

Back to top