Hi,

I did open a PMR, I couldn't find any information. I'll send you the
findings of db2 support people.

Thank you all,

Richard





"Grimm Matt " <db2udbdba-ezmlmshield-x27943490.[Email address protected]
06/25/2007 05:16 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: ADM0001C A severe error has occurred.






Ricardo,
A -901 is usually very nasty to diagnose. Have you trapped the statement
that caused the error? I am guessing it was an insert with some sort of
invalid data? You should open a PMR with support and send them the
entire context of the problem.

-----Original Message-----
From: Ricardo Ortega
[mailto:db2udbdba-ezmlmshield-x88877887.[Email address protected]
Sent: Monday, June 25, 2007 12:22 PM
To: LazyDBA Discussion
Subject: ADM0001C A severe error has occurred.

Hi everybody,

Today I found this entry in instance.nfy (production database):

ADM0001C A severe error has occurred. Examine the administration
notification log and contact IBM Support if necessary.

So, as instructed in the error itself I went to the db2diag.log to see
what I could find there and I found this:

DIA8118 Failure processing SQL statement.
ZRC=0x8012007E

PID:1564684 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 45
sqlerrmc: sqlridummy: invalid opcode 6 at offset 21a8:0
sqlerrp : sqlridum
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

followed by dump information.

I've been trying to find information about this error and I have been
unable to. Does anyone knows what this means or could guide on how to
find
out?

Thanks in advance,

Ricardo


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
NOTICE:
This e-mail, including attachments, contains information that may be
confidential, protected by the attorney/client or other privileges, or
exempt from disclosure under applicable law. Further, this e-mail may
contain information that is proprietary and/or constitutes a trade secret.
This e-mail, including attachments, constitutes non-public information
intended to be conveyed only to the designated recipient(s). If you are
not an intended recipient of this communication, please be advised that
any disclosure, dissemination, distribution, copying, or other use of this
communication or any attached document is strictly prohibited. If you
have received this communication in error, please notify the sender
immediately by reply e-mail and promptly destroy all electronic and
printed copies of this communication and any attached documents.

**********************************************************************



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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