Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2009
    Posts
    10

    Unanswered: Dynamic SQL snapshot to Excel sheet

    Hi ,
    I would like to read the dynamic sql snapshot output in tabular format(i.e EXCEL sheet).Can anyone please let me know how to convert the data into tabbed excel sheet.

    Thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    select * from sysibmadm.snapdyn_sql
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2009
    Posts
    10
    Assume I have the DYN SQL snapshot's output in a txt file.Will it be possible to convert in to TABBED EXCEL format.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by n_i View Post
    select * from sysibmadm.snapdyn_sql
    Do you know what time period that covers?
    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
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Marcus_A View Post
    Do you know what time period that covers?
    Since the information still comes from the same old snapshot monitor counters, I'd say from the database start time, switch activation, or monitor reset, whichever comes last.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Jun 2009
    Posts
    272
    @nagbuchi79 Open the text file with microsoft excel

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by n_i View Post
    Since the information still comes from the same old snapshot monitor counters, I'd say from the database start time, switch activation, or monitor reset, whichever comes last.
    That makes it useless IMO. I run snapshots over short intervals (about 30 minutes in production) so I can see how statements are performing in a given time window. I can compare multiple snapshots to see if the execution time for a SQL statement is increasing over time or remaining steady. I use the old-fashion get snaphot command and I can turn on and off the monitor switches and reset the monitors just for my session (not the ones in the dbm cfg, but the update monitor switches). I then have scripts that will load the output of the get snapshot into a spreadsheet.
    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
  •