Troubleshooting Adaptive Server Data Structures

Product type
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

Goals

  • 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)

Audience

  • Database Administrators who are responsible for the troubleshooting and repair of Adaptive Servers.
  • System Administrators who are responsible for the maintenance of Adaptive Server storage and internal structures.
  • Performance and Tuning Specialists who have system and/or database administration responsibility in managing Adaptive Server environme…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Goals

  • 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)

Audience

  • Database Administrators who are responsible for the troubleshooting and repair of Adaptive Servers.
  • System Administrators who are responsible for the maintenance of Adaptive Server storage and internal structures.
  • Performance and Tuning Specialists who have system and/or database administration responsibility in managing Adaptive Server environments

Prerequisites

Essential
  • * Completion of Fast Track to Adaptive Server Enterprise (EDB115) * Completion of System and Database Administration: Adaptive Server Enterprise (EDB356) * Completion of Advanced Administration and Troubleshooting for Adaptive Server Enterprise (EDB652) * Highly recommended - Completion of Performance and Tuning: Configuring Adaptive Server Enterprise (EDB553) * Minimum 6 months of DBA experience with Adaptive Server Enterprise

Content

  • Page Management structures: Allocation pages, OAM pages, GAM Pages
  • In-depth understanding of many dbcc commands and their usage
  • Details of physical storage, DBINFO, DBTABLE
  • Data, Index, Control and Text/Image page layout for APL and DOL tables, page linkage, disk init, and dsync
  • APL and DOL Index structures
  • Page and extent allocation / deallocation
  • Logging; how to read log pages in detail
  • Recovery internals
  • Recovery Fault Isolation, bypass recovery

Notes

  • Designed for customers responsible for gaining expert level skills in maintaining optimal environment performance levels, server availability, and advanced management. Moving beyond the topics covered in the Advanced Administration and Troubleshooting courses, this course addresses in great detail the inner workings of ASE versions 12.5 thru 15.0.3 for experienced, highly technical DBA's.

Popular tags

No tags submitted for this course yet

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.