By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,977 Members | 1,369 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,977 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"JPARKER" <je***********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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?


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

Nov 18 '05 #2

P: n/a

"Matt Emmerton" <me******@nospam.yahoo.com> wrote in message
news:_d********************@rogers.com...

"JPARKER" <je***********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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?
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


[ 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
Nov 18 '05 #3

P: n/a
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

Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.