I have seen that sort of behaviour when the database access is not properly wrapped in an HNibernate transaction
John Davidson On Mon, Sep 27, 2010 at 1:11 PM, Brian <[email protected]> wrote: > First, my boss called me today and stated that one of my queries was > using 75% of the system resources on the ISeries. Then, he let me know > that my queries seem to be locking files which was preventing him from > running his queries. I do not understand why this is happening because > this has never happened before and I haven't changed anything. > > Because our sys admin doesn't have journaling turned on, I can't start/ > stop transactions so I query without that. Other than that, I am > unsure what to look for. Where should I look to handle this issues? > > Thank You. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
