473,322 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

"SQL0901N The SQL statement failed because of a non-severe error . " after degrade

last week , i get my db version from DB2/AIX64 8.1.10 down to DB2/
AIX64 8.1.5 .

After that , a application called "CalRate" has something wrong .

when it tries to open a cursor , it presents a error : SQL0901N The
SQL statement failed because of a non-severe error . Subsequent SQL
statements can be processed . (Reason "sqlriResolveOpFunc: invalid
opcode 0x1be at offset 14A0:0") SQLSTATE=58004

when i recompile this application , i receive a error : SQL0901N The
SQL statement failed because of a non-severe error . Subsequent SQL
statements can be processed . (Reason "section missing LRU entry!")
SQLSTATE=58004

i search for it .. and i get the information that it will be ok by
upgrading db version . but in my situation , i have to use 8.1.5 to
test this application .

Any help will be appreciated .

Mar 20 '07 #1
3 9399
rawu wrote:
last week , i get my db version from DB2/AIX64 8.1.10 down to DB2/
AIX64 8.1.5 .

After that , a application called "CalRate" has something wrong .

when it tries to open a cursor , it presents a error : SQL0901N The
SQL statement failed because of a non-severe error . Subsequent SQL
statements can be processed . (Reason "sqlriResolveOpFunc: invalid
opcode 0x1be at offset 14A0:0") SQLSTATE=58004

when i recompile this application , i receive a error : SQL0901N The
SQL statement failed because of a non-severe error . Subsequent SQL
statements can be processed . (Reason "section missing LRU entry!")
SQLSTATE=58004

i search for it .. and i get the information that it will be ok by
upgrading db version . but in my situation , i have to use 8.1.5 to
test this application .
Open PMR with support. If need be you may be able to get a patch on V8.1.5.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 23 '07 #2
On 3ÔÂ23ÈÕ, ÏÂÎç10ʱ13·Ö, Serge Rielau <srie...@ca.ibm.comwrote:
rawu wrote:
last week , i get my db version from DB2/AIX64 8.1.10 down to DB2/
AIX64 8.1.5 .
After that , a application called "CalRate" has something wrong .
when it tries to open a cursor , it presents a error : SQL0901N The
SQL statement failed because of a non-severe error . Subsequent SQL
statements can be processed . (Reason "sqlriResolveOpFunc: invalid
opcode 0x1be at offset 14A0:0") SQLSTATE=58004
when i recompile this application , i receive a error : SQL0901N The
SQL statement failed because of a non-severe error . Subsequent SQL
statements can be processed . (Reason "section missing LRU entry!")
SQLSTATE=58004
i search for it .. and i get the information that it will be ok by
upgrading db version . but in my situation , i have to use 8.1.5 to
test this application .

Open PMR with support. If need be you may be able to get a patch on V8.1.5.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
it turns out to be all right after i shutdown most of applications.
a IBM guy said maybe it's about the size of statment heap .
it's to large to assign .
anyway , it's ok now . thanks for your words.

Mar 27 '07 #3
rawu wrote:
it turns out to be all right after i shutdown most of applications.
a IBM guy said maybe it's about the size of statment heap .
it's to large to assign .
anyway , it's ok now . thanks for your words.
A -901 is never alright. It's DB2 version of an emergency break.
If it's not reported to support with the right context we can't fix it.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 27 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Mike Fisher | last post by:
I'm seeing an error when I try to run/debug a web service. Although it doesn't happen every time, it does occur more than half of the times I hit F5. It appears to be returned by the the JIT...
1
by: New MSSQL DBA | last post by:
hi all, have anyone else met with the following problem. we've got a SQL2000SP3a on a 2 active-active node clusters of W2K3, this cluster in using AD. I've found that whenever I use Enterprise...
1
by: Marco Gerlach | last post by:
Hello, on one of our customers servers we get following error on first ASPX-page: An error occurred while try to load the string resources (GetModuleHandle failed with error -2147023888) ...
1
by: Stan | last post by:
I get this error when I try to access any page on the website: An error occurred while try to load the string resources (GetModuleHandle failed with error 126). At the same time here is what I...
2
by: VB Programmer | last post by:
I created a ASP.NET app locally and it works great. Uploaded it to my server and I get this error when trying to view a page. Any ideas? Server Error in '/earlyalert3' Application....
2
by: Roger Wang | last post by:
HELP!!!! We have got a W2k server running IIS5 with .NET framework 1.1 and .NET framework SP1. All ASP.NET applications cannot run on this box. It all returned with the same error: ...
0
by: Thomas | last post by:
the webpages on our .net server ran fine for almost a year now. in the last few weeks however, more and more occurences of the error "the compiler failed with error code 128" have shown up, despite...
0
by: rawu | last post by:
last week , i get my db version from DB2/AIX64 8.1.10 down to DB2/AIX64 8.1.5 . After that , a application called "CalRate" has something wrong . when it tries to open a cursor , it presents...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.