[cvsnt] sessionid as foreign key

[Tony Hoyle]

bwhicks at aep.com wrote:
> Hey guys, hoping someone can help here. 
> 
> I have audit logging enabled on a 2.5.03.2382 linux server. It is using 
> ODBC to connect to a DB2 database. It was working fine for a while, but 
> now all of a sudden it is inserting "0" for the session ID in tables other 
> than the sessionlog table (i.e. the taglog table). This is obviously 
> wrong, so I did a trace and where it shows the SQL statement being used to 
> insert the data, it shows a 0 being inserted there, too. 
> 
> Is CVS not getting the right sessionID from previous queries or something? 
> What could be the problem?
> 
>
It gets the session id from a 'select identity_val_local()' appended to 
the session insert string (the whole string is something like 'begin 
atomic; insert into xxxxx; select identity_val_local(); end').

I can't think of a reason why that would suddenly stop working if it 
worked before unless there's a way to switch that functionality off 
globally.

Tony