IBM - Informix 11.7 New Features

PROKODA Gmbh
In München

1.750 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

  • Seminar
  • Fortgeschritten
  • München
  • Dauer:
    3 Tage
Beschreibung

IBM - Informix 11.7 New Features: Zielgruppe This course is for Informix System Administrators, Database Administrators, and Applications Developers. Kursziele Install Informix 11.7 using the GUI, console, or silent option Perform defragment operations on table fragments Use new event alarms and options Submit new types of tasks to the database scheduler Enable implicit PDQ..
Gerichtet an: Zielgruppe This course is for Informix System Administrators, Database Administrators, and Applications Developers. Kursziele Install Informix 11.7 using the GUI, console, or silent option Perform defragment operations on table fragments Use new event alarms and options Submit new types of tasks to the database scheduler Enable implicit PDQ for an SQL session Perform system backups to Amazon Simple Storage Service Enable the automatic registration of DataBlades Create...

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
München
Werner-Eckert-Str.11, 81829, Bayern, Deutschland
Plan ansehen

Häufig gestellte Fragen

· Voraussetzungen

It is recommended that you attend the following courses: Informix System Administration (IX811) Informix Database Administration: Managing and Optimizing Data (IX221) Informix Replication (IX421)

Themenkreis

KURSZIEL
IBM - Informix 11.7 New Features: Zielgruppe
This course is for Informix System Administrators, Database Administrators, and Applications Developers.

Kursziele

  • Install Informix 11.7 using the GUI, console, or silent option
  • Perform defragment operations on table fragments
  • Use new event alarms and options
  • Submit new types of tasks to the database scheduler
  • Enable implicit PDQ for an SQL session
  • Perform system backups to Amazon Simple Storage Service
  • Enable the automatic registration of DataBlades
  • Create and use a Forest of Trees index
  • Describe situations in which a multi-index scan can be used for maximum benefit
  • Design queries that can use star or snowflake joins
  • Fragment tables based on a list of values or on a time interval
  • Explain the benefits of storing statistics at the fragment level
  • Enable DDL statements to run on a high-availability secondary server
  • Explain how to repair timestamps on participating ER servers when a participant is checked or synchronized
  • Describe the options available when a logical log lag situation occurs
  • Manage all participating ER servers from a single server
  • Create and alter tables with shadow columns that can be used in place of primary keys
  • Explain the purpose of the transaction survival feature
  • Explain the purpose of a rolling upgrade
  • Use embedability tools to create and deploy snapshots of Informix servers
  • Use storage pools to enable Informix to automatically expand storage space when needed
  • Preload user-defined C routines
  • Use the SPL Debugger to debug SQL statements and SPL routines
  • Initiate row-level auditing on tables in a database
  • Map remote Informix users to local OS user IDs
  • Enable the reuse of a connection to the Informix server as a different user

ZIELGRUPPE
Zielgruppe
This course is for Informix System Administrators, Database Administrators, and Applications Developers.

Kursziele

  • Install Informix 11.7 using the GUI, console, or silent option
  • Perform defragment operations on table fragments
  • Use new event alarms and options
  • Submit new types of tasks to the database scheduler
  • Enable implicit PDQ for an SQL session
  • Perform system backups to Amazon Simple Storage Service
  • Enable the automatic registration of DataBlades
  • Create and use a Forest of Trees index
  • Describe situations in which a multi-index scan can be used for maximum benefit
  • Design queries that can use star or snowflake joins
  • Fragment tables based on a list of values or on a time interval
  • Explain the benefits of storing statistics at the fragment level
  • Enable DDL statements to run on a high-availability secondary server
  • Explain how to repair timestamps on participating ER servers when a participant is checked or synchronized
  • Describe the options available when a logical log lag situation occurs
  • Manage all participating ER servers from a single server
  • Create and alter tables with shadow columns that can be used in place of primary keys
  • Explain the purpose of the transaction survival feature
  • Explain the purpose of a rolling upgrade
  • Use embedability tools to create and deploy snapshots of Informix servers
  • Use storage pools to enable Informix to automatically expand storage space when needed
  • Preload user-defined C routines
  • Use the SPL Debugger to debug SQL statements and SPL routines
  • Initiate row-level auditing on tables in a database
  • Map remote Informix users to local OS user IDs
  • Enable the reuse of a connection to the Informix server as a different user

KURSINHALT
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.
In this course, learn about the new features that are included with the 11.70 release of IBM Informix. Features include a replication grid management facility, updated installer, fragmentation enhancements, new indexing options, new query optimization features, a debugger for stored procedure language (SPL) coding, new scheduler tasks, support for system and log backup to the Cloud, and many others. A new replication grid management facility provides a central administration tool for administration of HDR primary and secondary servers, RS server, SD servers, and Enterprise Replication participants. Embedability and deployment tools are also included to enable you to package snapshots of Informix instances and data.
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.

Themenübersicht

System Administration Features

  • 11.70 Installer
  • Partition Defragmenter
  • Unique Event Alarms
  • New Database Scheduler Tasks
  • Implicit PDQ
  • Backup to Cloud

Database Administration Features

  • Auto Register of DataBlades
  • Forest of Trees Index
  • Multi-Index Scan
  • Star Join and Snowflake Queries
  • Fragmentation List and Interval Strategies
  • Fragment-Level Statistics

Replication/Grid

  • DDL Support for HDR Secondary Servers
  • ER Features
  • On-Step Instantiation Snapshot
  • Grid-Based Replication
  • Replication Without a Primary Key
  • Transaction Survival
  • Rolling Upgrade

Embedability

  • Embedability Toolkit
  • Storage Provisioning
  • C-UDR Preloading
  • SPL Debugger

Security Features

  • Selective Row-Level Auditing (SRLA)
  • Informix Mapped Users
  • Trusted Context

Maschinenanforderungen
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

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.


VORRAUSSETZUNG
It is recommended that you attend the following courses:

  • Informix System Administration (IX811)
  • Informix Database Administration: Managing and Optimizing Data (IX221)
  • Informix Replication (IX421)


Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen