Seminar \ nr. 36701

Schulung - IBM CL413G - DB2 for LUW Performance Tuning and Monitoring Workshop

  • Präsenztraining
Download als PDF
Seminar
Inhouse
Individuell
Durchführung in unseren Räumen
Seminar Nr. : 36701
Dauer : 4 Tage (24 Stunden)

Preis
2.990,00 € netto
3.558,10 € inkl. 19% MwSt.

Ort
Datum
Jetzt buchen

Nach Absprache in Ihren oder unseren Räumen
Seminar Nr. : 36701
Dauer : 4 Tage (24 Stunden)

Inhouse-Paket*
Auf Anfrage

On-demand Training

Sind Sie an diesem Thema interessiert?
Unsere Experten entwickeln Ihr individuell angepasstes Seminar!

Teilen Sie dieses Seminar

Learn how to tune for optimum performance the IBM DB2 10 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Learn about DB2 10 for Linux, UNIX, and Windows in a single partition database environment. Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning.
Use tools in class that are common across the Linux, UNIX, and Windows environments. During labs running on DB2 10.1, develop your ability to use monitoring tools. Explain tools and DB2 utilities like RUNSTATS, REORG and db2batch to tune a database running on your local LINUX workstation.



GK Learning Solutions Partner

Zielgruppe

Wer sollte teilnehmen: ?

Zielgruppe

This is an advanced course for database designers, database administrators, and application developers working with DB2 for Linux, UNIX, and Windows who are concerned about performance.

Voraussetzungen

You should have completed:
- DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3G) or

- DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL484G)

Trainingsprogramm

Trainingsprogramm

Database Monitoring

Database I/O Management

Table space and Table Design for Performance

DB2 Memory Management

Automated Memory Management

Application Performance Considerations

Using Explain Tools

The DB2 Optimizer

Using Indexes for Performance

Complex SQL Performance

Tools and Utilities for Performance

Event Monitor

Schulungsmethode

Schulungsmethode

presentation, discussion, hands-on exercises, demonstrations on the system

Hinweis

Hinweis

Class language is German, student notebooks in English.

Weitere Informationen