Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to email@example.com.
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