• Locks can be removed manually in the JasiEventLock table with psql (on the active PP DB).
• Scripts to help with the jiggle locks are also available on aqms-bk-pp & aqms-nc-pp:

• 'showlocks' will display all the event locks on a given DB:

[aqms@aqms-bk-pp ~]$ showlocks
 Event-ID  Host                          Username  Application    Date/Time
 75006291  IGSWMKWGLTE1034               macbeth   Jiggle         2024-05-15 11:35:01.2
 75007151  IGSWMK246WE0923               macbeth-prJiggle         2024-05-15 19:36:47.1
 75002481  IGSWMKWGLTE1036               tomey     Jiggle         2024-05-15 21:46:37.1
 75002476  IGSWMKWGLTE1035               vlogan    Jiggle         2024-05-15 22:53:42.0
[aqms@aqms-bk-pp ~]$

• 'unlockevent' will clear a lock on a given DB for a given event:

[aqms@aqms-bk-pp ~]$ unlockevent -h

    Unlock a locked event.
    
    usage: /home/aqms/ncpp/bin/unlockevent [-d dbasename]  <evid> 
     
     -h        : print usage info
     -d dbase  : use this particular dbase (defaults to "archdb1")

    example: /home/aqms/ncpp/bin/unlockevent -d rtdb1 8735346
[aqms@aqms-bk-pp ~]$