Prev: System Time and Utilities Start/Stop Time
Next: Instance migrated to v9.5 / STMM and bufferpools
From: fritalian on 2 Dec 2008 17:32
I have a client application which runs on a Linux server which is
intermittently unable to connect to my database. This application is
a daemon which sits on the server and waits for a request, it then
connects to the database writes some data and disconnects. 99.99% of
the time this works great, but sometimes it fails to connect and gives
this error:

SQL0859N Access to the Transaction Manager Database failed with
SQLCODE "-30082". SQLSTATE=08502

In the DB2 Diag log on the client side, I see this:

2008-11-25-11.31.30.079895-300 I110555G278 LEVEL: Warning
PID : 8523 TID : 82168752
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:
20
DATA #1 : String, 65 bytes
Password validation for user userid failed with rc = -2146500507

This is an embedded c++ app. On the client side we have version
9.1.3a. The server is also Linux on DB2 version 9.1.5.

Anyone have any ideas on what might be going on here?

Thanks,
Greig
From: The Boss on 2 Dec 2008 19:38
fritalian(a)gmail.com wrote:
> I have a client application which runs on a Linux server which is
> intermittently unable to connect to my database. This application is
> a daemon which sits on the server and waits for a request, it then
> connects to the database writes some data and disconnects. 99.99% of
> the time this works great, but sometimes it fails to connect and gives
> this error:
>
> SQL0859N Access to the Transaction Manager Database failed with
> SQLCODE "-30082". SQLSTATE=08502
>
> In the DB2 Diag log on the client side, I see this:
>
> 2008-11-25-11.31.30.079895-300 I110555G278 LEVEL: Warning
> PID : 8523 TID : 82168752
> FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage,
> probe: 20
> DATA #1 : String, 65 bytes
> Password validation for user userid failed with rc = -2146500507
>
> This is an embedded c++ app. On the client side we have version
> 9.1.3a. The server is also Linux on DB2 version 9.1.5.
>
> Anyone have any ideas on what might be going on here?
>
> Thanks,
> Greig

Although you are on a different version, there is some similarity with the
issue described here for a 8.2 environment:
http://www.ixpub.net/thread-855396-1-336.html

(it's a Chinese forum, but luckily the main part is in English).

HTH.

--
Jeroen


 | 
Pages: 1
Prev: System Time and Utilities Start/Stop Time
Next: Instance migrated to v9.5 / STMM and bufferpools