[DB2] DB2 9 for z/OS - which Reason Codes go with SQLCODE -904 ?

Ruediger Kurtz

[DB2] DB2 9 for z/OS - which Reason Codes go with SQLCODE -904 ?
Hi everyone,

I was wondering if there is a decent paper where one can find out which reason codes go with sqlcode -904 ?

TIA

Ruediger Kurtz
Abteilung Informatik Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon 09561 96-44147
Telefax 09561 96-44104
E-Mail [login to unmask email]
Internet www.HUK.de
=============
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Werner Strohmayr.
Vorstand: Rolf-Peter Hoenen (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Dr. Christian Hofer, Dr. Wolfgang Weiler.
=============

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Richard Fazio

Re: [DB2] DB2 9 for z/OS - which Reason Codes go with SQLCODE -904 ?
(in response to Ruediger Kurtz)
Yes, it's called IBM DB2 V8 "Codes" reference.

It's a thriller from cover to cover. I don't want to spoil the ending, but you won't believe what can happen to your network packets!!!

Get a 55 Gallon drum of cocoa a cord of wood, curl up in your favorite chair with a roaring fire and you have some good times ahead.

Sorry, I could not resist. There are thousands of codes and to create a quick ref of the 5-10 common codes (00C90101, 00C90080, etc) would lead to out-dated doc that probably will be poorly translated. If you don't understand what a reason code means, you really need to read the manual and understand the implications of each message. Also, every once in a while go back and RTFM just to see if anything has changes (yup, doc gets even better..so, you need another drum of cocoa for the V9 Codes :)

This is truly a case where RTFM should be the rule. I've been doing this for a few years and the "A" word really applies here. "Always" Look to the manual to discover the meaning of a return code. The standard DBA, "IT Depends", does not apply.

faz

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Kurtz, Rüdiger
Sent: Wednesday, December 03, 2008 5:25 AM
To: [login to unmask email]
Subject: [DB2-L] [DB2] DB2 9 for z/OS - which Reason Codes go with SQLCODE -904 ?

Hi everyone,

I was wondering if there is a decent paper where one can find out which reason codes go with sqlcode -904 ?

TIA

Ruediger Kurtz
Abteilung Informatik Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon 09561 96-44147
Telefax 09561 96-44104
E-Mail [login to unmask email]
Internet www.HUK.de
=============
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Werner Strohmayr.
Vorstand: Rolf-Peter Hoenen (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Dr. Christian Hofer, Dr. Wolfgang Weiler.
=============

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms