Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2012
    Posts
    2

    Unanswered: cpu intensive query

    I can able to get statement text and cpu time of particular query from table function "SNAP_GET_DYN_SQL".

    But i can't able to get who is running that particular statement and from which database.

    So i used SNAP_GET_STMT table function which gives statment text with agent_id and database_name.

    But the problem is always get statment text as null from SNAP_GET_STMT table function.

    Anyone know the reason, why i am getting null value in statement text column. I am running this query on db2 v10

    And if any alternate way to get cpu intensive query with username ( who is running this query )

    Please help me on this.

    Thanks and regards
    selva

  2. #2
    Join Date
    Jun 2013
    Posts
    1
    Quote Originally Posted by selva1587 View Post
    I can able to get statement text and cpu time of particular query from table function "SNAP_GET_DYN_SQL".

    But i can't able to get who is running that particular statement and from which database.
    I was looking for the same info and I have discovered SNAP_GET_DYN_SQL does not provide that information, unfortunately. Use SNAP_GET_STMT instead.

  3. #3
    Join Date
    Jun 2014
    Posts
    1
    Great information, I have found here.

    Thanks,
    Ranlie Basas

  4. #4
    Join Date
    Oct 2014
    Posts
    1
    Anyone know the reason, why i am getting null value in statement text column???


    ------------------------
    Tazy

  5. #5
    Join Date
    Sep 2015
    Location
    Jakarta
    Posts
    2

    where answer

    Quote Originally Posted by tazy View Post
    Anyone know the reason, why i am getting null value in statement text column???


    ------------------------
    Tazy
    Hey where the expert for asnwer this question

  6. #6
    Join Date
    Oct 2007
    Posts
    52
    Provided Answers: 3
    maybe they are in the DB2 discussion forum instead of ADABAS forum. I'm sure most ADABAS folks know little to nothing about DB2 LUW.

Posting Permissions

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