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.
**********************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page