Subject MON$STATEMENTS question
Author Maya Opperman

Hi,

 

I’m not sure if this is a problem or not, but I have quite a few entries like this with NULL transaction ID’s in the MON$STATEMENTS table:

 

MON$STATEMENT_ID

460577

 

MON$ATTACHMENT_ID              

128        

 

MON$TRANSACTION_ID

NULL

 

MON$STATE

0             

 

MON$TIMESTAMP

NULL

 

MON$SQL_TEXT              

Select abc from xyz where this = that

 

MON$STAT_ID

421

 

Is this a sign that my code isn’t cleaning something up properly, or is it perfectly normal?

 

Any idea under what circumstances this will happen?

 

Thanks

Maya