SQL0902C A system error (reason code = 9") ocurred

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JPARKER - 18 Nov 2005 19:37 GMT

Our DB2 8.2 FixPak9 database running on Win2K crashed with after
reporting this message

SQL0902C A system error (reason code = 9") ocurred

I have searched the DB2 documentation as well as the Web and can't find
a list of what the reason codes mean. Does anyone know what reason
code 9 is?

Thanks

Reply to this Message

Matt Emmerton - 18 Nov 2005 23:26 GMT

> Our DB2 8.2 FixPak9 database running on Win2K crashed with after
> reporting this message
[quoted text clipped - 4 lines]
> a list of what the reason codes mean. Does anyone know what reason
> code 9 is?

I believe the reason code in this case is the "system error code", reported
via errno on UNIX or GetLastError() on Windows.

Error 9 on Windows is

Reply to this Message

Matt Emmerton - 18 Nov 2005 23:28 GMT

> > Our DB2 8.2 FixPak9 database running on Win2K crashed with after
> > reporting this message
[quoted text clipped - 9 lines]
>
> Error 9 on Windows is

[ continuing ... ]

Error 9 on Windows is ERROR_INVALID_BLOCK (The storage control block address
in invalid), which is referring to a disk or storage device.

--
Matt Emmerton

Reply to this Message

JPARKER - 19 Nov 2005 01:10 GMT

Thanks, It looks like we had a corrupted index which we have dropped
and recreated. So far the problem has not returned. Thanks for you
help.

Jeff

Reply to this Message