Kurs informasjon: DB2 10.1 for Linux, UNIX, and Windows New Features and Database Migration Considerations (WBT)

This is the Web-based version of Classroom course DB2 10.1 for LUW New Features and Database Migration Considerations (CL313NO), Instructor-led ine course DB2 10.1 for LUW New Features and Database Migration Considerations - ILO (3L313NO) and Self-paced Virtual course (2L313NO).

NOTE: 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 1 year to complete this course.

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.

Get the technical information about the new functions and features available in DB2 10.1 for Linux, UNIX, and Windows and plan the migration for DB2 Version 9.5, 9.7 or 9.8 database systems to DB2 LUW 10.1.

DB2 Version 10.1 for Linux, UNIX, and Windows continues to deliver database efficiency, simplicity, and reliability. Important new features and enhancements address the needs of your business. Whether your needs are improving business critical reliability and performance, simplifying consolidation and security, increasing business insight, reducing costs, or providing a resilient system for the valuable information assets of your company, DB2 Version 10.1 delivers.

The course will describe the adaptive compression feature of DB2 LUW 10.1 that improves table compression through an advanced row compression technique that uses two levels of compression dictionaries (table-level and page-level) to improve compression ratios, particularly as data changes.

DB2 LUW 10.1 support for Multi-temperature storage allows administrators to define storage groups that can be used to assign data based on performance characteristics and migrate data to a storage group with lower cost devices or lower performance when the demand for that data declines.

The lectures will describe the DB2 LUW 10.1 performance related features including improved query optimizer techniques and functionality including star schema query optimization, improved data and index prefetching, and improved use of statistical views.

We will discuss how to implement system period and application period temporal tables associated with Time Travel Query to assign time-based state information to your data, so you can query the past state of your data.

DB2 LUW 10.1 introduces row and column access control (RCAC), as an additional layer of data security. Row and column access control is sometimes referred to as fine-grained access control or FGAC. We will discuss using RCAC to control access to a table at the row level, column level, or both and how RCAC can be used to complement the table privileges model.

The database high availability feature HADR is significantly enhanced with DB2 LUW 10.1. We will discuss how with DB2 10.1 you can define up to three standby databases. The lecture will also explain how to implement one standby database with the new time-delayed replay feature, which helps to recover from application errors that cause data loss on the primary.

We will cover various migration planning and installation considerations to help move existing DB2 LUW databases to DB2 LUW 10.1 to take advantage of the new features and functions.

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.

View this course in other countries

Roadmaps:

• DB2 for Linux, UNIX and Windows Transition

Til top

This intermediate course is for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 LUW 10.1 databases and have experience working with DB2 LUW Version 9.

Til top

You should have experience supporting DB2 Linux, UNIX and Windows Version 9.5, 9.7 or 9.8 databases.

Til top

• Explain how storage groups can be defined to implement multi-temperature storage for a database
• Use CREATE STOGROUP and ALTER STOGROUP statements to manage storage groups
• Describe the options to define multiple HADR standby databases
• List the DB2 pureScale enhancements in DB2 10.1 for high availability and database recovery functions
• Describe how a index jump scan can efficiently use multi-column indexes to process queries
• Define table constraints and create indexes to support zigzag join processing for access to star schemas
• Describe the use of page level dictionary data to support adaptive row compression
• Use the table function ADMIN_GET_TAB_COMPRESS_INFO to analyze the benefits of Classic and adaptive row compression methods for a table
• Explain the difference between a System-period temporal table and an Application-period temporal table
• Create a system-period temporal table and an associated history table
• Create a CHANGE HISTORY event monitor to track configuration changes or DB2 utility processing
• Use the CREATE PERMISSION statement to define row access controls
• Define column based access control using the CREATE MASK statement
• Activate or deactivate row or column access controls using the ALTER TABLE statement
• Plan the upgrading of existing DB2 database servers to DB2 10.1
• Configure new Database Manager and Database configuration options to enable new DB2 10.1 functions

Til top

• Welcome
• Unit 1 - DB2 10.1 Storage Management Features
• Unit 2 - DB2 10.1 Database Availability Features and Functions
• Unit 3 - DB2 10.1 Database Performance Features
• Unit 4 - DB2 10.1 Adaptive Compression
• Unit 5 - Temporal Tables and Time Travel Query with DB2 10.1
• Unit 6 - DB2 10.1 Database Monitoring Enhancements
• Unit 7 - Using Row and Column Access Controls (RCAC) with DB2 10.1
• Unit 8 - DB2 10.1 Server Upgrade Essentials

Til 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.

Til top