DB2 10.1 for LUW New Features and Database Migration Considerations (WBT)
Course
In London
Description
-
Type
Course
-
Location
London
-
Start date
Different dates available
DB2 10.1 for LUW New Features and Database Migration Considerations (WBT) Training CourseGet 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...
Facilities
Location
Start date
Start date
Reviews
Subjects
- DB2
- Database
- Database training
- Performance
- Access
- Windows
- Linux
- Access Control
- IT Security
- Security
- Unix
Course programme
- 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
Additional information
Expenses
DB2 10.1 for LUW New Features and Database Migration Considerations (WBT)