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

JPARKER

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

Subscribe Post Reply

8662

Matt Emmerton

"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

Matt Emmerton

"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

JPARKER

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

by: sql-db2-dba | last post by:

CLI connection failed. SQL0902C. A system error (reason code="6029321") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005. Has anyone encountered the above error? We are...

DB2 Database

SQL0902C with Kernel 2.4.23

by: Dirk Wiebel | last post by:

Hello @all, when upgrading our Intel based server machine from linux kernel 2.4.19 to 2.4.23 db2 refused to connect to one of the databases: db2inst1@xxx:~> db2 connect to b6 SQL0902C A...

DB2 Database

sql0902c reason code 122

by: Stefano Tesini | last post by:

Hi all, when i drop a table, i take his error : SQL0902C System error (REASON CODE = "122"). Why ? Ver UDB Server nt 7.1.0 Ver UDB Cli 7.1.0 Win 98 or XP the error is the same.

DB2 Database

System.Data.SqlClient "Timeout expired" causing ASP.net web application to automatically restart.

by: Chris Langston | last post by:

I have a Web Server running IIS 5 or 6 on Windows 2K and Windows 2003 Server that is experiencing strange shutdown problems. We are using ASP.NET v1.1 and our application is written in VB.NET ...

ASP.NET

Why am I getting ForeignKeyConstraint requires child key value error?

by: dbuchanan | last post by:

Hello, Here is the error message; ---------------------------- Exception Message: ForeignKeyConstraint Lkp_tbl040Cmpt_lkp302SensorType requires the child key values (5) to exist in the...

Visual Basic .NET

Strange Behavior in WebRequest.Create("...") and System.Uri("...")

by: jesper.hvid | last post by:

Hi. I've noticed, after moving some of our code to 2.0, that System.Net.WebRequest.Create(System.String) and System.Uri(System.String) no longer behave as they did in 1.1 framework. Example:...

C# / C Sharp

SQL0902C - SQLSTATE=58005 - Reason Code = "14"

by: jason.awlt | last post by:

Greetings, I recently being bugged by the following error on my DB2. SQL0902C SQLSTATE = 58005 Reason Code = 14 This error comes out everytime i tried to insert some record to a table...

DB2 Database

SQL0902C : Subsequent SQL statements cannot be processed

by: Bruno Costacurta | last post by:

Hello, under V9.1-Express I have the following when trying to connect to a newly created database: "SQL0902C A system error (reason code = "") occurred. Subsequent SQL statements cannot be...

DB2 Database

SQL0902C with reason code="32"

by: paul.sharivker | last post by:

I am getting the following error executing SP. Error happens sometimes. Does any body have any suggestions how to fix it? SQL0902C A system error (reason code = "32") occurred. Subsequent SQL...

DB2 Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

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

Similar topics