Message Reference

Table of Contents

About This Guide

Who Should Use This Guide
How This Guide Is Structured
Organization
Conventions

Introduction to Messages

Information Available Online
Other DB2 Messages
Other Message Sources

Capture and Apply (ASN) Messages

CCA Messages

CLI Messages

DBA Messages

DBI Messages

DB2 Messages

DWC Messages

FLG Messages

Information Catalog Manager Reason Codes
Information Catalog Manager Messages FLG0001 -- FLG0083
Information Catalog Manager Messages FLG0200 -- FLG0273
Information Catalog Manager Messages FLG0301 -- FLG0800

GSE Messages

SAT Messages

SPM Messages

SQJ Messages

SQL Messages

SQL0000 - SQL0099
SQL0100 - SQL0199
SQL0200 - SQL0299
SQL0300 - SQL0399
SQL0400 - SQL0499
SQL0500 - SQL0599
SQL0600 - SQL0699
SQL0700 - SQL0799
SQL0800 - SQL0899
SQL0900 - SQL0999
SQL1000 - SQL1099
SQL1100 - SQL1199
SQL1200 - SQL1299
SQL1300 - SQL1399
SQL1400 - SQL1499
SQL1500 - SQL1599
SQL1600 - SQL1699
SQL1700 - SQL1799
SQL1800 - SQL1899
SQL1900 - SQL1999
SQL2000 - SQL2099
SQL2100 - SQL2199
SQL2200 - SQL2299
SQL2300 - SQL2399
SQL2400 - SQL2499
SQL2500 - SQL2599
SQL2600 - SQL2699
SQL2700 - SQL2799
SQL2800 - SQL2899
SQL3000 - SQL3099
SQL3100 - SQL3199
SQL3200 - SQL3299
SQL3300 - SQL3399
SQL3400 - SQL3499
SQL3500 - SQL3599
SQL3600 - SQL3699
SQL3700 - SQL3799
SQL3800 - SQL3899
SQL3900 - SQL3999
SQL4000 - SQL4099
SQL4100 - SQL4199
SQL4300 - SQL4399
SQL4400 - SQL4499
SQL4900 - SQL4999
SQL5000 - SQL5099
SQL5100 - SQL5199
SQL6000 - SQL6099
SQL6100 - SQL6199
SQL6500 - SQL6599
SQL7000 - SQL7099
SQL8000 - SQL8099
SQL8100 - SQL8199
SQL9300 - SQL9399
SQL10000 - SQL10099
SQL20000 - SQL20099
SQL20100 - SQL20199
SQL20200 - SQL20299
SQL29000 - SQL29100
SQL30000 - SQL30099
SQL30100 - SQL30199

SQLSTATE Messages

Class Code 00 Unqualified Successful Completion
Class Code 01 Warning
Class Code 02 No Data
Class Code 07 Dynamic SQL Error
Class Code 08 Connection Exception
Class Code 09 Triggered Action Exception
Class Code 0A Feature Not Supported
Class Code 0D Invalid Target Type Specification
Class Code 0F Invalid Token
Class Code 0K Invalid RESIGNAL statement
Class Code 20 Case Not Found for Case Statement
Class Code 21 Cardinality Violation
Class Code 22 Data Exception
Class Code 23 Constraint Violation
Class Code 24 Invalid Cursor State
Class Code 25 Invalid Transaction State
Class Code 26 Invalid SQL Statement Identifier
Class Code 28 Invalid Authorization Specification
Class Code 2D Invalid Transaction Termination
Class Code 2E Invalid Connection Name
Class Code 34 Invalid Cursor Name
Class Code 38 External Function Exception
Class Code 39 External Function Call Exception
Class Code 3B Invalid SAVEPOINT
Class Code 40 Transaction Rollback
Class Code 42 Syntax Error or Access Rule Violation
Class Code 44 WITH CHECK OPTION Violation
Class Code 46 Java DDL
Class Code 51 Invalid Application State
Class Code 54 SQL or Product Limit Exceeded
Class Code 55 Object Not in Prerequisite State
Class Code 56 Miscellaneous SQL or Product Error
Class Code 57 Resource Not Available or Operator Intervention
Class Code 58 System Error

Appendix A. Communications Errors

TCP/IP
APPC
NETBIOS
IPX/SPX

Appendix B. SPM Protocol Violation Records

Resync Protocol Violation Record
Syncpoint Protocol Violation Record
XLN Protocol Violation Record

Appendix C. Using the DB2 Library

DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online

Appendix D. Notices

Trademarks

Appendix E. Contacting IBM

Product Information

Index