• Välj land/region: Sverige
  • IBM®
  • Site map

  • Utbildning
  • Kurskatalogen

Kursbeskrivning: DB2 10.1 for LUW New Features and Database Migration Considerations - ILO - New

Kursen har inget datum. Ring vår kursbokning 077 186 10 37 för information om en privat utbildning.

  • Lägg till min egen katalog
  • Lägg till min träning önskelista

Översikt

  • Målgrupp
  • Förkunskaper
  • Mål
  • Nyckelområden
List of course details in a data table
Kurskod 3L313SE Leveranstyp Instructor Led - Online Training
Kurslängd 2.0 dagar Kurstyp
Listpris SEK 12 500,00 exkl moms
SEK 15 625,00 inkl moms
   

This course replaces course DB2 9.7 for Linux, UNIX, and Windows New Features - Instructor Led Online (3L312SE). This is the Instructor-led online version of Classroom course DB2 10.1 for LUW New Features and Database Migration Considerations (CL313SE).

This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions.

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.

Visa den här kursen i andra länder


Roadmaps:

  • DB2 for Linux, UNIX and Windows Transition

Tillbaka till toppen

Målgrupp

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.

Tillbaka till toppen

Förkunskaper

You should have

  • experience supporting DB2 LUW Version 9.5, 9.7 or 9.8 databases.

Tillbaka till toppen

Mål

Please refer to the course overview.

Tillbaka till toppen

Nyckelområden

Please refer to the course overview.

Tillbaka till toppen

My IBM

  • Profiländring

E-mail IBM

Vi finns till din hjälp. Skicka ett e-mail till våra utbildnings- specialister så kan de kontakta dig och hjälpa dig.

  • e-mail IBM Training
  • eller ring
    077-186 10 37

Viktig information

  • SE Schedule
  • Min kursbeställning
  • Träning önskelista

  • Avtalsvillkor
  • Hur hittar jag till kurslokalen?

  • Utbildning
  • Kurskatalog
  • Kurser A-Ö
  • Sök kurs för kursbokning
  • Training Worldwide
  • Training News
  • Certifiering
  • e-Learning
  • IBM Redbooks Workshops
  • Business Partner