![]() | ![]() |
Home |
|
|
Troubleshooting and Error Messages Guide |
|
| About This Book |
The Sybase Adaptive Server Enterprise Troubleshooting and Error Messages Guide contains troubleshooting procedures for problems that Sybase® users may encounter when using Sybase Adaptive Server EnterpriseTM. The problems addressed here are those which the Sybase Technical Support staff hear about most often. The guide is applicable to Versions 11.9.2 through 12.5.0.1, and its purpose is:
To provide enough information about certain error conditions so that you can resolve problems without help from Technical Support.
To provide lists of information that you can gather before calling Technical Support, which will help resolve your problem more quickly.
To provide you with a greater understanding of Sybase products.
Adaptive Server Enterprise is referred to as Adaptive Server in the remainder of this book.
This guide is intended for the following:
Sybase System and Database Administrators
Sybase Technical Support contacts
Developers of applications using Sybase software
This guide assumes that you are thoroughly familiar with the Sybase products. If you are unfamiliar with any of the procedures described in this guide, call Sybase Technical Support for assistance.
The Troubleshooting and Error Messages Guide contains the following chapters:
Chapter 1, "System Database Recovery" includes step-by-step procedures for recovering from various disaster situations involving Sybase system databases. Read this chapter before disasters occur so that recovery will be easier.
Chapter 2, "Encyclopedia of Tasks" describes a variety of useful tasks, including those required for recovery from disaster situations.
Chapter 3, "Error Message Writeups" contains detailed information about common Sybase Adaptive Server error messages, including the text of each message, potential causes of the error, and what you can do to recover from the error. The messages are listed in numerical order. Some error message types fall into more than one number sequence. For example, dbcc errors are in the 25xx range and are also in the 79xx range. Since the error message writeups are presented in numerical order, there is more than one section titled "dbcc Errors." Only the most commonly occurring error messages are documented in this chapter.
You can create a complete listing of the Adaptive Server error messages for your installation by issuing the following isql commands:
1> use master 2> go
1> select * from sysmessages 2> go
Additional chapters contain reference information about Sybase Adaptive Server, Backup Server, and Component Integration Services (CIS) error messages, including the text of each message and a brief troubleshooting tip with instructions on what to do first when you encounter the error. All numbered error messages are documented in these chapters.
The Troubleshooting and Error Messages Guide refers you to other Sybase manuals for additional information about commands and concepts mentioned in the writeups as well as information you need to make decisions about your Adaptive Server. The following documents are referred to frequently:
Adaptive Server Enterprise Reference Manual - this manual contains detailed information on Adaptive Server commands and system stored procedures. This document is referred to as the Reference Manual in the remainder of this book.
Adaptive Server Enterprise System Administration Guide - this guide provides detailed information about administering servers and databases. This document is referred to as the System Administration Guide in the remainder of this book.
Adaptive Server Enterprise Performance and Tuning Guide - this guide provides detailed information on Adaptive Server performance and tuning. This document is referred to as the Performance and Tuning Guide in the remainder of this book.
Adaptive Server Enterprise Transact-SQL User's Guide - this guide describes Transact-SQL®, the Sybase-enhanced version of the relational database language. This document is referred to as the Transact-SQL User's Guide in the remainder of this book.
The following changes have been made to the Troubleshooting and Error Messages Guide:
The following topic has been added to the System Database Recovery chapter:
How to Fix Problems Encountered by disk refit
The following topics have been updated in the System Database Recovery chapter:
Finding the Appropriate Recovery Scenario
Master Device Is Lost and Valid Dump Exists
The model Database is Lost or Corrupted
Master Device is Going Bad
Manually Rebuilding Adaptive Server with bcp (previously Manually Rebuilding Adaptive Server with bcp and buildmaster).
The following topics have been added to the Encyclopedia of Tasks chapter:
Troubleshooting XP Server Issues.
How to Obtain a CSMD Dump.
The following topics have been updated in the Encyclopedia of Tasks chapter:
How to Rebuild master Database and Leave Master Device Intact
How to Analyze dbcc checkstorage Faults
How to Choose Between Raw Partitions and UNIX Files
How to Reduce the Size of tempdb.
New detailed writeups have been added to the Error Message Writeups chapter for the following messages:
Parser Error: 195
Sequencer Errors: 241, 7783, 11018, 14200
Query Processor Errors: 301, 546
Buffer Manager Error: 832
dbcc Error: 2547
dump and load Errors: 3019, 3020
Component Integration Services (CIS) Error: 11203
Kernel Errors: basis_daioconfig Error
Detailed writeups of the following messages in the Error Message Writeups chapter have been modified (or the message text changed):
Sequencer Errors: 216
Query Processor Errors: 414, 511, 539, 540
Access Method Errors: 629, 631
Memory Manager Error: 701
Open Database Manager Error: 950
Lock Manager Error: 1205
Sort Manager Error: 1501
Initialization Errors: 1605, 1613, 1621
Create Utility Errors: 1702
dbcc Errors: 2509, 2510, 2511
Bulk Copy Utility Error: 4806
alter table Errors: 4951, 4964, 4981
Configuration Error: 5852, 5861, 5863
Text Manager Error: 7105
Kernel Errors: Stack Guardword Error
All Adaptive Server error message listings have been updated, including the message text and troubleshooting guidelines.
Updated instructions are provided on how to access the Sybase Customer Service and Support World Wide Web page for the latest support information and services.
In order to continue to improve the Troubleshooting and Error Messages Guide, we need your feedback. Send your comments about the guide to the email address tsg@sybase.com.
Comments might include:
Corrections
Requests for specific additions
Material you would like to submit
Comments about which sections are particularly helpful
Comments about which sections are not clear
Any other input you might have
The tsg@sybase.com email address is for comments about the troubleshooting guide. It is not for reporting problems or asking technical questions. To report a problem or ask a technical question, contact Sybase Technical Support.
Wherever possible, the Troubleshooting and Error Messages Guide uses the style conventions of the Sybase product manuals. This section contains a brief summary of those conventions.
Commands and script names appear in bold type; for example:
To change the isql command terminator...
Object names appear in italics; for example:
Use the installmodel script to complete the installation of the model database.
The conventions for syntax statements in this manual are as follows:
Key | Definition |
command | Command names, command option names, stored procedure names, utility names, utility flags, and other keywords are in bold. |
variable | Variables, or words that stand for values that you fill in, are in italics and are normally surrounded with angle brackets <>. Do not include the brackets when typing in the value. |
{} | Curly braces indicate that you choose at least one of the enclosed options. Do not include braces in your option. |
[] | Brackets mean choosing one or more of the enclosed options is optional. Do not include brackets in your option. |
() | Parentheses are to be typed as part of the command. |
| | The vertical bar means you may select only one of the options shown. |
, | The comma means you may choose as many of the options shown as you like, separating your choices with commas to be typed as part of the command. |
<> | Words in angle brackets should be replaced with the corresponding name (such as a table or device). Do not include brackets in your entry. |
SQL syntax statements (displaying the syntax and options for a command) are printed as follows:
sp_dropdevice <device_name>
Examples showing the use of Transact-SQL commands are printed as follows:
1> select * from publishers 2> go
Examples of computer output are printed as follows:
pub_id pub_name city state ------ ------------------- ----------- ----- 0736 New Age Books Boston MA 0877 Binnet & Hardley Washington DC 1389 Algodata Infosystems Berkeley CA (3 rows affected)
For the most up-to-date information on troubleshooting and technical tips, refer to Sybase's electronic services:
The Customer Service and Support (CS&S) World Wide Web page. To access the CS&S page:
Go to the Sybase Support home page:
http://support.sybase.com
Under the Support Services heading, click on Technical Documents, Solved Cases, or other links.
To view or download support information, you need a Web browser such as Netscape NavigatorTM that supports SSL (Secure Sockets Layer). If you are behind a firewall, your proxy server must also support SSL. Your browser must be configured to allow cookies.
Alternatively, you may use Sybase's customized support site,
http://my.sybase.com
Help with your Sybase software is available in the form of documentation and Sybase Technical Support. If you have any questions about the procedures contained in this guide, ask the designated person at your site to contact Sybase Technical Support. You can find additional contact information at
http://support.sybase.comby clicking on Support Centers Directory.
For a checklist that helps you collect information when contacting Technical Support, refer to "Reporting Errors"in the Error Message Writeups chapter.
|
|