If this helps here are some links to articles that can help train
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
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
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
correctly, it goes to a group that reviews the screen shot, looks
code and then describes the steps needed to resolve it. If it only
one time and the information shared, that would not be to onerous.
same code, different user, review and analyze and return.
To make matters more interesting this app was written on MF
30 years ago. Works great, but the level of knowledge of the app
been - shall we say retained - over the years.
I think we may start to instruct the application teams how to use
that will help. Then provide them with a USER DB they can put notes
Thanks, this was a long shot in the dark. - Oh how I miss the 80's
programmers were real programmers.
> -----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
> No assesments, merely noting that these exist:
> Quickref - a third party product that provides an on-line
> facility from ISPF. Both IBM and ISV products
> LookAt - a web interface to IBM messages and codes in the
> James Campbell
> On 17 Dec 2018 at 14:57, Lizette Koehler wrote:
> > As you know, application programmers will have an SQLCA
> > that
> contains things
> > like sql code and db2 code.
> > I was wondering if there was a way (an API perhaps) to
> > the
> 00C900BA to
> > something human readable?
> > We have DB2/CICS applications, Stored Procedures, etc
> > end
> user gets
> > these cryptic codes, do not bother to google it and just
> cut/paste of the
> > error panel.
> > I am hoping there might be some easy way replace 00C900BA
> > human
> > text.
> > Any thoughts?
> > The only thing I can come up with is loading a table of
> > typical
> message with a
> > human text that can be queried during error processing
> > provide the
> end user
> > with a better understanding of what occurred.
> > Currently we get lots of incident tickets that basically
> > (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
> > half-truth inaccurately
> -----End Original Message-----
-----End Original Message-----