Results 1 to 5 of 5

Thread: db2top

  1. #1
    Join Date
    Dec 2016
    Posts
    16

    Unanswered: db2top

    Hi All,

    I am using db2 v10.5 AES Edition. Please help me in db2top after giving the agent id (by pressing a) it displays the SQL QUERY BUT due to my screen resolution problem i am not getting the complete query in db2top.

    So please tell me is there any way to get full Sql query by using select statement.

    Thanks.

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    260
    Provided Answers: 39
    Hi,

    Look at the MON_GET_PKG_CACHE_STMT function.
    Regards,
    Mark.

  3. #3
    Join Date
    Mar 2017
    Posts
    1
    Hi,

    Perhaps, you may need to enable DB2 monitors.

    As instance owner, enter this commands:

    Code:
    db2 attach to <instance_name>
    
    db2 update dbm cfg using DFT_MON_BUFPOOL ON DFT_MON_LOCK ON DFT_MON_SORT ON DFT_MON_STMT ON DFT_MON_TABLE ON DFT_MON_UOW ON

  4. #4
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    260
    Provided Answers: 39
    No, these parameters don't have any effect on mon_* functions.
    Regards,
    Mark.

  5. #5
    Join Date
    Sep 2014
    Location
    Long Island, New York
    Posts
    29
    While viewing the query , hit 'e' for explain mode. This puts you into vi and displays the entire query formatted.

Posting Permissions

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