Training Course:Troubleshooting Adaptive Server Data Structures (Certificate)School/Trainer:Sybase, Inc.
Ottawa, Toronto, Ontario, Canada
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Gain a deeper understanding of the data structures inside Sybase Adaptive Server Enterprise (ASE) 12.5.0.1 and how they are allocated and de-allocated. This expert-level course gets you “under the hood�and exposes you to in-depth technical detail. Use this knowledge to prevent potential problems from database corruption and to reduce time working with Sybase Technical Support. Troubleshoot, recognize, locate, and resolve corruption problems to save time and data. Learn to read and understand the contents of the transaction log and troubleshoot full logs. Understand the implications for performance, logging, and recovery. Possible database corruption, potential resolutions, and tradeoffs are discussed. Learn how to use Sybase utilities to troubleshoot the server. Lab time covers many dbcc commands and is used to troubleshoot the server for various types of database corruption.
Course Objectives :
Upon completion of this course, you will be able to:
Understand the inner workings of Adaptive Server data structures
Use dbcc to discover potential data corruption problems
Identify and resolve different types of data corruption
Understand how transactions are logged and troubleshoot full logs
Read and understand the contents of the transaction log
Use Recovery Fault Isolation (RFI)
Course Topics :
Details of physical storage, DBINFO, DBTABLE, dbcc usage, page management structures and processes (allocation pages, OAL pages, GAM pages), data, index, control and text/image page layout for APL and DOL tables, page linkage, disk init, and dsync, index structure, page and extend allocation/de-allocation, logging (how to read log pages in detail), recovery internal, and recovery fault isolation and bypass recovery.
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.sybase.com/
Phone:(978) 287-1626
School Address:
Sybase, Inc.
Toronto Learning Center
175 Bloor Street East, Suite 800
Phase 1 - North Tower
Toronto, Canada M4W 3R8
Jobs & Resumes: Ottawa, Toronto
Houses & Roommates: Ottawa, Toronto
Travel Agencies: Ottawa, Toronto
Search other schools for Troubleshooting Adaptive Server Data Structures training resources.
Other training courses offered by Sybase, Inc.:
Migrating to Sybase IQ 15
POWERDESIGNER 15 MIGRATION
POWERBUILDER 11.5 MIGRATION
Moving to PowerBuilder 11.5
Performance and Tuning: Configuring Adaptive Server Enterprise
Advanced Administration and Troubleshooting for Adaptive Server Enterprise
SQL
Quick-Start for ASE Administrators of SAP/BusinessOne
High Availability: Adaptive Server Enterprise 12.0 Companion Server
Performance & Tuning using MDA Tables
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal. |
|
|
