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.

select * from sysibmadm.snapdyn_sql

Assume I have the DYN SQL snapshot's output in a txt file.Will it be possible to convert in to TABBED EXCEL format.

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.

@nagbuchi79 Open the text file with microsoft excel

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.