请问一下,在DB2TOP的DYNAMIC SQL界面里SQL语句只能被显示出30个字符,请问如何根据hasvalue找出所有的statement出来呢?
SQL_Statement Sql Num Exec Avg Cpu Avg Rows
HashValue Statement (30 first char.) Execution Time ExecTime Time CpuTime read
-------------------------- ------------------------------ --------- ---------- ---------- ---------- ---------- ------------
00000004116957930013121235 select keyname,value from serv 307983674 89d 17h 0.025169 43288.0073 0.000140 8334180216
00000001243530320041651702 select * from ACTION_RECORD wh 368599816 8d 17h 0.002043 15764.1968 0.000042 368601654
00000005248468361352551512 select * from service where oi 300841432 2d 23h 0.000855 10219.4419 0.000033 300841447