Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: 0 Remote connections are available - how to force inactive user from db2/vse

    Hi,

    My system
    database: DB2/VSE 7.2,
    operating system VSE/ESA 2.6,
    hardware: S/390

    On my system are some applications in DB2/VSE which don't free up connections, so database has "zombi" database agents. This application connections occupy all available remote connections.

    See the following "frame". Do you notice "0 Remote connections are available"? Do you notice there is no "User ID"?

    Code:
    User ID:        SQL ID:
    User is inactive.
    
    0 Remote users are active.
    8 Remote users are inactive.
    17 Agents are available.
    0 Remote connections are available.
    My question: how to force inactive user which does not have UserID?

    Thanks,
    Grofaty
    Last edited by grofaty; 09-03-04 at 02:32.

Posting Permissions

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