SAP Adaptive Server Enterprise Training

Module 1: Error Messages and Severity Levels

• Overview
• Notifying the System Administrator
• Variables in Error Message Text
• Finding Object Names in Error Message Text
• Object Names in Error Message Text
• Find the Table or Index Involved
• Disable the Trace Flag
• Creating Error Messages
• Parameters, Usage, and Permissions
• Ensuring Recoverability

Module 2: Ensuring Recoverability

• Bring Up the Server in Single‐User Mode
• Case Studies

Module 3: Allocating Storage to Objects

• Page and Object Allocation
• Pages Managing Space Allocation
• Object Allocation Map (OAM)
• Page Linkage
• Pages Managing Space Allocation
• OAM Pages and Allocation Pages
• How SAP ASE Allocate a New Page?
• Global Allocation Map (GAM) Pages

Module 4: Common Errors and Solutions

• Error Number 1142
• Incorrect System Function Use
• Incorrect OAM Page Entries
• State of Error
• Recovery from this Error 1142
• Incorrect OAM Page Entry in Sysindexes
• Error 1161, 1243, 7939, and 1120
• Error 1105
• Runtime 1105 Errors
• 1105 Error in tempdb
• 1105 Errors on Master Database ‐ Solution

Module 5: Checking and Fixing Database Consistency

• Checking Database Consistency
• Uses of DBCC Commands
• DBCC Checks, Checktable, Checkdb, and Checkstorage
• Uses of DBCC Checkstorage
• Steps in DBCC Checkstorage Operation
• DBCC Traceon and Traceoff
• Printopt ‐ Output Format for DBCC Page
• Cache and Vdevno Options
• DBCC Resource, fix_text, reindex, and Checkcatalog
• Comparison of the Performance
• Errors

Module 6: Physical Storage Errors, Causes, and Solutions

• DBCC DBINFO
• DBCC DBTABLE
• Error 905
• Short Term Action
• Long Term Solution
• Error 935
• Error is Raised with These States
• Error 14622
• Transaction Operations
• Prevent Such Operations