Who Can Benefit
Students who can benefit from this course are:
- Developers and quality engineers who use HADB as component products, such as Sun Java System Application Server Enterprise Edition.
- Technical consultants and support engineers who work with customers using the Application Server and other Sun products that have HADB as a component and need deeper insight to support/troubleshoot the products
- The administrators who deploy Sun products at customer sites who need deeper understanding of HADB to manage and tune HADB instances correctly
Prerequisites
- Have a basic understanding or experience or both with Relational/Distributed Database Management Systems(DBMS), Standard Query Language (SQL) and JDBC
- Have basic UNIX administration skills (Solaris Operating System (Solaris OS) preferred)
- Have a basic understanding of Fault Tolerance, preferred though not required.
- Understand the fundamentals of HADB
Skills Gained
- Perform advanced configurations
- Scale HADB
- Monitor HADB
- Tune HADB
- Use the new management system introduced in the Sun Java System Application Server 7 2004Q2 Windows version, which will be used in the Sun Java System Application Server 8.1.
Course Content
Module 1 - Inside HADB
- Explain how HADB executes a transaction
- How a client connection is handled
- How two-phase commit works
- Explain how HADB stores and manages data, including shared memory layout, disk devices, checkpointing and locking.
- Describe how HADB nodes keep a consistent system view
Module 2 - Performing Advanced Management Tasks
- Configure the database to use heterogeneous data devices and double networks
- Manage a domain
- Scale the database online
- Describe how to upgrade the software and hardware on the HADB machines online, ie: Rolling Upgrade.
- Retrieve resource usage information
- Use the query tool - clusql to access the database
Module 3 - Monitoring and Tuning HADB
- Describe what an administrator should monitor
- How the database and the OS interact
- Which database configuration variables need to be tuned, and how to tune them
- Describe procedures for debugging HADB
- Describe the tasks performed by an administrator