Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    63

    Unanswered: Activity Monitor usage

    Hi,

    I am using DB2 V8.1 on windows.

    I executed drop table stmt, it is hanging fro more than 45 mins.

    I tried to figure out using Activity monitor , but could'nt find any monitoring task which can give me the process running under a particular user id.

    can anyone tell me which monitoring task to use to find all the processes running under a particular user id.

    Thx
    Mohd

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would do a:

    db2 list applications show detail

    If you application (command line session, etc) is waiting on a lock, it should tell you.

    Just to make sure that you don't wait on locks forever, you should change the LOCKTIMEOUT from -1 to 30 seconds (or something reasonable).

    db2 connnect to db-name
    db2 update db cfg using LOCKTIMEOUT 30
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2003
    Posts
    63
    Thx marcus ,

    I am able to get a list of applications connected and their status.
    But is a there a way to find out which sql statement is being exectued under each process or application.

    I want to know what each process is doing.

    Thx
    Mohd

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can do it with a GET SNAPSHOT using the APPLICATION APPLID appl-id and the DYNAMIC SQL options. See the Command Reference manual for details.

    There is also nice tool that lets you see what is going on in real-time:

    http://chuzhoi_files.tripod.com/
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jul 2003
    Posts
    63
    Thx Marcus

    This is very good tool for monitoring performance, active connections, locks , sqls in cache etc..


    Btu this is for windows only, Do we have something similar tool for Solaris?


    thx
    Mohd

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can run the tool from Windows connected to a remote DB2 database on Solaris.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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