SQLCODE information..

Kartik Subramanian

SQLCODE information..
I was wondering if there is the description for corresponding SQLCODEs and
SQLSTATEs somewhere in the system say in some file ot table where we could pull
it up from instead of looking up at Manuals and Book Manager.



Jim Knisley

Re: SQLCODE information..
(in response to Kartik Subramanian)
Kartik,
Not that I am aware of. We use a product called MVS Quickref. It contains
codes and messages for a variety of IBM and non-IBM products, including OS/390
and DB2. Under TSO, you just put your cursor on the message and press a
predefined key (we use Shift+F1) and it will bring up the complete description
of the message, plus any solutions to the problem as they are described in the
IBM manuals. It's really useful for those 2AM calls at home so that I don't
have to have a set of messages manuals at home. You could probably pull the
codes off of the DB2 library CD and load them to a file or table.

Jim





Kartik Subramanian <[login to unmask email]> on 12/14/99 12:24:41
PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Jim Knisley/TFG/HII)
Subject: SQLCODE information..



I was wondering if there is the description for corresponding SQLCODEs and
SQLSTATEs somewhere in the system say in some file ot table where we could pull
it up from instead of looking up at Manuals and Book Manager.








Roger Miller

Re: SQLCODE information..
(in response to Jim Knisley)
I want to have the latest information and need multiple releases most of
the time,
so I download the PDF files from the DB2 web. That way, I have the updates
in the diagnosis information.

I just noted the latest white paper on DB2 performance for the Enterprise
Storage Server (a.k.a. Shark).

From the DB2 for OS/390 home page,
www.ibm.com/software/db2os390
Click on Library, then on
DB2 for OS/390 Performance on IBM Enterprise Storage Server

for a 25 page paper discussing our benchmarking on the new disk unit.
Here are some highlights, extracted from an earlier flash.

New measurements from IBM's Santa Teresa Laboratory now confirm that the
Enterprise Storage Server is a truly outstanding choice for database
applications using DB2 UDB for OS/390. In particular, these results show
that S/390 and the Enterprise Storage Server are the ideal combination for
data warehouse and Business Intelligence applications.

The Enterprise Storage Server supports a Query Single Stream rate of
approximately 11.5 MB/sec, about double the previous best measurement.
This data rate is significant for improving the elapsed time of
applications that must scan large amounts of data, for example Business
Intelligence queries.

DB2 parallelism is multiplied by the device speeds and Parallel Access
Volumes (PAV). An ESS has already been measured at 155 MB/sec sequential
throughput for DB2. To put this into perspective, it took twenty-seven
3990 controllers to achieve a total data rate of 270 MB/sec running a
massive Teraplex query in 1997. This could be achieved today with only two
ESSs!

PAV also enables multiple partitions to be stored on the same volume with
negligible performance degradation. The ESS showed almost no degradation
when a parallel query scanned one, two or three partitions simultaneously
on the same volume. (RAMAC 3 degraded up to 300% in this test). Because
the ESS is so much less sensitive to data placement, management of data
sets for DB2 is very much easier.

Elapsed times for DB2 utilities (such as Load and Copy) show a range of
improvements from 40%-50% on the ESS compared to the RVA X82.



William Gannon

Re: SQLCODE information..
(in response to Roger Miller)
Or -

You could use the following REXX code (I 'acquired' - original author noted) in the TSO environment: Simply copy the following exec to the appropriate concatenation an invoke it with - TSO
SQLERR ###

--start cut here--
/* REXX Show a description of an SQLCODE */
/* The message returned will not be complete as I have just set the */
/* SQLCA to initial values (apart from the sqlcode). */
/* Paul Fletcher @ [login to unmask email] */
ARG SQLCODE
SQLC = D2X(SQLCODE,8)
SQLC = X2C(SQLC)
SQLCA = 'SQLCA 'X2C(00000088)SQLC||X2C(0000)||COPIES(' ',78)
SQLCA = SQLCA||COPIES(X2C(00),24)COPIES(' ',16)
TIAR_MSG = X2C(0190)COPIES(' ',400)
TEXT_LEN = X2C(00000050)
ADDRESS ATTCHPGM 'DSNTIAR SQLCA TIAR_MSG TEXT_LEN'
SAY SUBSTR(TIAR_MSG,4,400)
--end cut here--

HTH
Bill G.

Jim Knisley wrote:

> Kartik,
> Not that I am aware of. We use a product called MVS Quickref. It contains
> codes and messages for a variety of IBM and non-IBM products, including OS/390
> and DB2. Under TSO, you just put your cursor on the message and press a
> predefined key (we use Shift+F1) and it will bring up the complete description
> of the message, plus any solutions to the problem as they are described in the
> IBM manuals. It's really useful for those 2AM calls at home so that I don't
> have to have a set of messages manuals at home. You could probably pull the
> codes off of the DB2 library CD and load them to a file or table.
>
> Jim
>
> Kartik Subramanian <[login to unmask email]> on 12/14/99 12:24:41
> PM
>
> Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
> To: [login to unmask email]
> cc: (bcc: Jim Knisley/TFG/HII)
> Subject: SQLCODE information..
>
> I was wondering if there is the description for corresponding SQLCODEs and
> SQLSTATEs somewhere in the system say in some file ot table where we could pull
> it up from instead of looking up at Manuals and Book Manager.
>
>
>
>
>
>
>
>