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

Ruediger Kurtz

[DB2-L] AW: [DB2-L] [DB2] DB2 9 for z/OS - which Reason Codes go with SQLCODE -904 ?
Roger,

thank you, that site is exactly where the idea originally came from.

Best regards

Ruediger

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.
=============


-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Roger Miller
Gesendet: Donnerstag, 4. Dezember 2008 02:35
An: [login to unmask email]
Betreff: Re: [DB2-L] AW: [DB2-L] [DB2] DB2 9 for z/OS - which Reason Codes go with SQLCODE -904 ?

Start here: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp
Choose your version of DB2 in the search scope.
Put -904 in the search and click Go.

I used DB2 9 only and got 170 references. Most look like reason codes. Of
course, we can get new ones for this code.

Roger Miller, DB2 for z/OS


On Wed, 3 Dec 2008 15:40:51 +0100, Kurtz, Rüdiger <[login to unmask email]
COBURG.DE> wrote:

>Faz,
>
>enough is enough; I wouldn't say that "Messages & Codes" make up my
favourite read, in fact I'm more the whodunnit-type, and let's face it, thrilling
as M&C is, it won't keep me awake at night, in fact it might not even do the
trick during the day either.
>All I wanted to know was "is there - or isn't there - a quick reference where
one might find something like ... a -904 might come with the following reason
codes" and thank you for saying in a little bit more words than I deem
necessary that there isn't.
>
>
>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?s-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ߨoff, Stefan
Gronbach, Klaus-J?Heitmann, Dr. Christian Hofer, Dr. Wolfgang Weiler.
>=========
====
>
>
>-----Urspr?he Nachricht-----
>Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im
Auftrag von Fazio, Richard
>Gesendet: Mittwoch, 3. Dezember 2008 14:44
>An: [login to unmask email]
>Betreff: Re: [DB2-L] [DB2] DB2 9 for z/OS - which Reason Codes go with
SQLCODE -904 ?
>
>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?
>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?s-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ߨoff, Stefan
Gronbach, Klaus-J?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

Edward Long

Re: AW: [DB2-L] [DB2] DB2 9 for z/OS - which Reason Codes go with SQLCODE -904 ?
(in response to Ruediger Kurtz)
http://www-03.ibm.com/systems/z/os/zos/bkserv/lookat/
It works like a champ for almost all z/OS products.


Edward Long


--- On Wed, 12/3/08, Roger Miller <[login to unmask email]> wrote:

> From: Roger Miller <[login to unmask email]>
> Subject: Re: [DB2-L] AW: [DB2-L] [DB2] DB2 9 for z/OS - which Reason Codes go with SQLCODE -904 ?
> To: [login to unmask email]
> Date: Wednesday, December 3, 2008, 8:34 PM
> Start here:
> http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp
> Choose your version of DB2 in the search scope.
> Put -904 in the search and click Go.
>
> I used DB2 9 only and got 170 references. Most look like
> reason codes. Of
> course, we can get new ones for this code.
>
> Roger Miller, DB2 for z/OS
>
>
> On Wed, 3 Dec 2008 15:40:51 +0100, Kurtz, Rüdiger
> <[login to unmask email]
> COBURG.DE> wrote:
>
> >Faz,
> >
> >enough is enough; I wouldn't say that
> "Messages & Codes" make up my
> favourite read, in fact I'm more the whodunnit-type,
> and let's face it, thrilling
> as M&C is, it won't keep me awake at night, in fact
> it might not even do the
> trick during the day either.
> >All I wanted to know was "is there - or isn't
> there - a quick reference where
> one might find something like ... a -904 might come with
> the following reason
> codes" and thank you for saying in a little bit more
> words than I deem
> necessary that there isn't.
> >
> >
> >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?s-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ߨoff, Stefan
> Gronbach, Klaus-J?Heitmann, Dr. Christian Hofer, Dr.
> Wolfgang Weiler.
> >=========
> ====
> >
> >
> >-----Urspr?he Nachricht-----
> >Von: DB2 Data Base Discussion List
> [mailto:[login to unmask email] Im
> Auftrag von Fazio, Richard
> >Gesendet: Mittwoch, 3. Dezember 2008 14:44
> >An: [login to unmask email]
> >Betreff: Re: [DB2-L] [DB2] DB2 9 for z/OS - which
> Reason Codes go with
> SQLCODE -904 ?
> >
> >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?
> >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?s-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ߨoff, Stefan
> Gronbach, Klaus-J?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