Identify LOCKS 1

[RogerCruse]

Hi,
OK, it's idiot time, so if the answer is so obvious that I should already know, then I'll beat up the guy who asked me the question!

Seriously.

I want to, via QueryMan, identify any databases that I need to RELEASE.

Can you help?

Roger...

 

[dnoeth]

You don't have to beat anybody ;-)

Looks like you want to release backup locks...

There's no system table with info about any kind of locks (SQL/ARC/MLoad/FastLoad), you'll have to use the showlocks command line tool to display HUT locks placed by ARC.

Dieter

 

[RogerCruse]

Dieter,
Thanks for the answer, not quite what I was hoping for!

Roger...

 

[donnpascual]

Roger.

I am not sure, but I think you cannot directly
get the currently locked info through entried in
the dbc database.

although, you can get this via the show locks
utility which can be executed at the DBW Superv.
you'll get the currently locked database that
you will need to release.

Don Andres Pascual (Japan)