Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Exclamation Unanswered: VB App freezes when querying db

    Am running a VB6 app that makes many queries to Informix 7.3 db running on Solaris 7 platform. Am noticing that we get many freezes in the application.

    Anyone have any ideas what might be causing this?

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Is it your database or your application?
    Did you check your database running transactions and sessions?
    rws

  3. #3
    Join Date
    Dec 2002
    Posts
    3
    The problem we have is that the end-users tell us about the freeze adter the event so we can not look at the transactions and sessions till after. On the few occaisions that we have been able to check, everything has looked fine.

    The crux of the problem is that we can not narrow it down to one cause. We have other apps using the same database and have tested with one on, one off e.t.c. and have had varying results on when the freezing occurs.

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Hi,

    It all depends on whether your database freezes or the application. I don't think the database freezes, so at the time the freeze is occuring you can check outstanding thatnsaction with 'onstat -x'
    'onstat -g sql' will give you an overview of all sessions.

    You can check you message log for any errors on the database level.
    onstat -p will show you the amount of lock wait, deadlocks, sequential scans etc.
    All these could cause some sort of an application freeze. In that case, you might experience locking problems or index problems or database design problems.
    rws

  5. #5
    Join Date
    Dec 2002
    Posts
    3
    Thanks. Will monitor and see what these can tell us.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •