Faites confiance à votre formation en TI |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.
ExitCertified renforce sa relation avec Red Hat en obtenant le statut de revendeur avancés.
Oracle University décerne à ExitCertified le prix de Qualité exceptionnelle des instructeurs.
ExitCertified en vedette dans le répertoire des Entrepreneurs dynamiques du 21e siècle.
ExitCertified est mis en candidature une troisième fois pour les prix de la Chambre de commerce.
ExitCertified élargit sa relation avec Apple en ajoutant la diffusion de formation agréée Mac OS à Phoenix, en Arizona.
 |
DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL482) |
 |
|
| Format: Formation en classe avec formateur |
| Autres formats: |
|
|
|
|
|
|
| |
This is the classroom version of Instructor-led online course 3L482 This course teaches you to perform, basic and advanced, database administrative tasks using DB2 9 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools. Various diagnostic methods will be presented, including using the db2diag.log file messages to direct your investigation of problems, as well as using the commands db2pd, INSPECT, and db2support and DB2 traces. Learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. This course provides a quick start to DB2 database administration skills for experienced relational Database Administrators (DBA). You will get practical experience in the basic and advanced database administrative tasks of a wide variety of DB2 LUW utilities and functions by performing a series of lab exercises on a Linux platform. The exercises build skills that can be applied to DB2 database servers on any Linux, UNIX or Windows environment. Course Materials The course materials address DB2 9 for Linux, UNIX, and Windows, Version 9.7. Hands-On Labs Ten labs are included to address DB2 9 for Linux, UNIX, and Windows, Version 9.7. Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. |
|
|
|
|
|
|
|
 |
|
 |
Compétences acquises |
| |
- Administer a DB2 database system using commands and GUI tools
- Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply data placement principles
- Implement a given logical database design using DB2 to support integrity and concurrency requirements
- List and describe the components of DB2
- Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
- Describe the application development process with respect to DB2 considerations
- Use autonomic features of DB2
- Implement DB2 security
- Effectively apply advanced techniques to administer a DB2 database
- Explore the DB2 recovery facilities and database configuration options
- Perform the implementation of automated archival and retrieval of database logs
- Identify Explain tools to examine access strategies
- Select the appropriate utility to relocate a database or a portion of a database, including using the RESTORE utility or the db2relocatedb command
- Use the DB2 Design Advisor to analyze SQL statements to suggest new indexes to improve application performance
- Examine Explain output to determine access strategy chosen by Optimizer
- Use the db2diag.log file messages to direct your investigation of problems using db2pd, INSPECT, db2support, and DB2 traces
- Use DB2 health monitoring and Health Center to review the health indicator status for the instance, database and table space
|
|
|
|
|
Hands-On Labs |
| |
Ten labs are included to address DB2 9 for Linux, UNIX, and Windows, Version 9.7.
| | | |
|
|
|
| |
 | 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: |
CL482 |
| Format: |
Formation en classe avec formateur |
|
| Durée: |
4 days |
| Certifié par: |
IBM |
|
| Frais d’inscription (CAD): $contact |
|
|
 |
|
|
|
|
 | Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date. |
|
|
|
DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL482) Contenu détaillé |
| |
| |
| Overview of DB2 9 on Linux, UNIX and Windows | - Contrast the DB2 Family of products
- Identify the DB2 Products
- Describe the functions of DB2 components
- Explore installation and parameters
| |
| Command Line Processor (CLP) and GUI usage | - Use the Command Line Processor
- Explore the GUI environment
- Describe the DAS role with GUI tools
| |
- Specify the key features of an Instance
- Create and drop an Instance
- Use db2start and db2stop
- Distinguish between types of configuration
- Describe and modify the Database Manager Configuration
| |
| Creating databases and data placement | - Review specifics of creating a database
- Explore the System Catalog tables and views
- Compare DMS versus SMS table spaces
- Describe how to setup and manage a DB2 database with Automatic Storage enabled
- Differentiate between table spaces, containers, extents, and pages
- Define table spaces
- Use the get snapshot for tablespaces command to display table space statistics
- Explore Database configuration parameters
| |
| Creating database objects | - List DB2 object hierarchy and physical directories and files
- Create the following objects: Schema, Table, View, Alias, Index
- Review the use of Temporary Tables
- Explore the use and implementation of Check Constraints, Referential Integrity and Triggers
- Explore the need for and the use of Large Objects
- Use the db2look utility to export database structures for future use
- Recognize XML and its native store as critical infrastructure for emerging technologies
| |
- Discuss the INSERT statement and recognize its limitations
- Explain the differences between IMPORT and LOAD
- Explain the EXPORT, IMPORT, and LOAD syntax
- Create and use Exception Tables and Dump-Files
- Distinguish and resolve Table States: Load Pending and Set Integrity Pending
- Use the SET INTEGRITY command
- Discuss the db2move and db2look commands
| |
- Describe the major principles and methods for backup and recovery
- State the three types of recovery used by DB2
- Explain the importance of logging for backup and recovery
- Describe how data logging takes place, including circular logging and archival logging
- Use the BACKUP, RESTORE, and ROLLFORWARD commands
- Perform a table space backup and recovery
- Restore a database to the end of logs or to a point-in-time
- Discuss the configuration parameters and the recovery history file and use these to handle arious backup and recovery scenarios
| |
- Explain why locking is needed
- List objects that can be locked
- Describe and discuss the various lock modes and their compatibility
- Explain four different levels of data protection
- Set isolation level and lock time out for current activity
- Explain lock conversion and escalation
- Describe the situation that causes deadlocks
| |
- Collect information for problem analysis and resolution
- Use error logs for basic problem analysis
- Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor, and Health Monitor
- Describe the function of EXPLAIN and use this facility to assist basic analysis
- Use a series of basic commands to better work with connections and sessions
- Retrieve statistics and other information from a running DB2 instance
- Use RUNSTATS, REORGCHK, and REORG to resolve application performance problems
| |
- Use DB2 access control mechanisms to implement security within the database
- Use group IDs to create a control hierarchy
- Describe privileges within a database
- Describe privileges required for binding and executing a package
- Describe the difference between explicit privileges and implicit privileges
- Describe the different DB2 authorization levels
- Describe Label Based Access Control (LBAC)
- Explain the use of Roles and Trusted Context
| |
| |
| DB2 Recovery Log Management | - Select the DB2 Database parameters that support the DB2 logs
- Configure the database options to automate archive log management
- Implement infinite active logging to support applications that require large amounts of logged database changes
- Describe the options provided by DB2 9 for Linux, UNIX, and Windows to reduce log volume, including the NOT LOGGED INITIALLY option
| |
| DB2 Database and Table Space Relocation | - Explain the facility of the DB2 RESTORE command to recover table spaces to different containers
- Use the SET TABLESPACE CONTAINERS command to define new containers during a redirected restore
- Utilize the RESTORE utility to change the database storage paths for AUTOMATIC STORAGE table spaces
- Plan the use of redirected restore as part of a disaster recovery
- Describe two methods that can be used to convert a DMS tablespace to utilize automatic storage
- Use the GENERATE SCRIPT option of RESTORE to set up a command script for a redirected restore operation
- Use db2relocatedb when moving or copying DB2 databases with non-DB2 utilities
| |
- Describe the advantages of using Visual Explain
- Describe the advantages of using db2exfmt
- Create special tables used by Visual Explain and db2exfmt
- Identify how to set the explain snapshot and explain mode registers to capture the information of interest
- Differentiate between the different methods of viewing explain information
| |
| Using Indexes for Performance | - Describe the Indexing options that can be used to improve performance: Index Only Access, Clustered Index, Reverse Scans, Include Columns, and Index Freespace
- Describe the Block Indexing capability for MDC tables
- Monitor index usage using the MON_GET_INDEX function and db2pd commands
- Explain how multiple indexes can be combined using Index ORing and Dynamic Bitmap Index ANDing
- Use the Design Advisor to predict performance gains from adding new indexes
| |
| Advanced Problem Determination | - Describe the types of information collected by DB2 that can be used to diagnose problems, including the db2diag.log and the administration notification log
- Plan the use of various diagnostic tools to address specific problems, including the db2diag command, db2pd, db2dart, inspect, db2top and db2level
- Collect supporting information for DB2 database problems using db2support and db2trc
- Explain how automatic and manual First Occurrence Data Capture (FODC) facilities can help collect diagnostic information
- Analyze DB2 generated messages in the db2diag.log file and choose appropriate tools and commands to resolve the problems
- Utilize the Health Monitoring functions of DB2 to check the health indicators for a DB2 instance, database, or table space
| |
| |
- Welcome
- Overview of DB2 9 for Linux, UNIX, and Windows
- Command Line Processor (CLP) and GUI usage
- The DB2 environment
- Exercise 1: Customization
- Creating databases and data placement
- Exercise 2: Creating databases and data placement
- Creating database objects
- Exercise 3: Creating database objects
- Moving data
| |
- Exercise 4: Moving data
- Backup and recovery
- Exercise 5: Backup and recovery
- Locking and Concurrency
- Problem determination
- Exercise 6: Locking and Concurrency
- Security
| |
- DB2 Recovery Log Management
- Exercise 7: Recovery Log Management
- Database and table space relocation
- Exercise 8: Table space relocation
- Using Explain Tools
| |
- Using Indexes for performance
- Exercise 9: Using Indexes for performance
- Advanced Problem Determination
- Exercise 10: DB2 Advanced problem determination
| |
| |
|
