Faites confiance à votre formation en TI |

Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

DB2 9 for z/OS Index Modeling and Design (CV940)

Catégorie: Formation

Information Management - DB2

Format: Formation en classe avec formateur

Autres formats:

This course is designed to teach you how to design the right indexes for improving query performance, both for single table access and for multiple table access.

All of the index utilization possibilities are illustrated as well as the desired column sequence of a multiple column index. Pros and cons of DPSI and NPSI indexes are explained together with the lesser known concepts like index lookaside, implicit uniqueness, sparse indexes, and combination of index screening with list prefetch. The course also clarifies the meaning of many DB2 catalog columns pertaining to the indexes and shows how to correctly use the different RUNSTATS options related to indexes.




	Compétences acquises
	Describe different index formats and reasons for using indexes Design indexes for matching, screening, index only, clustering, list prefetch, partitioning, and avoiding unnecessary sorts Use RUNSTATS options related to indexes Model the best indexes for Star Schema Recognize superfluous indexes and eliminate them Evaluate benefits of index compression Run the operational utilities for indexes




	Qui peut en profiter
	This advanced course is for DB2 for z/OS application developers, DB2 for z/OS DBAs, and anyone who is responsible for designing the best indexes for queries in a DB2 for z/OS environment.




	Préalables
	You should have: Familiarity with DB2 for z/OS queries and application programming.




	Abstract
	IBM Education Advantage Program eligibility: Yes - IBM Education Pack - Online Account

Ce cours est donnÃ© par des formateurs certifiÃ©s IBM.

Ã€ titre de partenaire en formation agrÃ©Ã©e , ExitCertified peut vous inscrire Ã nâ€™importe quel cours en AmÃ©rique du Nord.

Il y a une diffÃ©rence. DÃ©couvrez-la

Code:	CV940
Format:	Formation en classe avec formateur

Durée:	3 days
Certifié par:	IBM

Frais d’inscription (CAD): $contact

TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011


Manhattan/New York, NY	Oct.15 - Oct.17.2012

1 Dates Offered

DB2 9 for z/OS Index Modeling and Design (CV940) Contenu détaillé

Generalities

Describe the general structure of DB2 indexes
Discuss the advantages of Type 2 indexes used in DB2

Different Index Forms and Distinct Reasons for Using Indexes

List many kinds of indexes that can be created
Differentiate between index matching and index screening
Discuss advantages and pitfalls of list prefetch access
Understand the meaning of multiple index access
Create indexes for index only access and for avoiding sort
Highlight the importance of clustering index
Distinguish between partitioning and partitioned indexes

Index Enhancements in DB2 V9

Discuss the indexing enhancements introduced in DB2 V9
- Uniqueness and parallelism for Data Partitioned Secondary indexes
- Index on expression
- Automatic creation of indexes
- Asymmetrical split of index pages
- Detection of unused indexes
- Renaming an index
- RANDOM index keys
- Index page size larger than 4 KB
- Index compression
- Page range screening enhancements
- Online REBUILD INDEX

Indexes for Joins

Create indexes to enable joins to perform efficiently
Create indexes to enable subqueries to perform efficiently
Appreciate the importance of clustering and impact on joins

Index Versioning

Discuss index versioning
Understand when new index versions are created

Less Known Index Features

Discuss some of the less known index features
Differentiate between creating index with DEFINE NO and DEFER YES options
Explain index look aside technique and when it is used
Understand the importance of system parameter NPGTHRUSH prior to DB2 V8
Understand the significance of volatile tables since DB2 V8

Operational Utilities for Indexes

Describe the operational considerations for indexes
Enable indexes for image copies
Differentiate between RECOVER INDEX and REBUILD INDEX

Index Cost

Perform the cost-benefit analysis of indexes
Take steps to reduce index costs without compromising on performance

Indexes for Star Schema

Create indexes on FACT table and Dimension tables
Highlight enhancements introduced in DB2 V9 for Star Joins

Agenda

Day 1

Welcome
Unit 1 - Generalities
Unit 2 - Different index formats and distinct reasons for using indexes

Day 2

Unit 2 - Different index formats and distinct reasons for using indexes
Unit 3 - Indexing enhancements in DB2 V9

Day 3

Unit 4 - Indexes for join
Unit 5 - Index versioning
Unit 6 - Less known index features
Unit 7 - Operational utilities for indexes
Unit 8 - Index cost
Unit 9 - Indexes for Star Schema

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.ca/ibm-training/CV940.html

Message:


	Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source. Il y a une différence. Apprenez directement de la source.



Canada	United States
Formation à Montréal :: 514.876.1666 Formation à Ville de Québec :: 514.876.1666 Formation à Ottawa :: 613.232.3948 Formation à Toronto :: 416.487.3948 Formation à Vancouver :: 604.633.3948 Formation à Victoria :: 1.866.328.3948 Formation à Calgary :: 403.291.2855 Formation à Edmonton :: 780.441.3948 Formation à Regina :: 1.866.328.3948	Formation à Sacramento :: 916.669.3970 Formation à San Francisco :: 415.975.3948 Formation à San Jose :: 408.288.3948 Formation à Las Vegas :: 1.800.803.3948 Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948	Des questions? Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.

ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :

Formation Sun	Formation Oracle	Formation Symantec	Formation IBM	Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris	Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle	Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec	DB2, OS/400, Formation zSeries, s/390, iSeries, AIX	SUSE, Formation RedHat

Formation MySQL	Formation Apple	Formation en gestion de projet
Base de données MySQL	Cours Apple, Formation Leopard	Formation du PMI

DB2 9 for z/OS Index Modeling and Design (CV940)

Compétences acquises

Qui peut en profiter

Préalables

Abstract

Formation de IBM (2375 cours)

Formation de Information Management - DB2 (103 cours)

Formation de DB2 for z/OS (45 cours)

DB2 9 for z/OS Index Modeling and Design (CV940) Contenu détaillé