DB2 SQL error codes

When you get DB2 error codes, it's easy enough to look it up in the Messages and Codes manual. But knowing what is wrong doesn't always help you to solve the problem. Here, DB2 SQL guru Craig Mullins helps solve some common SQL errors. If you can't find a solution to your problem here, ask us.

TABLE OF CONTENTS

Requires Free Membership to View

When you register, you'll begin receiving targeted emails from my team of award-winning writers. Our goal is to keep you informed on the hottest data and information management trends today.

Hannah Smalltree, Editorial Director

By submitting your registration information to SearchDataManagement.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchDataManagement.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Resources for working with errors
-104
-118
-204
-305
-408
-532
-545
-632
-803
-904
-905
-1070
Unspecified errors

Also, test your knowledge of DB2 9 by answering sample questions from the DB2 9 Fundamentals certification exam.

General error information

The Messages and Codes manual for OS/390 and z/OS can be downloaded here. Or, according to IBM's Web site, customers of DB2 UDB can use the online feature of the product by following these steps:

From a Windows environment go to: Start --> Programs --> IBM DB2 --> Information
From the expanded Information screen, select DB2 Information. This will open either your Web browser or the Information Center.
From the Information Center, select the Books tab. Expand Reference, then select Message Reference.

-104