Topic
  • 1 reply
  • Latest Post - ‏2013-11-04T16:12:55Z by Jotac
YVA1_Christian_Arnoux
6 Posts

Pinned topic SQL query corresponding to db2top lock pannel

‏2013-10-28T13:49:52Z |

Hello,

What is the SQL query I can issue again my DB2 10.1 database to get the information displayed in the db2top locks pannel.

 

I have tried to use the build-in routines and views but I am a little bit lost as I don't get the same information as displayed in db2top locks pannel.

 

Thanks a lot in advance for the help

Christian

  • Jotac
    Jotac
    82 Posts

    Re: SQL query corresponding to db2top lock pannel

    ‏2013-11-04T16:12:55Z  

     

    via db2top recording mode first then replying the binary file with "db2top -f <bin_file> -b U -A" qualifier you can have a flat text file with exactly the same "columns" of Locks Panel (at least for 9.7 FP8)

     

    hope this help

    GIovanni