Yaha,
I noticed the return code of 100 alright, but I would not have expected this
to cause a posting
to the diaglog when the diaglevel was set to 3.

Tom



-----Original Message-----
From: mukarram_yahya
[mailto:db2udbdba-ezmlmshield-x67647745.[Email address protected]
Sent: 25 May 2005 22:08
To: LazyDBA Discussion
Subject: Re: diag log error


This is just a warning that No rows were found by the sql/ command you ran
as a result of empty table.

bye,
Yahya Mukarram




|---------+--------------------------------------------------------->
| | "TOHare" |
| | <db2udbdba-ezmlmshield-x96285218.[Email Address Removed] | azyDBA.com> |
| | |
| | 05/25/2005 11:03 AM |
|---------+--------------------------------------------------------->

>---------------------------------------------------------------------------
-------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: diag log error
|

>---------------------------------------------------------------------------
-------------|




Hello All,
Environment
Solaris
UDB Version 8 fix pack 3

Can anyone shed light on the following message from the diag log.



2005-05-25-16.12.36.307128 Instance:db2inst1 Node:000
PID:21473(db2agent (DBxxxxx) 0) TID:1
Appid:*LOCAL.db2inst1.068BC5150543
relation data serv sqlrr_call_implicitClose Probe:20 Database:DBxxxxxx

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".

PID:21473 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 100 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRIEXT
sqlerrd : (1) 0x80040001 (2) 0x00000001 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 02000

Regards,
Tommy O'Hare



***************************************************************
The information contained in this e-mail and any files transmitted
with it is confidential and may be subject to legal professional
privilege. It is intended solely for the use of the addressee(s).
If you are not the intended recipient of this e-mail, please note
that any review, dissemination, disclosure, alteration, printing,
copying or transmission of this e-mail and/or any file transmitted
with it, is prohibited and may be unlawful.
If you have received this e-mail by mistake, please promptly
inform the sender by reply e-mail and delete the material.
Whilst this e-mail message has been swept for the presence of
computer viruses, eircom does not, except as required by law,
represent, warrant and/or guarantee that the integrity
of this communication has been maintained nor that
the communication is free of errors, viruses, interception or
interference.
***************************************************************



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. Thank you.



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page