It's all about the answers!

Ask a question

SQLCODE=-805 in RQM ETL job


Morten Madsen (3053149) | asked Mar 10 '13, 12:46 p.m.
retagged Mar 15 '13, 12:05 p.m. by Laura W. Hinson (16126)
Install specs for the following message:
CLM 4.0 (JTS, CCM, RQM)
OpenSUSE Linux 64-bit
DB2 ESE 9.7.0.0
WAS 8.0.0.2


Hi, I get the exact same error message in "qm-etl.log", as reported in this old work item:

https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=51570

The error text is as follows:

DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH1030X5359 534C564C3031, DRIVER=3.57.82

The error happens in DB2DatawarehouseDbProvider.updateStatistics().

DB2 also creates around 1 GB log files for the RQM DB pr day, and I have to prune the log files every week to not run out of HD space.

In "qm.log" I get the following: (I wrote this text manually, becuase I'm unable to copy+paste from my remote VM server for some reason):

WARN LeakWrapperLogger - OpenStatement #xxxxxxxxxxx

(where xxxxxxxxx is some number). I get A LOT of these.

I've just discovered that we run on WAS 8.0.0.2, which is not supported, and I plan to upgrade it soon. I have no idea if this is related though, but it's clear that some kind of memory leak is at work, and the connection handles to DB2 are not closed for some reason.

Can anybody comment / help me?

Thanks a lot
/Morten.



Comments
Kevin Ramer commented Mar 11 '13, 12:41 p.m.

It appears you have base db2 9.7.  It's at at least fix pack 7

db2level command gives:
Informational tokens are "DB2 v9.7.0.7", "s121002", "IP23367", and Fix Pack
"7".
for db2 server we use.    Though no one recommended updating DB2 in the referenced work item, it's not a bad idea to do so if you have the cycles.





Morten Madsen commented Mar 19 '13, 6:24 a.m.

Hi sorry. Missed your comment. Our DB2 for linux 64-bit is v9.7.0.0 (fixpack level 0). In system requirements for RTC v4.0.0.0 I can't see this as a problem.

Would you recommend patching the DB2 installation to at least FP 7?

One answer



permanent link
Morten Madsen (3053149) | answered Apr 02 '13, 4:31 a.m.
I upgraded the WAS 8.0.0.2 --> 8.0.0.3 and it seems to have fixed all problems!!

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.