It's all about the answers!

Ask a question

SQLCODE=-805 in RQM ETL job

Morten Madsen (3052842) | 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:
OpenSUSE Linux 64-bit

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

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, 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

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
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 (3052842) | answered Apr 02 '13, 4:31 a.m.
I upgraded the WAS --> and it seems to have fixed all problems!!

Your answer

Register or to post your answer.