Any API to translate DB2 Code to Human Message

Lizette Koehler

Any API to translate DB2 Code to Human Message
As you know, application programmers will have an SQLCA area that contains
things like sql code and db2 code.



I was wondering if there was a way (an API perhaps) to translate the 00C900BA to
something human readable?



We have DB2/CICS applications, Stored Procedures, etc where the end user gets
these cryptic codes, do not bother to google it and just send a cut/paste of the
error panel.



I am hoping there might be some easy way replace 00C900BA to a human message
text.



Any thoughts?



The only thing I can come up with is loading a table of the typical message with
a human text that can be queried during error processing and provide the end
user with a better understanding of what occurred.



Currently we get lots of incident tickets that basically say - (from end user)
can you look at this and tell me what went wrong?







Thanks





Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately



Jørn Thyssen

RE: Any API to translate DB2 Code to Human Message
(in response to Lizette Koehler)

Hi Lizette,

Can you provide an example of what gets sent to you? 

Hopefully it is the complete SQLCA structure nicely formatted.

However, full explanations of reason codes, types, etc are documented in the manual only. I am not aware of any API that have harvested the manual and can return the 100+ line explanation for, e.g., 00C900BA. 

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2018 IBM Champion.

Views are personal. 

James Campbell

Any API to translate DB2 Code to Human Message
(in response to Lizette Koehler)
No assesments, merely noting that these exist:

Quickref - a third party product that provides an on-line lookup facility from ISPF. Both IBM
and ISV products
https://www.quickref.com/newQuickRef/helpdocs/help?thisDoc=r7_overview

LookAt - a web interface to IBM messages and codes in the Knowledge Centers.
https://www-01.ibm.com/servers/resourcelink/svc00100.nsf/pages/lookatkc?OpenDocument
https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v2r3.hkcz100/k
czos100.htm


James Campbell

On 17 Dec 2018 at 14:57, Lizette Koehler wrote:

>
> As you know, application programmers will have an SQLCA area that contains things
> like sql code and db2 code.
>  
> I was wondering if there was a way (an API perhaps) to translate the 00C900BA to
> something human readable?
>
> We have DB2/CICS applications, Stored Procedures, etc  where the end user gets
> these cryptic codes, do not bother to google it and just send a cut/paste of the
> error panel.
>  
> I am hoping there might be some easy way replace 00C900BA to a human message
> text.
>  
> Any thoughts?
>  
> The only thing I can come up with is loading a table of the typical message with a
> human text that can be queried during error processing and provide the end user
> with a better understanding of what occurred. 
>  
> Currently we get lots of incident tickets that basically say - (from end user) can
> you look at this and tell me what went wrong?
>  
>  
>  
> Thanks
>  
>  
> Lizette Koehler
> statistics: A precise and logical method for stating a half-truth inaccurately
>  
>

Lizette Koehler

Any API to translate DB2 Code to Human Message
(in response to James Campbell)
If only it were that simple.

The code just displays the SQLCA and nothing else.

So rather than make the effort to understand the issue and assign it correctly,
it goes to a group that reviews the screen shot, looks up the code and then
describes the steps needed to resolve it. If it only happened one time and the
information shared, that would not be to onerous. However, same code, different
user, review and analyze and return.

To make matters more interesting this app was written on MF CICS/DB2 about 30
years ago. Works great, but the level of knowledge of the app has not been -
shall we say retained - over the years.

I think we may start to instruct the application teams how to use QW. Maybe
that will help. Then provide them with a USER DB they can put notes in for
various codes.

Thanks, this was a long shot in the dark. - Oh how I miss the 80's when
programmers were real programmers.


Lizette


> -----Original Message-----
> From: James Campbell <[login to unmask email]>
> Sent: Monday, December 17, 2018 6:29 PM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Any API to translate DB2 Code to Human Message
>
> No assesments, merely noting that these exist:
>
> Quickref - a third party product that provides an on-line lookup facility
> from ISPF. Both IBM and ISV products
> https://www.quickref.com/newQuickRef/helpdocs/help?thisDoc=r7_overview
>
> LookAt - a web interface to IBM messages and codes in the Knowledge Centers.
> https://www-
> 01.ibm.com/servers/resourcelink/svc00100.nsf/pages/lookatkc?OpenDocument
> https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v2r3.hkc
> z100/k
> czos100.htm
>
>
> James Campbell
>
> On 17 Dec 2018 at 14:57, Lizette Koehler wrote:
>
> >
> > As you know, application programmers will have an SQLCA area that
> contains things
> > like sql code and db2 code.
> >
> > I was wondering if there was a way (an API perhaps) to translate the
> 00C900BA to
> > something human readable?
> >
> > We have DB2/CICS applications, Stored Procedures, etc  where the end
> user gets
> > these cryptic codes, do not bother to google it and just send a
> cut/paste of the
> > error panel.
> >
> > I am hoping there might be some easy way replace 00C900BA to a human
> message
> > text.
> >
> > Any thoughts?
> >
> > The only thing I can come up with is loading a table of the typical
> message with a
> > human text that can be queried during error processing and provide the
> end user
> > with a better understanding of what occurred.
> >
> > Currently we get lots of incident tickets that basically say - (from
> end user) can
> > you look at this and tell me what went wrong?
> >
> >
> >
> > Thanks
> >
> >
> > Lizette Koehler
> > statistics: A precise and logical method for stating a half-truth
> > inaccurately
> >
> >
>
> -----End Original Message-----

Tony Saul

Any API to translate DB2 Code to Human Message
(in response to Lizette Koehler)
QuickRef used to be really good (it may still be, but I haven't used it for years) and I thought it was updateable with "local knowledge".
LookAt is a replacement for the mainframe Bookshelves (that I never liked, but others did). I thought the IBM presentations made it sound as flexible as QuickRef, but using the latest information from the web.
Of course DSNTIAR / DSNTIAC makes SQLCA a little more readable, maybe this needs needs an API call or the message formatted to present a URL. On the 3270 Emulator I use (QWS3270) it will open any URL's when you click on them, so that would be reasonably quick (maybe a little cumbersome).  
Regards, Tony

On Tuesday, 18 December 2018, 1:52:12 pm ACDT, Lizette Koehler <[login to unmask email]> wrote:

If only it were that simple.

The code just displays the SQLCA and nothing else.

So rather than make the effort to understand the issue and assign it correctly,
it goes to a group that reviews the screen shot, looks up the code and then
describes the steps needed to resolve it.  If it only happened one time and the
information shared, that would not be to onerous.  However, same code, different
user, review and analyze and return.

To make matters more interesting this app was written on MF CICS/DB2 about 30
years ago. Works great, but the level of knowledge of the app has not been -
shall we say  retained - over the years.

I think we may start to instruct the application teams how to use QW.  Maybe
that will help.  Then provide them with a USER DB they  can put notes in for
various codes. 

Thanks, this was a long shot in the dark.  - Oh how I miss the 80's when
programmers were real programmers.


Lizette


> -----Original Message-----
> From: James Campbell <[login to unmask email]>
> Sent: Monday, December 17, 2018 6:29 PM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Any API to translate DB2 Code to Human Message
>
> No assesments, merely noting that these exist:
>
> Quickref - a third party product that provides an on-line lookup facility
> from ISPF.  Both IBM and ISV products
> https://www.quickref.com/newQuickRef/helpdocs/help?thisDoc=r7_overview
>
> LookAt - a web interface to IBM messages and codes in the Knowledge Centers.
> https://www-
> 01.ibm.com/servers/resourcelink/svc00100.nsf/pages/lookatkc?OpenDocument
> https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v2r3.hkc
> z100/k
> czos100.htm
>
>
> James Campbell
>
> On 17 Dec 2018 at 14:57, Lizette Koehler wrote:
>
> >
> >    As you know, application programmers will have an SQLCA area that
> contains things
> >    like sql code and db2 code.
> >
> >    I was wondering if there was a way (an API perhaps) to translate the
> 00C900BA to
> >    something human readable?
> >
> >    We have DB2/CICS applications, Stored Procedures, etc  where the end
> user gets
> >    these cryptic codes, do not bother to google it and just send a
> cut/paste of the
> >    error panel.
> >
> >    I am hoping there might be some easy way replace 00C900BA to a human
> message
> >    text.
> >
> >    Any thoughts?
> >
> >    The only thing I can come up with is loading a table of the typical
> message with a
> >    human text that can be queried during error processing and provide the
> end user
> >    with a better understanding of what occurred.
> >
> >    Currently we get lots of incident tickets that basically say - (from
> end user) can
> >    you look at this and tell me what went wrong?
> >
> >
> >
> >    Thanks
> >
> >
> >    Lizette Koehler
> >    statistics: A precise and logical method for stating a half-truth
> > inaccurately
> >
> >
>
> -----End Original Message-----
   
-----End Original Message-----   

Daniel Luksetich

Any API to translate DB2 Code to Human Message
(in response to Lizette Koehler)
If this helps here are some links to articles that can help train your
developers.

https://www.idug.org/p/bl/et/blogaid=343

https://www.idug.org/p/bl/et/blogaid=336

Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and
Windows

-----Original Message-----
From: Lizette Koehler <[login to unmask email]>
Sent: Monday, December 17, 2018 9:22 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Any API to translate DB2 Code to Human Message

If only it were that simple.

The code just displays the SQLCA and nothing else.

So rather than make the effort to understand the issue and assign it
correctly, it goes to a group that reviews the screen shot, looks up the
code and then describes the steps needed to resolve it. If it only happened
one time and the information shared, that would not be to onerous. However,
same code, different user, review and analyze and return.

To make matters more interesting this app was written on MF CICS/DB2 about
30 years ago. Works great, but the level of knowledge of the app has not
been - shall we say retained - over the years.

I think we may start to instruct the application teams how to use QW. Maybe
that will help. Then provide them with a USER DB they can put notes in for
various codes.

Thanks, this was a long shot in the dark. - Oh how I miss the 80's when
programmers were real programmers.


Lizette


> -----Original Message-----
> From: James Campbell <[login to unmask email]>
> Sent: Monday, December 17, 2018 6:29 PM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Any API to translate DB2 Code to Human Message
>
> No assesments, merely noting that these exist:
>
> Quickref - a third party product that provides an on-line lookup
> facility from ISPF. Both IBM and ISV products
> https://www.quickref.com/newQuickRef/helpdocs/help?thisDoc=r7_overview
>
> LookAt - a web interface to IBM messages and codes in the Knowledge
Centers.
> https://www-
> 01.ibm.com/servers/resourcelink/svc00100.nsf/pages/lookatkc?OpenDocume
> nt
> https://www.ibm.com/support/knowledgecenter/SSLTBW_2.3.0/com.ibm.zos.v
> 2r3.hkc
> z100/k
> czos100.htm
>
>
> James Campbell
>
> On 17 Dec 2018 at 14:57, Lizette Koehler wrote:
>
> >
> > As you know, application programmers will have an SQLCA area
> > that
> contains things
> > like sql code and db2 code.
> >
> > I was wondering if there was a way (an API perhaps) to translate
> > the
> 00C900BA to
> > something human readable?
> >
> > We have DB2/CICS applications, Stored Procedures, etc  where the
> > end
> user gets
> > these cryptic codes, do not bother to google it and just send a
> cut/paste of the
> > error panel.
> >
> > I am hoping there might be some easy way replace 00C900BA to a
> > human
> message
> > text.
> >
> > Any thoughts?
> >
> > The only thing I can come up with is loading a table of the
> > typical
> message with a
> > human text that can be queried during error processing and
> > provide the
> end user
> > with a better understanding of what occurred.
> >
> > Currently we get lots of incident tickets that basically say -
> > (from
> end user) can
> > you look at this and tell me what went wrong?
> >
> >
> >
> > Thanks
> >
> >
> > Lizette Koehler
> > statistics: A precise and logical method for stating a
> > half-truth inaccurately
> >
> >
>
> -----End Original Message-----

-----End Original Message-----