Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2012
    Posts
    3

    Unanswered: DB2 list of current SQLs (tasks)

    Hello,

    I search for a possibility to see all current running SQLs. Currently we use the Iseries Navigator which has a list of "active jobs". But you can't see here the SQL which is running currently and no status about this.

    From MySQL I know that they have a tasklist where you can easily observe the current queries including username, needed time (increasing) and status (locked, write to temp table, sorting..) In background this tasklist is the sql command "show processlist".

    Does anyone one such a tool or view for DB2?
    Or how do you observe what is going on currently on the DB2 (exspecially SQL queris)?

    Kind Regards,
    Christian

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Which db2 platform?

    CA has a tool that will do this for z/OS (don't know about other platforms). IIRC it is called Insight.

  3. #3
    Join Date
    Oct 2012
    Posts
    3
    Hello, thanks - we have OS400 Version 6.1

  4. #4
    Join Date
    Oct 2012
    Posts
    3
    Unfortunately CA Insight does not run on OS400. Thanks anyway.

    Does anyone have an idea for OS400/V6.1?

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    are the views of sysibmadm available in i/series ?
    these might give the information as in luw
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Tags for this Thread

Posting Permissions

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