Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2016
    Posts
    4

    Unanswered: db2top batch mode

    Hello all

    I ran db2top in Batch mode:

    db2top -d ${DBNAME} -C -m ${DURATION} -i ${INTERVAL} -f ${COLLECT_FILE}

    When the run is finisched I generate than csv files from then Collect-file for the different scopes

    BP_OUT.csv
    DB_OUT.csv
    DYNSQL_OUT.csv
    FEDERATE_OUT.csv
    LOCK_OUT.csv
    MEM_OUT.csv
    SESSION_OUT.csv
    STMT_OUT.csv
    TABLE_OUT.csv
    TBSPACE_OUT.csv
    UTIL_OUT.csv



    There is a file for the Sessions (SESSION_OUT.csv) with the session-ID ("Application_Handle(Stat)")
    and there is another file with the Dynamic-SQL (DYNSQL_OUT.csv)


    Unfortunately I am not able to see which Dynamic-SQL belongs to which Session

    have someone an Idea?

    Thanks in advance
    Stravinsky

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    299
    Provided Answers: 45
    Hi,

    There is no information on sessions in the db2 package cache which contents you see in the DYNSQL_OUT.csv file. Multiple sessions can run the same statement, package cache contains aggregate metrics for each statement. But db2 doesn't maintain any list of sessions which called particular statement in the package cache.
    Regards,
    Mark.

  3. #3
    Join Date
    Nov 2016
    Posts
    4
    Hello Marc,

    thanks a lot for you reply

    best regards
    Stravinsky

Posting Permissions

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